Forum Discussion
How to export Power BI data to Excel while maintaining a Live Connection for updates?
You should use Analyze in Excel:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
"Hi everyone, thanks for the suggestions!
Just to update you, I’ve decided to go with 'Analyze in Excel'. It works perfectly for my needs because it maintains the hierarchy of my Power BI Matrix and, as I hoped, the 'Refresh All' button in Excel successfully pulls the latest data from the cloud model without any manual exporting.
For anyone else looking for this: The key was ensuring my Power BI Gateway was properly configured first, so the cloud model stays up-to-date. Once that's live, the Excel connection is seamless.
Thanks again for the support!"
Hi Amirolia
Thanks for the updates!
Please accept helpful reply from users as solution, so it will be helpful for others who are experiencing similar issues.