Forum Discussion
Using the SharePoint Folder connector
Trying to use this new connector that became available in the April update, but it doesn't seem to be working as expected. I have a site created, with 3 separate document libraries. I'm trying to con...
Hi,
I have information maybe useful with you:
When i try to connect to a sharepoint FOLDER (belong to a subsite), Power BI Desktop returns the error like yours.
But when i try to connect to the parent site "https://onexakis-my.sharepoint.com/", PBD catchs the link.
And the problem, i think, is that in Power Query, they recognize the link as a SharePoint FILES, not a FOLDER.
Power query:
= SharePoint.Files("https://onexakis-my.sharepoint.com/", [ApiVersion = 15])
Regards,
DAN
This did it for me.
I use only the path to my site in the first dialog and I get a table with all the files in all the subfolders.
Then, with a simple filter on the Folder Path column, I remove all the unwanted files.
Thank you!
Gabriel