Forum Discussion
Display Power BI dataset sa a table in Excel
Hi, I was trying to get data from a published Power BI Dataset into an excel table because I need it to be formatted as a table, not a pivot table. I couldn't find any option to load Power BI da...
Alternatively you may export any visual from the based on dataset visual to Excel. 3-dots menu on top right of the visual -> export data->summarize data.
In Excel
Data-> Queries and connection->Properties of connection. Here in Definition tab in Command text box it'll be some DAX query. You may change it on any suitable for you, e.g. to have entire table just
EVALUATE 'MyTable'
With that you have Excel file with live connection to the table in dataset.
I will try this as well. The export from Power BI Service Dataset page keeps failing.
You have some error (which one?) or that option is not available?
Also please check if export is allowed Export data from a Power BI visualization - Power BI | Microsoft Learn