Forum Discussion
Export to Excel with Live Connection Header Sequence
Hi
I am just discovering the option to export to excel with live connection. I was wondering if I change the sequence of column headers in a flat table on the powerbi service, it does not reflect on the excel side. Is it a glitch?
No, that is working as designed.
"Export to Excel with Live connection" is two lies for the price of one. It is neither an export, nor is it a live connection. Instead what you get is a Direct Query connection with a DAX query that was taken at the point in time when you ran your "export". That means any subsequent meta data changes on the Power BI visual will be ignored. (But you can recreate/match them by modifying the DAX query in Excel).
1 Reply
No, that is working as designed.
"Export to Excel with Live connection" is two lies for the price of one. It is neither an export, nor is it a live connection. Instead what you get is a Direct Query connection with a DAX query that was taken at the point in time when you ran your "export". That means any subsequent meta data changes on the Power BI visual will be ignored. (But you can recreate/match them by modifying the DAX query in Excel).