Power Bi Report unable to refresh linked to Sharepoint Excel

[Manash27]

Hello everyone,

I'm encountering a peculiar issue with my published Power BI report. I have a pbix file connected to an Excel file on SharePoint. The report functions flawlessly in Power BI Desktop and refreshes without any problems. However, when I publish it to a workspace, the scheduled refresh fails.

I have other Power BI reports linked to SharePoint that can be refreshed without any issues. There is no issue in datasource credentials and gateway settings.

Error message

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Web: Request failed: https://xxxx.sharepoint.com/sites/xxxxxx/Shared Documents/General/RP Forms/Appointments of Safety and BBS-FOD_Champions_xlsx/_api/contextinfo"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"https://xxxxx.sharepoint.com/sites/xxxxxx/Shared%20Documents/General/RP%20Forms/Appointments%20of%20..."}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Cost center Mapping.

[v-jialongy-msft]

Hi @Manash27 

Please check the method in the following post:

File Configuration

• Created an Excel spreadsheet in Excel Online. Saved to a Sharepoint document library. *NOTE* This spreadsheet MUST be formatted as a table to work.
• Created a PowerBI Report directly in the PowerBI Service website
  • Clicking My Workspace > +Create in the top right corner > Report > Import New Data > Files > Get > Sharepoint - Team Sites > Paste in Sharepoint URL > Connect  > Load the newly created spreadsheet that's saved in the Sharepoint document library

PowerBI Setup

• After loading in the above, I created a handful of visualizations in the Dataset and the saved as a new report
• Checking the Schedule Refresh option of the Dataset shows that OneDrive refresh is enabled. Note that Scheduled Refresh was not an option

Testing

• Went back to the Excel spreadsheet that is saved on Sharepoint Online and added some random data using Excel Online
• Checked the report about an hour later on the PowerBI Service website and saw that it accurately reflected the changes that were made to the spreadsheet on Sharepoint Online 

Solved: Automatic Refresh not working when connecting to S... - Microsoft Fabric Community

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.