Forum Discussion

cham's avatar
cham
Post Patron
5 years ago
Solved

Connect Power BI to SharePoint folder

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
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi cham,

     

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

     

    Best Regards,

    Link

     

     

cham's avatar
cham
Post Patron
5 years ago

Hi,

 

Its not allowing me to go to folders,

 

Its giving below table,

 

 

Thanks

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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's avatar
    cham
    Post Patron
    5 years ago

    Hi,

     

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

     

    Thanks.

    • v-xulin-mstf's avatar
      v-xulin-mstf
      Community Support
      5 years ago

      Hi cham,

       

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

       

      Best Regards,

      Link