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.

     

rohit1991's avatar
rohit1991
Super User
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.