Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
niyati_61
Helper III
Helper III

Power BI Report Server - Connecting to a Sharepoint Folder

Hello @d_gosbell ,

 

Currently trying to connect a data source (Shared Excel File) which is saved on a Sharepoint folder. However, when I do get data, and connect to Sharepoint Folder, where I input the root URL (https://companyname.sharepoint.com/site), this error keeps coming up,

 

niyati_61_0-1646224873038.png

 

How do I connect a data source in Sharepoint to my Report in Power BI Desktop for Report Server?

 

P.S: Currently working on Power BI Desktop for Report Server (Jan 2022) Version. 

It was installed via SQL Server Enterprise with active Software Assurance.

 

Kindly request your support. Thank you!

1 ACCEPTED SOLUTION
v-luwang-msft
Community Support
Community Support

Hi @niyati_61 ,

When trying to connect to the list you  need use the full URL of the list.Otherwise, this error will occur.

 

The problem was caused by trying to link to the full list address.

 

See thread:

http://community.powerbi.com/t5/Service/PowerBI-linked-to-SharePoint-Lists-require-a-Personal-Gatewa...

 

Solution: Change the connector to the primary URL path for the Teams Site. For example (https://xxx.sharepoint.com/sites/xxx/xxxTeamWorkspac) is what I used and I removed the remaining extension. Once I executed the connector, I was able to gain connectivity.

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

View solution in original post

2 REPLIES 2
v-luwang-msft
Community Support
Community Support

Hi @niyati_61 ,

When trying to connect to the list you  need use the full URL of the list.Otherwise, this error will occur.

 

The problem was caused by trying to link to the full list address.

 

See thread:

http://community.powerbi.com/t5/Service/PowerBI-linked-to-SharePoint-Lists-require-a-Personal-Gatewa...

 

Solution: Change the connector to the primary URL path for the Teams Site. For example (https://xxx.sharepoint.com/sites/xxx/xxxTeamWorkspac) is what I used and I removed the remaining extension. Once I executed the connector, I was able to gain connectivity.

 

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

d_gosbell
Super User
Super User

So the 404 error probably means that your site url is incorrect. It should be something like https://companyname.sharepoint.com/sites/yoursite. If you navigate to the home page of your site in your browser and then copy/paste that into Power BI Desktop it should work. 

 

Note that Sharepoint Online data sources do not work with Report Server scheduled refreshes - you can only refresh these data sources in Power BI Desktop.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors