Hoʻokomo i ka ʻikepili mai OneDrive a me SharePoint i Power Query / BI

Inā mālama ʻoe a i ʻole kāu hui i ka ʻikepili ma ke ao OneDrive a i ʻole ma kahi waihona ʻoihana SharePoint, ʻo ka hoʻopili pololei ʻana iā ia me ka hoʻohana ʻana i ka Power Query ma Excel a i ʻole mai Power BI hiki ke paʻakikī.

I koʻu wā i kū ai i kahi pilikia like, ua kahaha wau i ka ʻike ʻana ʻaʻohe ala "kūpono" e hoʻoponopono ai. No kekahi kumu, ʻo ka papa inoa o nā kumu ʻikepili i loaʻa ma Excel a hiki i ka Power BI (kahi i ʻoi aku ka laulā o nā mea hoʻohui) no kekahi kumu ʻaʻole i komo i ka hiki ke hoʻopili i nā faila OneDrive a me nā waihona.

No laila, ʻo nā koho a pau i hāʻawi ʻia ma lalo nei, i kekahi degere a i ʻole, "crutches" e koi ana i kahi liʻiliʻi akā manual "hoʻopau me kahi faila". Akā ʻoi aku ka nui o kēia mau koʻokoʻo - hana lākou 🙂

He aha ka pilikia?

He hoʻolauna pōkole no ka poʻe ua hala nā makahiki he 20 i hala i loko o kahi coma ʻaʻole ma ke kumuhana.

ʻO OneDrive kahi lawelawe mālama kapua mai Microsoft e hele mai ana i nā ʻono he nui:

• OneDrive Personal - no nā mea hoʻohana maʻamau (ʻaʻole hui). Hāʻawi lākou iā ʻoe i ka 5GB no ka manuahi + wahi hou no kahi uku liʻiliʻi o kēlā me kēia mahina.
• OneDrive no ka Pāʻoihana - he koho no nā mea hoʻohana hui a me nā mea kākau inoa Office 365 me ka nui o ka nui i loaʻa (mai ka 1TB a i ʻole) a me nā hiʻohiʻona hou e like me ka waiho ʻana o ka mana, etc.

ʻO kahi hihia kūikawā o OneDrive for Business ke mālama nei i ka ʻikepili ma kahi waihona ʻoihana SharePoint - ma kēia hiʻohiʻona, ʻo OneDrive kekahi o nā hale waihona puke o SharePointʻa.

Hiki ke kiʻi ʻia nā faila ma o ka punaewele (https://onedrive.live.com pūnaewele a i ʻole ka hui SharePoint pūnaewele) a i ʻole ma ka hoʻonohonoho ʻana i nā waihona i koho ʻia me kāu PC:

ʻO ka maʻamau, mālama ʻia kēia mau waihona ma ka ʻaoʻao mea hoʻohana ma ka drive C - ʻano like ke ala e hele ai iā lākou C: Nā mea hoʻohanainoa mea hoʻohanaOneDrive). Ke nānā nei kahi papahana kūikawā i ka pili o nā faila a me ka hoʻonohonoho ʻana i nā loli āpau - АOneDrive gent (ʻulaʻula a hina hina paha ma ka ʻaoʻao ʻākau o ka pale):

A i kēia manawa ka mea nui.

Inā pono mākou e hoʻouka i ka ʻikepili mai OneDrive i Excel (ma Power Query) a i ʻole Power BI, a laila hiki iā mākou ke kuhikuhi i nā faila a me nā waihona i hoʻonohonoho ʻia ma ke ʻano he kumu ma ke ʻano maʻamau. E kiʻi i ka ʻikepili - Mai ka faila - Mai ka puke / Mai ka waihona (E kiʻi i ka ʻikepili - Mai ka faila - Mai ka puke hana / waihona)aka, ʻaʻole ia he loulou pololei i ke ao OneDrive.

ʻO ia, i ka wā e hiki mai ana, i ka wā e hoʻololi ai, no ka laʻana, nā faila i ke ao e nā mea hoʻohana ʻē aʻe, mākou pono e hana mua (hiki kēia i ka manawa lōʻihi a ʻaʻole maʻalahi mau) a wale nō a laila hōʻano hou i kā mākou nīnau Nīnau Mana a i ʻole Model ma Power BI.

ʻO ka mea maʻamau, kū mai ka nīnau: Pehea e hoʻokomo pololei ai i ka ʻikepili mai OneDrive/SharePoint i hoʻouka pololei ʻia ka ʻikepili mai ke ao?

Koho 1: Hoʻohui i kahi puke mai OneDrive for Business a i ʻole SharePoint

1. Wehe mākou i ka puke ma kā mākou Excel - he kope kūloko mai ka waihona OneDrive i hoʻonohonoho ʻia ma ke ʻano he faila maʻamau. A i ʻole e wehe mua i ka pūnaewele ma Excel Online, a laila kaomi i ke pihi Wehe ma Excel (Wehe ma Excel).
2. E hele Kōnae - Nā kikoʻī (Pila - ʻIke)
3. E kope i ke ala ao i ka puke me ke pihi ala kope (Ala kope) ma ka inoa:

   

4. Ma kahi faila Excel a i ʻole Power BI, kahi āu e makemake ai e hoʻopiha i ka ʻikepili, koho i nā kauoha E kiʻi i ka ʻikepili - Mai ka Pūnaewele (E kiʻi i ka ʻikepili - Mai ka pūnaewele) a hoʻopili i ke ala kope i loko o ke kahua helu wahi.
5. Holoi ma ka hope o ke ala ?pūnaewele=1 ae kaomi ma OK:

   

6. Ma ka puka aniani e hōʻike ʻia, koho i ke ala ʻae mooolelo hui (Helu Hui) a kaomi ma ke pihi Haʻalele In (E ʻeʻe):

   

   E hoʻokomo i kā mākou login-password a koho i kahi moʻokāki hui mai ka papa inoa i hōʻike ʻia. Inā hana pono ʻoe i nā mea āpau, a laila ka palapala Haʻalele In pono e hoʻololi i E ʻeʻe ma ke ʻano he mea hoʻohana ʻē aʻe (E ʻeʻe me ka moʻokāki mea hoʻohana ʻē aʻe).
   

7. Kaomi ma ka pihi pili ana (Hoʻohui).
   

A laila ua like nā mea a pau me ka lawe maʻamau o kahi puke - koho mākou i nā pepa pono, nā papa akamai no ka lawe ʻana mai, etc.

Koho 2: Hoʻohui i kahi faila mai OneDrive Personal

No ka hoʻopili ʻana i kahi puke ma kahi ao OneDrive pilikino (non-corporate), ʻokoʻa ke ala:

1. Wehe mākou i nā mea o ka waihona i makemake ʻia ma ka pūnaewele OneDrive a loaʻa ka faila i lawe ʻia.
2. Kaomi pololei ma luna o ia a koho i ke kauoha Introduction (Hoʻokomo) a i ʻole koho i ka faila a koho i kahi kauoha like ma ka papa kuhikuhi luna:

   

3. Ma ka ʻaoʻao i ʻike ʻia ma ka ʻākau, kaomi i ke pihi Hoʻoulu a kope i ke code i hana ʻia:

   

4.  Hoʻopili i ke code i kope ʻia i ka Notepad a "hoʻopau me kahi faila":
   
   • Wehe i nā mea a pau koe wale ka loulou i loko o nā huaʻōlelo
     
   • Holoi i ka poloka cid=XXXXXXXXXXXX&
   • ʻŌlelo hiki ke pani ʻia kauʻia on manual
   ʻO ka hopena, e like ke ʻano o ke code kumu:

   

5. A laila ua like nā mea a pau me ke ʻano ma mua. Ma kahi faila Excel a i ʻole Power BI, kahi āu e makemake ai e hoʻopiha i ka ʻikepili, koho i nā kauoha E kiʻi i ka ʻikepili - Mai ka Pūnaewele (E kiʻi i ka ʻikepili - Mai ka pūnaewele), hoʻopili i ke ala i hoʻoponopono ʻia i loko o ke kahua helu wahi a kaomi iā OK.
6. Ke ʻike ʻia ka puka makani ʻae, koho i ke koho Windows a, inā pono, e hoʻokomo i ka ʻōlelo huna mai OneDrive.
   

Koho 3: Hoʻokomo i nā ʻike o kahi waihona holoʻokoʻa mai OneDrive for Business

Inā pono ʻoe e hoʻopiha i ka Power Query a i ʻole Power BI i nā ʻike o hoʻokahi faila, akā he waihona holoʻokoʻa i ka manawa hoʻokahi (no ka laʻana, me nā hōʻike), a laila e maʻalahi ke ala:

1. Ma Explorer, kaomi ʻākau ma ka waihona i hoʻonohonoho ʻia o ka makemake iā mākou ma OneDrive a koho Nānā ma ka pūnaewele (Nānā ma ka pūnaewele).
2. Ma ka helu wahi o ka polokalamu kele pūnaewele, kope i ka hapa mua o ka helu wahi - a hiki i ka huaʻōlelo / _hoʻonohonoho:

   

3. Ma ka puke hana Excel kahi āu e makemake ai e hoʻouka i ka ʻikepili a i ʻole ma ka hōʻike Power BI Desktop, koho i nā kauoha E kiʻi i ka ʻikepili - mai ka faila - mai SharePoint Folder (E kiʻi i ka ʻikepili - Mai ka faila - Mai SharePoint folder):

   

   A laila e hoʻopili i ka ʻāpana ala i kope ʻia i loko o ke kahua helu wahi a kaomi OK:

   

   Inā ʻike ʻia kahi puka makani ʻae, a laila koho i ke ʻano Pūnaewele Microsoft (Microsoft Account), kaomi ma ke pihi Haʻalele In (E ʻeʻe), a laila, ma hope o ka hoʻokomo ʻana, ma ke pihi pili ana (Hoʻohui):

   

4. Ma hope o kēlā, noi ʻia nā faila a pau mai SharePoint a hoʻoiho ʻia a ʻike ʻia kahi puka aniani, kahi e hiki ai iā ʻoe ke kaomi palekana. Hoʻololi i ka ʻikepili (Hoʻololi i ka ʻikepili).
   
5. ʻO ka hoʻoponopono hou aʻe o ka papa inoa o nā faila āpau a me kā lākou hui ʻana i hana ʻia ma Power Query a i ʻole Power BI ma ke ala maʻamau. No ka hōʻemi ʻana i ka pōʻai huli wale nō i ka waihona a mākou e pono ai, hiki iā ʻoe ke hoʻohana i ka kānana ma ke kolamu Ala Folder (1) a laila e hoʻonui i nā ʻike holoʻokoʻa o nā faila i loaʻa me ka pihi ma ke kolamu maʻiʻo (2):

   

• ʻO ka hōʻuluʻulu ʻana i nā papa mai nā faila like ʻole me ka Power Query
• He aha ka Power Query, Power Pivot, Power BI a pehea e hiki ai iā lākou ke kōkua iā ʻoe
• ʻOhi ʻikepili mai nā pepa a pau o ka puke i hoʻokahi papa