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...
If in Power BI Services you click on dataset on the right pane it will list of all tables within this dataset. Select one of them, Table Preview appears, and from it you may export the table in few formats, includes Excel. In Excel it will be as a range, Ctrl+L to transform to the table.
Or you mean not export but import one of the tables into existing Excel from the table in Power BI dataset published on services?
- I didn't know we could do that!!
I will try it right waway!
