Forum Discussion
Export data more than 150k rows in .xlsx
Hi, I would like to check there is any way to overcome the limitation to export data of more than 150k rows from power BI using underlying data. Also, I would like to check if this could be possible...
Hi,
Thanks for your reply!
I am using a premium capacity workspace, When I export data through "Analyze in Excel", I am getting the below error when I tried to see the data.
Can you please share how we can export full data by using DAX?
When I explored on internet, I came to know that it can be done on DAX studio (https://daxstudio.org/). I am not sure if it is an authorized Microsoft Product or Service. My data has sensitive information, so not sure if it is reliable to use DAX Studio. If yes, can you please share the specific steps to export full data from Power BI or if you have any better alternative?
Thanks,
Eliyaz.
- lbendlin
Super User
DAX Studio is just one of the tools to access XMLA endpoints (albeit a very good one). You can use whatever you feel comfortable with, including SSMS (above18.8), Tabular Editor, ALM toolkit etc.
The most simplistic way to extract a table from a Power BI dataset is run this DAX query: "EVALUATE 'TableNameHere'". Often you don't want the entire table (yours seems to suffer from column bloat) so you can tailor the DAX to group and filter.
If you need to "export full data from Power BI" then you are doing something wrong. That's not what Power BI is for. Export from the Power BI data source instead.
