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.
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