Forum Discussion

thorrrr's avatar
thorrrr
Helper I
9 years ago

Power Query Source Links Errors how to fix?

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

Need Help

6 Replies

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee
    9 years ago
    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?
    • thorrrr's avatar
      thorrrr
      Helper I
      9 years ago

      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. :(

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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