Connect Power BI to SharePoint folder

[cham]

Hi,

I tried to connect power bi to sharepoint through "SharePoint Folder" as follow, but i ma getting following error message.

Can someone help for this.

Thanks

[mahoneypat]

You need to provide just the site url.  Delete the end up through Shared Documents and try again.  You will then see all the files and be able to filter by folderpath if needed.

Pat

[cham]

Hi,

Its not allowing me to go to folders,

Its giving below table,

Thanks

[mahoneypat]

Looking again at your initial pic, it doesn't look like a full url for a SharePoint site.  Those usually have

.../sites/SiteName  at the end.  It look like you are connecting to the root SharePoint for your tenant.  Did you copy your url from your SharePoint site where you see your desired documents?  

Also, usually there is a scroll bar at the bottom you can use to scroll right and see the FolderPath column.

Pat

[cham]

Hi,

I select "Web" get data in Power BI desktop and it worked with the folder URL.

Thanks.

[v-xulin-mstf · Accepted solution]

Hi @cham,

If you want to connect power bi to sharepoint through "SharePoint Folder", you need click here.

Best Regards,

Link