Power Query & SharePoint

[mikeymay]

I have a file that uses Power Query to pull data into a model from a .xlsx file.

This process was C drive based but has now moved to a SharePoint platform.

After a look at the web, there doesn't seem to be a solution that works - A lot of suggested solutions state that I need to select From Other Sources and the SharePoint but these options don't exist in my (o365) version of Excel.

Any help would be useful as I am really struggling with this one!


TIA

 

[JEC]

You need a higher subscription to pull from a sharepointfolder. Instead, you could use get data—> from web

You only need a correct file path which you can find in yiur excel file(desktop).

File—>info—> copy path

 

[mikeymay]

You need a higher subscription to pull from a sharepointfolder. Instead, you could use get data—> from web

You only need a correct file path which you can find in yiur excel file(desktop).

File—>info—> copy path

I didn't realise there was a higher O365 subscription.....Can you provide details of what I need?

I have tried to get the URL from the file properties when viewing via the SP website but this doesn't work either.

I you could walk me through the process to do this as when trying before posting, there are a few steps to get the SP folder location, etc.

Thanks

 

[JEC]

See this link. Open first tab
To get correct path you should open the excel file in desktop as I described. Let me know

Power Query data sources in Excel versions - Microsoft Support

Learn more about which Get & Transform (Power Query) features are included in which Microsoft Office SKUs.

support.microsoft.com