Forum Discussion
Solved
Sharepoint source Datasource error
Hello, We are trying to change our folders from local folders to a sharepoint folder. When I change the source of the files in Power Query, I get the following error. DataSource.Error: Mic...
Hi Kareem_Amr_IT ,
It should be an authetication error,I tested here,and no errors:
Go to data source settings and edit the credentials:
Best Regards,
KellyDid I answer your question? Mark my reply as a solution!
With the SharePoint connector, you need to use the site url, not the full url to the folder.
= SharePoint.Files("https://example.sharepoint.com/sites/Folder", [ApiVersion = 15])
From there, you can filter on the FolderPath column to get to your desired folder.
Pat