Error while creating report (loading data) from Sharepoint Excel file

[Hateam]

Hi,

we have a problem while loading data to the simple report in PowerBI web app.

The Excel file is stored on Sharepoint, all permissions are granted and checked. The same file can be uploaded to the workspace, however there is a credential error while creating report.

Underlying Error: {"code":"ExternalServiceUserFailed","pbi.error":{"code":"ExternalServiceUserFailed","parameters":{},"details":[{"code":"ModelingServiceError_Reason","detail":{"type":1,"value":"Streaming Pqo evaluation failed"}},{"code":"ModelingServiceError_Location","detail":{"type":1,"value":"Streaming Pqo Evaluation"}},{"code":"ModelingServiceError_ExceptionType","detail":{"type":1,"value":"GatewayPipelineWrapperException"}},{"code":"ModelingServiceError_Message","detail":{"type":1,"value":"Credentials are required to connect to the Web source. (Source at https://***.sharepoint.com/sites/***/***.xlsx.)"}}],"exceptionCulprit":1}}
Status code: 400
Service version: 13.0.25588.51
Client version: 2503.4.23583-train
Cluster URI: https://wabi-poland-central-a-primary-redirect.analysis.windows.net/

[v-sgandrathi]

Hi @Hateam,

Thank you @rohit1991 and @lbendlin for your points regarding the query.
Has your issue been resolved?If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you for your understanding!

[v-sgandrathi]

Hi @Hateam,

I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-sgandrathi]

Hi @Hateam,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[rohit1991 · Accepted solution]

Hi @Hateam ,

The error you're seeing indicates that while Power BI recognizes the Excel file on SharePoint, it cannot authenticate to access it when trying to load or refresh the data in the Power BI web app.

Even if permissions are set correctly on SharePoint, the Power BI Service needs its own credentials configured to connect to the SharePoint data source.

To fix this, go to your Power BI workspace, find the related dataset, click on the "Settings" (gear icon), and then go to "Data source credentials". There, you'll likely see a prompt saying credentials are missing or invalid. Click Edit Credentials, choose OAuth2 as the authentication method, and sign in using the same Microsoft account that has access to the SharePoint file.

Additionally, ensure that your SharePoint link follows the proper format—ideally, using the SharePoint folder connector or a clean web URL ending in .xlsx without unnecessary query strings. Once the credentials are set correctly, the connection should authenticate properly and allow the data to load into the report without further errors.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth.

Connect with me on LinkedIn: Rohit Kumar.

[lbendlin]

You are using an inferior connector.  Switch over to the SharePoint Folder connector, that will also fix your credentials issue.