Power Query Source Links Errors how to fix?

[thorrrr]

HI Guys

I have several Excel workbooks stored in OneDrive which I access in my home via Desktop or Laptop. I have noticed when I open my files on my laptop all my power query error as the link to the folder is based on my Desktop.I would have thought using Onedrive to store all my files it would work on any machine. What am I doing wrong I am not trying to share with other just myself.
I have seen several very convoluted ways to share with other team members. But mine is not that just myself using the same OneDrive account.

Thorrrr

[v-shex-msft]

Hi @thorrrr,

If you want to get data from onedrive, you can take a look at below article:

Use OneDrive for Business links in Power BI Desktop

If above is not help, can you please share some detail content of your issue, it will be help for troubleshooting.

Regards,
Xiaoxin Sheng

[thorrrr]

I have already read this yesterday and tried it but it no longer works. My links are to folders with multiple CSV files in. These folders do not work with resid or id. I cannot believe something as basic as people on the move wanting to use does not work with OneDrive or you have to go round the houses. I would go round the houses but it will not work for me I do not get the same URL for folders with files in. 😞

[v-shex-msft]

Hi @thorrrr,

If you can't use resin to get data from onedrive, you can try to refer to below link which about use sharepoint connector to get data from onedrive:(i test to get data with my organization account)

Get Data From OneDrive for Business

Regards,

Xiaoxin Sheng

[thorrrr]

HI

I only have OneDrive personal i do not have access to Sharepoint i work from home not part of a business:)

[v-shex-msft]

Hi @thorrrr,

You can follow below link to get data from onedrive personal.

Use OneDrive links in Power BI Desktop

Regards,

Xiaoxin Sheng

[dkay84_PowerBI]

What is the error message? Have you stepped through your query editor steps to confirm the error is with the source step? Have you checked the data source settings to see if you need to re-authorize on your second machine?