Ntshuam cov ntaub ntawv los ntawm OneDrive thiab SharePoint rau Power Query / BI

Yog tias koj lossis koj lub tuam txhab khaws cov ntaub ntawv hauv OneDrive huab lossis hauv SharePoint lub tuam txhab portal, txuas ncaj qha mus rau nws siv Power Query hauv Excel lossis los ntawm Power BI tuaj yeem ua rau xav tsis thoob.

Thaum kuv ib zaug ntsib qhov teeb meem zoo sib xws, kuv xav tsis thoob thaum pom tias tsis muaj "kev cai lij choj" los daws nws. Rau qee qhov laj thawj, cov npe ntawm cov ntaub ntawv muaj nyob hauv Excel thiab txawm tias hauv Power BI (qhov twg cov txheej txheem txuas yog ib txwm dav dua) rau qee qhov laj thawj tsis suav nrog kev muaj peev xwm txuas rau OneDrive cov ntaub ntawv thiab cov folders.

Yog li tag nrho cov kev xaiv muaj hauv qab no yog, rau ib qib lossis lwm qhov, "crutches" uas xav tau me me tab sis phau ntawv "ua tiav nrog cov ntaub ntawv". Tab sis cov crutches no muaj qhov loj ntxiv - lawv ua haujlwm 🙂

Qhov teeb meem zoo li cas?

Ib qho kev qhia luv luv rau cov uas siv 20 xyoo dhau los hauv kev tsis nco qab tsis nyob rau hauv qhov kev kawm.

OneDrive yog huab cia kev pabcuam los ntawm Microsoft uas los ntawm ntau yam:

• OneDrive tus kheej - rau cov neeg siv zoo tib yam (tsis yog koom nrog). Lawv muab rau koj 5GB dawb + qhov chaw ntxiv rau tus nqi me me.
• OneDrive rau Kev Lag Luam - ib qho kev xaiv rau cov neeg siv khoom lag luam thiab Office 365 cov neeg siv khoom nrog ntau qhov ntim ntau dua (los ntawm 1TB lossis ntau dua) thiab cov yam ntxwv ntxiv xws li cov ntawv khaws cia, thiab lwm yam.

Ib rooj plaub tshwj xeeb ntawm OneDrive rau Kev Lag Luam yog khaws cov ntaub ntawv ntawm SharePoint cov chaw lag luam - hauv qhov xwm txheej no, OneDrive yog, qhov tseeb, yog ib lub tsev qiv ntawv ntawm SharePoint'a.

Cov ntaub ntawv tuaj yeem nkag mus tau los ntawm lub vev xaib interface (https://onedrive.live.com site lossis koom nrog SharePoint site) lossis los ntawm synchronizing xaiv folders nrog koj lub PC:

Feem ntau cov folders no khaws cia rau hauv cov neeg siv profile ntawm tsav C - txoj hauv kev rau lawv zoo li ib yam dab tsi C: Cov neeg sivUsernameOneDrive). Ib txoj haujlwm tshwj xeeb saib xyuas qhov cuam tshuam ntawm cov ntaub ntawv thiab synchronization ntawm txhua qhov kev hloov pauv - АOneDrive neeg (xiav lossis grey huab nyob rau sab xis sab xis ntawm lub vijtsam):

Thiab tam sim no qhov tseem ceeb tshaj plaws.

Yog tias peb yuav tsum thauj cov ntaub ntawv los ntawm OneDrive rau Excel (ntawm Power Query) lossis rau Power BI, peb tuaj yeem hais qhia cov ntaub ntawv hauv zos thiab cov folders kom synchronized raws li qhov niaj zaus ntawm txoj kev. Tau txais cov ntaub ntawv - Los ntawm cov ntaub ntawv - Los ntawm phau ntawv / Los ntawm nplaub tshev (Tau txais cov ntaub ntawv - Los ntawm cov ntaub ntawv - Los ntawm phau ntawv ua haujlwm / Folder)Tab sis nws yuav tsis yog qhov txuas ncaj qha rau OneDrive huab.

Ntawd yog, yav tom ntej, thaum hloov pauv, piv txwv li, cov ntaub ntawv hauv huab los ntawm lwm tus neeg siv, peb yuav tsum tau sync ua ntej (qhov no tshwm sim rau lub sijhawm ntev thiab tsis yog ib txwm yooj yim) thiab nkaus xwb tom qab ntawd hloov kho peb cov lus nug Power Query lossis Model hauv Power BI.

Lawm, lo lus nug tshwm sim: Yuav ua li cas import cov ntaub ntawv los ntawm OneDrive / SharePoint ncaj qha kom cov ntaub ntawv thauj khoom ncaj qha los ntawm huab?

Kev xaiv 1: Txuas rau phau ntawv los ntawm OneDrive rau Kev Lag Luam lossis SharePoint

1. Peb qhib phau ntawv hauv peb Excel - ib daim ntawv luam hauv zos los ntawm synchronized OneDrive nplaub tshev raws li cov ntaub ntawv tsis tu ncua. Los yog qhib lub xaib ua ntej hauv Excel Online, thiab tom qab ntawd nyem rau ntawm lub pob Qhib hauv Excel (Qhib hauv Excel).
2. mus rau Cov ntaub ntawv – Paub meej (Cov ntaub ntawv - Info)
3. Luam txoj kev huab rau phau ntawv nrog lub pob luam txoj (Copy Txoj Kev) hauv lub npe:

   

4. Hauv lwm cov ntaub ntawv Excel lossis hauv Power BI, qhov twg koj xav sau cov ntaub ntawv, xaiv cov lus txib Tau txais cov ntaub ntawv - Los ntawm Is Taws Nem (Tau txais cov ntaub ntawv - Los ntawm lub vev xaib) thiab paste txoj kev theej rau hauv qhov chaw nyob.
5. Tshem tawm ntawm qhov kawg ntawm txoj kev ?web=1 thiab nias rau OK:

   

6. Hauv qhov rai uas tshwm, xaiv txoj kev tso cai Koom haum tus account (Lub koom haum Account) thiab nyem rau ntawm lub pob kos npe rau Nyob rau hauv (Tau rau hauv):

   

   Nkag mus rau peb tus lej nkag mus ua haujlwm-tus password lossis xaiv tus lej koom nrog los ntawm cov npe uas tshwm. Yog tias koj ua txhua yam zoo, ces cov ntawv sau kos npe rau Nyob rau hauv yuav tsum hloov pauv mus Sau npe rau hauv raws li tus neeg siv sib txawv (Xa mus rau lwm tus neeg siv tus account).
   

7. Nyem rau feem khawm kev twb kev txuas (Txuas).
   

Tom qab ntawd txhua yam zoo ib yam li cov ntaub ntawv ntshuam ib txwm muaj - peb xaiv cov ntawv tsim nyog, cov ntxhuav ntse rau ntshuam, thiab lwm yam.

Kev xaiv 2: Txuas rau cov ntaub ntawv los ntawm OneDrive Tus Kheej

Txhawm rau txuas rau phau ntawv hauv tus kheej (tsis yog koom nrog) OneDrive huab, txoj hauv kev yuav txawv:

1. Peb qhib cov ntsiab lus ntawm cov ntawv tais ceev tseg ntawm OneDrive lub vev xaib thiab nrhiav cov ntaub ntawv nkag.
2. Txoj nyem rau ntawm nws thiab xaiv cov lus txib Introduction (Embedded) lossis xaiv cov ntaub ntawv thiab xaiv cov lus txib zoo sib xws hauv cov ntawv qhia zaub mov saum toj kawg nkaus:

   

3. Hauv lub vaj huam sib luag uas tshwm ntawm sab xis, nyem lub pob tsim thiab luam cov code generated:

   

4.  Muab cov lej theej rau hauv Notepad thiab "ua tiav nrog cov ntaub ntawv":
   
   • Tshem tawm txhua yam tshwj tsis yog qhov txuas hauv quotes
     
   • Tshem tawm qhov thaiv cid=XXXXXXXXXXXX&
   • Hloov lo lus embed on download
   Yog li ntawd, lub hauv paus code yuav tsum zoo li no:

   

5. Ces txhua yam zoo ib yam li hauv txoj kev dhau los. Hauv lwm cov ntaub ntawv Excel lossis hauv Power BI, qhov twg koj xav sau cov ntaub ntawv, xaiv cov lus txib Tau txais cov ntaub ntawv - Los ntawm Is Taws Nem (Tau txais cov ntaub ntawv - Los ntawm lub vev xaib), paste txoj kev kho rau hauv qhov chaw nyob thiab nyem OK.
6. Thaum lub qhov rais tso cai tshwm, xaiv qhov kev xaiv lub qhov rais thiab, yog tias tsim nyog, nkag mus rau tus password nkag los ntawm OneDrive.
   

Kev xaiv 3: Ntshuam cov ntsiab lus ntawm tag nrho cov ntawv tais ceev tseg los ntawm OneDrive rau Kev Lag Luam

Yog tias koj xav tau sau rau hauv Power Query lossis Power BI cov ntsiab lus ntawm tsis yog ib daim ntawv, tab sis tag nrho cov ntawv tais ceev tseg ib zaug (piv txwv li, nrog cov ntawv ceeb toom), ces txoj hauv kev yuav yooj yim me ntsis:

1. Hauv Explorer, right-click ntawm lub zos synchronized folder uas txaus siab rau peb hauv OneDrive thiab xaiv Saib ntawm qhov chaw (Saib online).
2. Hauv qhov chaw nyob bar ntawm qhov browser, luam qhov pib ntawm qhov chaw nyob - mus rau lo lus /_layouts:

   

3. Hauv Excel phau ntawv uas koj xav thauj cov ntaub ntawv lossis hauv Power BI Desktop daim ntawv qhia, xaiv cov lus txib Tau cov ntaub ntawv - Los ntawm cov ntaub ntawv - Los ntawm SharePoint Folder (Tau txais cov ntaub ntawv - Los ntawm cov ntaub ntawv - Los ntawm SharePoint nplaub tshev):

   

   Tom qab ntawd muab tshuaj txhuam txoj kab uas hla mus rau hauv qhov chaw nyob thiab nyem OK:

   

   Yog tias lub qhov rais tso cai tshwm, ces xaiv hom Microsoft account (Microsoft Account), nyem rau ntawm lub pob kos npe rau Nyob rau hauv (Tau rau hauv), thiab tom qab ntawd, tom qab kev nkag mus tau zoo, ntawm lub pob kev twb kev txuas (Txuas):

   

4. Tom qab ntawd, tag nrho cov ntaub ntawv los ntawm SharePoint tau thov thiab rub tawm thiab lub qhov rais saib ua ntej tshwm, qhov twg koj tuaj yeem nyem rau ntawm Hloov cov ntaub ntawv (Cov ntaub ntawv hloov pauv).
   
5. Kev kho ntxiv ntawm cov npe ntawm tag nrho cov ntaub ntawv thiab lawv cov kev sib koom ua ke tau tshwm sim nyob rau hauv Power Query lossis hauv Power BI hauv txoj hauv kev. Txhawm rau nqaim lub voj voog tshawb nrhiav tsuas yog mus rau lub nplaub tshev peb xav tau, koj tuaj yeem siv cov lim los ntawm kab Nplaub tshev Path (1) thiab tom qab ntawd nthuav tag nrho cov ntsiab lus ntawm cov ntaub ntawv pom siv lub pob hauv kab Cov ntsiab lus (2):

   

• Sib sau cov rooj los ntawm cov ntaub ntawv sib txawv siv Power Query
• Power Query, Power Pivot, Power BI yog dab tsi thiab lawv tuaj yeem pab koj li cas
• Sau cov ntaub ntawv los ntawm txhua nplooj ntawv ntawm phau ntawv rau hauv ib lub rooj