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
Community SupportHi Amirolia
Thank you for reaching out to the Microsoft Fabric Forum Community.
djurecic Kagiyama_yutaka krishnakanth240 Thanks for the inputs
I hope the information provided by users was helpful. If you still have questions, please don't hesitate to reach out to the community.
- v-priyankata
Hi Amirolia
Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.
"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!"
- v-priyankata
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.
