Forum Discussion
Excel live connection doubt (summarized data export)
Hello everyone, I'm new in PowerBI and I have an issue that it seems I already discovered the cause, however I would like to confirm my theory, could you help me to verify if it is correct? I ap...
However the option with Live Connection to export data to an Excel file from PowerBI for a visual, allows to the users connect directly to the source None of that is true. The "Live" connection is not live, it is a Direct Query connection. Data is not exported to Excel, it is linked via a DAX query and cached in Excel. Excel is not connecting directly to the source, it is connecting to the Power BI dataset via the DAX query.