Forum Discussion
Error while creating report (loading data) from Sharepoint Excel file
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/
Hi Hateam
This issue is related to authentication or how the SharePoint file path is being handled in Power BI Service.
You can check some of the things:
-
Authentication Method
-
Make sure that when publishing to the Power BI Service, you’ve set the authentication method to "OAuth2" under Data source credentials.
-
Go to Settings - Datasets -Data source credentials and edit the credentials for the SharePoint data source. Re-authenticate using the correct Microsoft account that has access to the SharePoint site.
-
-
File Path Format
-
Double-check that you're using the SharePoint Folder connector, not just a regular Web URL.
- Once connected through the SharePoint Folder connector, use Power Query to filter down to the exact Excel file from the file list.
-
-
Gateway
-
If this is being refreshed through a gateway, make sure the gateway has access to SharePoint and is configured with the same credentials.
-
-
5 Replies
You are using an inferior connector. Switch over to the SharePoint Folder connector, that will also fix your credentials issue.
Hi Hateam
This issue is related to authentication or how the SharePoint file path is being handled in Power BI Service.
You can check some of the things:
-
Authentication Method
-
Make sure that when publishing to the Power BI Service, you’ve set the authentication method to "OAuth2" under Data source credentials.
-
Go to Settings - Datasets -Data source credentials and edit the credentials for the SharePoint data source. Re-authenticate using the correct Microsoft account that has access to the SharePoint site.
-
-
File Path Format
-
Double-check that you're using the SharePoint Folder connector, not just a regular Web URL.
- Once connected through the SharePoint Folder connector, use Power Query to filter down to the exact Excel file from the file list.
-
-
Gateway
-
If this is being refreshed through a gateway, make sure the gateway has access to SharePoint and is configured with the same credentials.
-
-
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!
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.
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!
