Reply
Kratos1112
Regular Visitor

Cannot connect to the datasource

Hi everyone.

I creat a PBI report with the datasource of several Excels in Teams(sharepoint), but the data type I chosed as WEB, not sharepoint list or folder.

When I upload this report to the report server and to scheldue the refresh plan, I couldn't connet to the datasource by using my credential.  The connection test failed and showed the message about "The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly."

How to solve this problem? Thanks.

1 REPLY 1
Kratos1112
Regular Visitor

If I scheldue refresh plan and start refresh immediately, it showed error message:"DataSource.Error: Unable to connect to the remote server. https://XXXXXX.sharepoint.com/XXXXXXX"

avatar user

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)