Forum Discussion
Solved
How to export Power BI data to Excel while maintaining a Live Connection for updates?
Hi everyone, I need to export my Power BI Matrix data into Excel, but I don't want a static .csv or .xlsx file. My goal is to have an Excel file that is linked to the Power BI semantic model, s...
You should use Analyze in Excel:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
krishnakanth240
Super User
Super UserHi Amirolia
Use Analyze in Excel for a live, refreshable connection to the Power BI semantic model where it creates a live connection (PivotTable) to the dataset and supports slicers, measures.