Ngenisa data kubva kuOneDrive uye SharePoint kune Power Query / BI

Kana iwe kana kambani yako ukachengeta data muOneDrive gore kana muSharePoint kambani portal, kubatanidza zvakananga kwairi uchishandisa Power Query muExcel kana kubva kuPower BI zvinogona kunetsa zvinoshamisa.

Pandakambotarisana nedambudziko rakafanana, ndakashamisika kuwana kuti hapana nzira "dzepamutemo" dzekuigadzirisa. Nekuda kwechimwe chikonzero, rondedzero yeanowanikwa data masosi muExcel uye kunyangwe muPower BI (apo seti yezvibatanidza yagara yakafararira) nekuda kwechimwe chikonzero haisanganisi kugona kwekubatanidza kune OneDrive mafaera nemaforodha.

Saka sarudzo dzese dzakapihwa pazasi, kune imwe dhigirii kana imwe, "madondoro" anoda diki asi bhuku re "kupedzisa nefaira". Asi madondoro aya ane kuwedzera kukuru - anoshanda 🙂

Dambudziko nderei?

Sumo pfupi kune avo vano akapedza makore makumi maviri apfuura ari pakoma kwete munyaya.

OneDrive igore rekuchengetedza sevhisi kubva kuMicrosoft inouya mune akati wandei maflavour:

• OneDrive Personal - kune vakajairwa (vasiri vemakambani) vashandisi. Vanokupa 5GB yemahara + yekuwedzera nzvimbo yemubhadharo wepamwedzi.
• OneDrive Yebhizimisi -Sarudzo yevashandisi vemakambani uye Office 365 vanyoreri vane yakakura kwazvo inowanikwa vhoriyamu (kubva pa1TB kana kupfuura) uye mamwe maficha senge vhezheni yekuchengetedza, nezvimwe.

Mhosva yakakosha yeOneDrive yeBhizinesi iri kuchengetedza data pane SharePoint yemakambani portal - mune ino mamiriro, OneDrive iri, chokwadi, imwe yemaraibhurari eSharePoint'a.

Mafaira anogona kuwanikwa kuburikidza newebhu interface (https://onedrive.live.com saiti kana yemubatanidzwa SharePoint saiti) kana nekuyananisa maforodha akasarudzwa nePC yako:

Kazhinji maforodha aya anochengetwa muchimiro chemushandisi pane drive C - nzira inoenda kwavari inotaridzika senge C: VashandisiUsernameOneDrive) Chirongwa chakakosha chinotarisisa kukosha kwemafaira uye kuwiriranisa kwese shanduko - АOneDrive gent (ruvara rwebhuruu kana grey mukona yekurudyi yekona):

Uye zvino chinhu chikuru.

Kana isu tichida kurodha data kubva kuOneDrive kuenda kuExcel (kuburikidza nePower Query) kana kuPower BI, saka hongu tinogona kutsanangura mafaera emunharaunda nemaforodha kuti aenderane sesosi nenzira yakajairika kuburikidza. Tora data - Kubva faira - Kubva mubhuku / Kubva folda (Tora Dhata - Kubva faira - Kubva mubhuku rebasa / Folder)asi haizove yakananga link kune OneDrive gore.

Ndiko, mune ramangwana, pakuchinja, semuenzaniso, mafaera ari mugore nevamwe vashandisi, isu zvinoda kuwiriranisa kutanga (izvi zvinoitika kwenguva yakareba uye hazvisi nyore nguva dzose) uye chete wobva wagadzirisa mubvunzo wedu Power Query kana Model muSimba BI.

Sezvingatarisirwa, mubvunzo unomuka: nzira yekupinza data kubva kuOneDrive/SharePoint zvakananga kuitira kuti iyo data itakurwe zvakananga kubva mugore?

Sarudzo yekutanga: Batanidza kubhuku kubva kuOneDrive yeBhizinesi kana SharePoint

1. Isu tinovhura bhuku muExcel yedu - kopi yemuno kubva kune yakawiriraniswa OneDrive dhairekitori sefaira renguva dzose. Kana kuvhura saiti kutanga muExcel Online, wobva wadzvanya bhatani Vhura muExcel (Vhura muExcel).
2. Enda ku Faira – Details (Faira - Ruzivo)
3. Kopa nzira yegore kubhuku nebhatani kopi nzira (Kopi Nzira) mumusoro:

   

4. Mune imwe Excel faira kana muPower BI, kwaunoda kuzadza iyo data, sarudza iyo mirairo Tora data - Kubva paInternet (Tora data - Kubva pawebhu) uye namatidza nzira yakakopwa mundima yekero.
5. Delete pamagumo enzira ?dandemutande=1 uye tinya OK:

   

6. Muhwindo rinoonekwa, sarudza nzira yemvumo Sangano account (Akaundi Yesangano) uye tinya bhatani Nyorera mu (Log in):

   

   Pinda yedu yekushanda-password kana sarudza account yekambani kubva pane rondedzero inoonekwa. Kana iwe ukaita zvese nemazvo, ipapo kunyorwa Nyorera mu inofanirwa kuchinja kuita Pinda semumwe mushandisi (Pinda mukati neimwe mushandisi account).
   

7. Dzvanya pane bhatani kubatanidza (Unganidzo).
   

Zvadaro zvinhu zvose zvakafanana nezvakajairwa kutorwa kwebhuku - tinosarudza mapepa anodiwa, matafura akachenjera ekuunza kunze, nezvimwewo.

Sarudzo 2: Batanidza kune faira kubva kuOneDrive Personal

Kuti ubatanidze kubhuku mune yako wega (isiri yekambani) OneDrive gore, maitiro acho achave akasiyana:

1. Isu tinovhura zviri mukati meforodha yatinoda pawebhusaiti yeOneDrive uye totsvaga faira rakatorwa kunze kwenyika.
2. Kurudyi tinya pairi uye sarudza command ziviso (Yakaiswa) kana sarudza faira uye sarudza murairo wakafanana mune yepamusoro menyu:

   

3. Muchikamu chinooneka kurudyi, tinya bhatani sika uye kopira kodhi yakagadzirwa:

   

4.  Namira kodhi yakakopwa muNotepad uye "pedza nefaira":
   
   • Bvisa zvese kunze kwekubatanidzwa mune makotesheni
     
   • Delete block cid=XXXXXXXXXXXX&
   • Izwi rinotsiviwa kuvhara on download
   Nekuda kweizvozvo, iyo kodhi kodhi inofanirwa kutaridzika seizvi:

   

5. Zvadaro zvinhu zvose zvakafanana nenzira yapfuura. Mune imwe Excel faira kana muPower BI, kwaunoda kuzadza iyo data, sarudza iyo mirairo Tora data - Kubva paInternet (Tora data - Kubva pawebhu), isa nzira yakagadziridzwa mundima yekero uye tinya OK.
6. Kana hwindo remvumo richionekwa, sarudza sarudzo Windows uye, kana zvichidikanwa, isa password yekupinda kubva kuOneDrive.
   

Sarudzo 3: Ngenisa zviri mukati mefolda yese kubva kuOneDrive yeBhizinesi

Kana iwe uchida kuzadza Power Query kana Power BI zviri mukati kwete faira rimwe chete, asi dhairekitori rese kamwechete (semuenzaniso, nemishumo), ipapo nzira yacho ichava nyore zvishoma:

1. MuExplorer, tinya-kurudyi pane yemuno yakawiriraniswa folda yekufarira kwatiri muOneDrive uye sarudza Ona panzvimbo (Ona online).
2. Mune kero bar yebrowser, kopira chikamu chekutanga chekero - kusvika pashoko / _layouts:

   

3. Mubhuku rekushanda reExcel kwaunoda kurodha iyo data kana mune Power BI Desktop report, sarudza iyo mirairo Tora Dhata - Kubva Faira - Kubva SharePoint Folder (Tora Dhata - Kubva faira - Kubva kuSharePoint folda):

   

   Wobva waisa iyo yakakopwa nzira chidimbu mundima yekero uye tinya OK:

   

   Kana hwindo remvumo richionekwa, sarudza rudzi Microsoft account (Microsoft Account), tinya bhatani Nyorera mu (Log in), uyezve, mushure mekupinda kwakabudirira, pane bhatani kubatanidza (Unganidzo):

   

4. Mushure meizvozvo, mafaera ese kubva kuSharePoint anokumbirwa uye kutorwa uye hwindo rekuona rinoonekwa, kwaunogona kudzvanya zvakachengeteka. Shandura Data (Shandura data).
   
5. Kumwe kugadzirisa kweiyo runyorwa rweese mafaera uye kubatanidzwa kwawo kunoitika kare muSimba Query kana muPower BI nenzira yakajairwa. Kupfupisa denderedzwa rekutsvaga chete kune folda yatinoda, unogona kushandisa sefa nekoramu Folder Nzira (1) wobva wawedzera zvese zviri mukati memafaira akawanikwa uchishandisa bhatani riri mukoramu gutsikana (2):

   

• Kuunganidza matafura kubva akasiyana mafaera uchishandisa Power Query
• Chii chinonzi Power Query, Power Pivot, Power BI uye kuti vangakubatsira sei
• Kuunganidza data kubva pamapepa ese ebhuku mune imwe tafura