Forum Discussion
Refreshable Connections via Sharepoint
Topher11 -
Is your question asking if you have your 'Get Data' file in Sharepoint better than in your OneDrive?
Depends who has permissions to your Sharepoint; the same could be said about your OneDrive though. If you want other people to be able to Open and Refresh the data you'll have to give them permissions to the folder/file.
Hey ChrisMendoza ,
My issue is that when I choose Get Data and then try to find the file, I'm unable to locate it because the only options I have are either to find it in OneDrive or import a list from Sharepoint. I'm trying to import the file from Sharepoint.
Does that make sense?
Topher11 -
Similar to what SergeiBaklan is saying, except that navigation within the ribbon is not working like that.
I ended up using New Query > From Other Sources > From Sharepoint List.
In the 'Navigator' window, select an existing list then EDIT.
Remove any steps, leaving only Source.
It should be showing:
'=SharePoint.Tables("...")'
Change to:'=SharePoint.Files("...")'
You should be able to see your Excel, CSV, etc. files.
You may use From File->From Sharepoint Folder connector https://docs.microsoft.com/en-us/powerquery-m/sharepoint-files. Here filter your file, click on Binary and extract the table.
