Forum Discussion

Caitlin_Knox's avatar
Caitlin_Knox
Advocate III
10 years ago

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...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Caitlin_Knox,

I test the scenario as yours, and get the same error when connecting to SharePoint document libraries or SharePoint folder using the new SharePoint Folder connector in Power BI Desktop April update.

I have reported this issue internally, I will update this thread when I get response.


Thanks,
Lydia Zhang

DAN's avatar
DAN
Advocate II
10 years ago

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

  • Gabriel's avatar
    Gabriel
    New Member
    9 years ago

    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