Forum Discussion

Kratos1112's avatar
Kratos1112
Regular Visitor
3 years ago

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.