Forum Discussion

Andrew750's avatar
Andrew750
Copper Contributor
Sep 01, 2022
Solved

Unable to connect error, Query other workbook table

Hello, I am refreshing data from a table in a separate workbook located in the same folder on a SharePoint site through a power query editor, query.   I have closed the source file and tried to con...
BI & Data Analysis
  • Andrew750's avatar
    Andrew750
    Sep 01, 2022

    So I found a solution, I change the source path to point to the web version rather than the synced pc version. I used this youtube video 4 minutes long, very easy,
    https://youtu.be/InnSfyoOt5Y

     

    To access for the table for the first time I duplicated another connection which I had changed to web source then changed the web path in the Source step and the table name in the Navigation step.

Andrew750's avatar
Andrew750
Copper Contributor
Sep 01, 2022

So I found a solution, I change the source path to point to the web version rather than the synced pc version. I used this youtube video 4 minutes long, very easy,
https://youtu.be/InnSfyoOt5Y

 

To access for the table for the first time I duplicated another connection which I had changed to web source then changed the web path in the Source step and the table name in the Navigation step.

Resources