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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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

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