Ngenisa idatha ukusuka ku-OneDrive naku-SharePoint ku-Power Query / BI

Uma wena noma inkampani yakho nigcina idatha efwini le-OneDrive noma kuphothali yenkampani ye-SharePoint, ukuxhuma kuyo ngokuqondile usebenzisa Umbuzo Wamandla ku-Excel noma ku-Power BI kungaba inselele ngokumangalisayo.

Lapho ngake ngabhekana nenkinga efanayo, ngamangala ukuthola ukuthi azikho izindlela “ezingokomthetho” zokuyixazulula. Ngesizathu esithile, uhlu lwemithombo yedatha etholakalayo ku-Excel ngisho naku-Power BI (lapho isethi yezixhumi ngokuvamile ibanzi) ngesizathu esithile alifaki ikhono lokuxhuma kumafayela namafolda e-OneDrive.

Ngakho-ke zonke izinketho ezinikezwa ngezansi, ngokwezinga elithile noma kwelinye, "izinduku" ezidinga "ukuqeda ngefayela" okuncane kodwa okwenziwa ngesandla. Kodwa lezi zinduku zinenzuzo enkulu - ziyasebenza 🙂

Yini inkinga?

Isingeniso esifushane salabo aba iminyaka engu-20 edlule ekwi-coma hhayi endabeni.

I-OneDrive iyisevisi yokugcina amafu evela ku-Microsoft eza ngezindlela eziningi:

• I-OneDrive Personal - kubasebenzisi abajwayelekile (okungebona abenkampani). Bakunikeza u-5GB mahhala + isikhala esengeziwe ngenkokhelo encane yanyanga zonke.
• I-OneDrive yeBhizinisi - inketho yabasebenzisi bezinkampani nababhalisile be-Office 365 enevolumu etholakalayo enkulu kakhulu (kusuka ku-1TB noma ngaphezulu) nezici ezengeziwe ezifana nokugcinwa kwenguqulo, njll.

Icala elikhethekile le-OneDrive Yebhizinisi ligcina idatha kuphothali yebhizinisi ye-SharePoint - kulesi simo, i-OneDrive, empeleni, ingenye yemitapo yolwazi ye-SharePoint'a.

Amafayela angafinyelelwa ngokusebenzisa isixhumi esibonakalayo sewebhu (https://onedrive.live.com site noma isayithi ye-SharePoint yenkampani) noma ngokuvumelanisa amafolda akhethiwe ne-PC yakho:

Ngokuvamile lawa mafolda agcinwa kuphrofayela yomsebenzisi kudrayivu C - indlela eya kuwo ibukeka ngathi C: AbasebenzisiIgama lomsebenzisiI-OneDrive). Uhlelo olukhethekile luqapha ukuhambisana kwamafayela nokuvumelanisa zonke izinguquko - АUmphathi we-OneDrive (ifu eliluhlaza noma elimpunga ekhoneni elingezansi kwesokudla kwesikrini):

Futhi manje into esemqoka.

Uma sidinga ukulayisha idatha isuka ku-OneDrive iye ku-Excel (nge-Power Query) noma ku-Power BI, khona-ke singacacisa amafayela endawo namafolda azovunyelaniswa njengomthombo ngendlela evamile Thola idatha - Kusuka kufayela - Kusuka encwadini / Kusuka kufolda (Thola Idatha - Kusuka kufayela - Kusuka encwadini yokusebenzela / Ifolda)Kodwa ngeke kube isixhumanisi esiqondile sefu le-OneDrive.

Okusho ukuthi, esikhathini esizayo, lapho ushintsha, isibonelo, amafayela efwini ngabanye abasebenzisi, thina udinga ukuvumelanisa kuqala (lokhu kwenzeka isikhathi eside futhi akulula ngaso sonke isikhathi) futhi kuphela bese ubuyekeza umbuzo wethu Umbuzo Wamandla noma Imodeli ku-Power BI.

Ngokwemvelo, umbuzo uphakama: uyingenisa kanjani idatha isuka ku-OneDrive/SharePoint ngokuqondile ukuze idatha ilayishwe ngokuqondile efwini?

Inketho 1: Xhuma ebhukwini elisuka ku-OneDrive Yebhizinisi noma i-SharePoint

1. Sivula incwadi ku-Excel yethu - ikhophi yasendaweni esuka kufolda ye-OneDrive evumelanisiwe njengefayela elivamile. Noma vula isiza kuqala ku-Excel Online, bese uchofoza inkinobho Vula ku-Excel (Vula ku-Excel).
2. Iya ku Ifayela – Imininingwane (Ifayela — Ulwazi)
3. Kopisha indlela yefu eya ebhukwini ngenkinobho kopisha indlela (Kopisha Indlela) esihlokweni:

   

4. Kwelinye ifayela le-Excel noma ku-Power BI, lapho ufuna ukugcwalisa idatha, khetha imiyalo Thola idatha - Ku-inthanethi (Thola Idatha - Kusuka kuwebhu) bese unamathisele indlela ekopishiwe endaweni yekheli.
5. Susa ekugcineni kwendlela ?iwebhu=1 bese uchofoza OK:

   

6. Efasiteleni elivelayo, khetha indlela yokugunyaza I-akhawunti yenhlangano (I-akhawunti Yenhlangano) bese uchofoza inkinobho Ngena ngemvume (Ngena ngemvume):

   

   Faka iphasiwedi yethu yokungena esebenzayo noma khetha i-akhawunti yebhizinisi ohlwini oluvelayo. Uma wenza konke kahle, khona-ke umbhalo Ngena ngemvume kufanele iguqulele ku- Ngena ngemvume njengomsebenzisi ohlukile (Ngena ngemvume ngenye i-akhawunti yomsebenzisi).
   

7. Chofoza inkinobho Uxhumano (Xhuma).
   

Khona-ke yonke into iyafana nokungenisa okuvamile kwencwadi - sikhetha amashidi adingekayo, amatafula ahlakaniphile okungenisa, njll.

Inketho 2: Xhuma kufayela elisuka ku-OneDrive Personal

Ukuze uxhumeke encwadini efwini lomuntu siqu (okungelona elebhizinisi) le-OneDrive, indlela izohluka:

1. Sivula okuqukethwe kwefolda esiyifunayo kuwebhusayithi ye-OneDrive futhi sithole ifayela elingenisiwe.
2. Chofoza kuso bese ukhetha umyalo Isingeniso (Shumeka) noma khetha ifayela bese ukhetha umyalo ofanayo kwimenyu ephezulu:

   

3. Kuphaneli evela kwesokudla, chofoza inkinobho Dala bese ukopisha ikhodi ekhiqiziwe:

   

4.  Namathisela ikhodi ekopishiwe ku-Notepad futhi "uqede ngefayela":
   
   • Susa yonke into ngaphandle kwesixhumanisi esikucaphuni
     
   • Susa ibhulokhi cid=XXXXXXXXXXXX&
   • Igama elingashintshwa Shumeka on thwebula
   Ngenxa yalokho, ikhodi yomthombo kufanele ibukeke kanje:

   

5. Khona-ke konke kuyafana nendlela yangaphambilini. Kwelinye ifayela le-Excel noma ku-Power BI, lapho ufuna ukugcwalisa idatha, khetha imiyalo Thola idatha - Ku-inthanethi (Thola Idatha - Kusuka kuwebhu), namathisela indlela ehleliwe endaweni yekheli bese uchofoza okuthi KULUNGILE.
6. Lapho kuvela iwindi lokugunyazwa, khetha inketho Windows futhi, uma kunesidingo, faka iphasiwedi yokungena ku-OneDrive.
   

Inketho yesi-3: Ngenisa okuqukethwe kwefolda yonke ukusuka ku-OneDrive Yebhizinisi

Uma udinga ukugcwalisa Umbuzo Wamandla noma i-Power BI okuqukethwe kwefayela elilodwa, kodwa ifolda yonke ngesikhathi esisodwa (isibonelo, ngemibiko), indlela izoba lula kancane:

1. Ku-Explorer, chofoza kwesokudla kufolda yasendaweni evumelanisiwe oyithandayo ku-OneDrive bese ukhetha Buka esizeni (Buka ku-inthanethi).
2. Kubha yekheli lesiphequluli, kopisha ingxenye yokuqala yekheli - kuze kufike egameni / _izakhiwo:

   

3. Encwadini yokusebenzela ye-Excel lapho ufuna ukulayisha khona idatha noma embikweni we-Power BI Desktop, khetha imiyalo Thola Idatha - Kusuka Efayeleni - Kusuka Kufolda Ye-SharePoint (Thola Idatha - Kusuka kufayela - Kusuka kufolda ye-SharePoint):

   

   Bese unamathisela isinqamu sendlela ekopishiwe endaweni yekheli bese uchofoza OK:

   

   Uma kuvela iwindi lokugunyazwa, khetha uhlobo I-akhawunti ye-Microsoft (I-Akhawunti ye-Microsoft), chofoza inkinobho Ngena ngemvume (Ngena ngemvume), bese, ngemva kokungena ngemvume ngempumelelo, enkinobheni Uxhumano (Xhuma):

   

4. Ngemuva kwalokho, wonke amafayela avela ku-SharePoint ayacelwa futhi alandwe futhi kuvela iwindi lokubuka kuqala, lapho ungachofoza khona ngokuphephile. Guqula Idatha (Guqula Idatha).
   
5. Ukuhlelwa okwengeziwe kohlu lwawo wonke amafayela nokuhlanganiswa kwawo kwenzeka kakade kokuthi Umbuzo Wamandla noma ku-Power BI ngendlela evamile. Ukuze unciphise umbuthano wokusesha uye kufolda kuphela esiyidingayo, ungasebenzisa isihlungi ngekholomu Indlela Yefolda (1) bese unweba konke okuqukethwe kwamafayela atholiwe usebenzisa inkinobho ekukholamu Okuqukethwe (2):

   

• Ukuhlanganisa amatafula avela kumafayela ahlukene kusetshenziswa Umbuzo Wamandla
• Uyini Umbuzo Wamandla, I-Power Pivot, Power BI nokuthi zingakusiza kanjani
• Iqoqa idatha kusuka kuwo wonke amashidi encwadi etafuleni elilodwa