Forum Discussion

kegoosse's avatar
kegoosse
Helper I
7 years ago
Solved

Change Source from 'Folder' to 'SharePoint Folder'

Hi everyone,   Normally I connect Power BI with a local data folder, but my folder is now stored on SharePoint. The data remains unaltered so what I want to do is simply change the data source from...
Need Help
  • Stachu's avatar
    Stachu
    7 years ago

    You can create a new query connecting to the SharePoint folder and once you have that you can copy that M code using Advanced Editor and paste it in the original query. I'd suggest doing it on a copy of original query first.

    Most likely you will also have to add missing "," in the last SharePoint line, and change the step reference in your local folder query

     

    Just be aware that SharePoint folder extension uses different "/" than local folder "\", so if you have any subfolders etc. it may cause some complications

Stachu's avatar
Stachu
Community Champion
7 years ago

You can create a new query connecting to the SharePoint folder and once you have that you can copy that M code using Advanced Editor and paste it in the original query. I'd suggest doing it on a copy of original query first.

Most likely you will also have to add missing "," in the last SharePoint line, and change the step reference in your local folder query

 

Just be aware that SharePoint folder extension uses different "/" than local folder "\", so if you have any subfolders etc. it may cause some complications