Forum Discussion
How to Automatically Update Excel from a Power BI (Fabric) Model with New Data and Workspaces
Hi kur83 ,
Here are resources:
Microsoft Documentation:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive
Video Tutorial: https://www.youtube.com/watch?v=46Ek6XFVAuI
If you need to work with multiple datasets at the same time, the Hub model is still effective. You can connect each workspace dataset to the Hub using Linked Dataset or Promote to Certified, so Excel remains connected only to the Hub. This setup allows Excel to access a unified and consistent model, even though several datasets are connected in the background. When you add or update a dataset, just update the Hub links - Excel refreshes will keep working since the Hub’s GUID stays the same.
Hi kur83 ,
Thanks for reaching out to Microsoft Fabric Community Forum.
If you want Excel workbooks to refresh automatically from Power BI Fabric without breaking connections, the Hub model approach works really well. The idea is to create a stable dataset (Hub model) that acts as a single source for all your Excel files. Instead of pointing Excel directly to workspace models, connect it to the Hub. Then, when a workspace dataset changes, just link the new version to the Hub using Linked Dataset or Promote to Certified - Excel keeps refreshing because the Hub’s GUID doesn’t change.
Store the workbook in SharePoint or OneDrive, which makes it easy for Office Scripts and Power Automate to refresh the data even if your PC is offline. With Office Scripts, you can refresh the dataset inside Excel, and Power Automate lets you schedule it daily or hourly. Make sure to use a service account with read access to the Fabric datasets and your cloud storage so everything runs smoothly. For large setups, you can also track refreshes in a SharePoint list or Fabric table, send email alerts for failures, and automatically retry any failed refreshes. This approach keeps everything automated, secure, and resilient to model updates.
Can you please provide more details on this on how to do this (any article or tutorial on this)? If I want to have multiple dataset active at once, will it work?
Hi kur83 ,
Here are resources:
Microsoft Documentation:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-excel-file-onedrive
Video Tutorial: https://www.youtube.com/watch?v=46Ek6XFVAuI
If you need to work with multiple datasets at the same time, the Hub model is still effective. You can connect each workspace dataset to the Hub using Linked Dataset or Promote to Certified, so Excel remains connected only to the Hub. This setup allows Excel to access a unified and consistent model, even though several datasets are connected in the background. When you add or update a dataset, just update the Hub links - Excel refreshes will keep working since the Hub’s GUID stays the same.Hi kur83 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you