Forum Discussion
Changing Pivot Table Fields on Dataset Fails with Excel Workbook in Workspace
Hi Martin_D ,
Sorry to know it didn’t help. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thanks and Regards
This behavior is by design. In Power BI, Excel relies on centralized data connections and refresh policies. The "Data Refresh Failed" error indicates issues with the "PracticeDatasetSharePoint" connection or gateway configuration.
Solution:
- Verify the "PracticeDatasetSharePoint" connection in Power BI.
- Ensure the required gateway is configured and running.
- Test and resolve dataset refresh issues directly in Power BI.
If the file works in Excel web app, the issue is specific to Power BI's stricter refresh framework.
Hi rohit1991 ,
thank you for analyzing the issue. What would be a correct summary of your comment: There is a way to fix this issue, or there is no way to fix this issue?Actually, there is no gateway involved, so I can exclude this as the cause. Between the Excel file and the Power BI semantic model there is for sure no gateway and between SharePoint Online as the data source of the semantic model and the semantic model there is also no gateway. I'd be surprised anyway how this would affect the scenario.
Kind regards,Martin
