Forum Discussion

Hateam's avatar
Hateam
New Member
1 year ago
Solved

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 uploade...
Need Help
  • rohit1991's avatar
    rohit1991
    1 year ago

    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.

     

v-sgandrathi's avatar
v-sgandrathi
Community Support
1 year ago

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's avatar
v-sgandrathi
Community Support
1 year ago

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!