How to export more than 150000 rows from Power BI Dataset/Dataflow in Power BI Service

Hi darshaningale,

If you would like your end users to export data more than 150,000 rows from Power BI service visuals, sadly,  which is not supported by Power BI for now. And it has been listed as an limitation in official document. Considerations and limitaions for export data from a Power BI visualization - Power BI | Microsoft Docs. Here is a workaround you may take. You could export your data with the help of filters such as Slicers, which means you could export parts of the data in each export.

In addition, you could consider voting for the following ideas in Power BI Ideas as well. It’s a place where the product group collects suggestions from the users to improve this product.

https://ideas.powerbi.com/ideas/search-ideas/?q=export%20more%20than%20150000%20rows

https://ideas.powerbi.com/ideas/idea/?ideaid=47820719-f315-48b1-b708-146c2d0e4db8&page=1

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

I realize this is an old post but maybe you are still looking for the solution.  It sounds like you are trying to get a full export of data from a PBI semantic model for use in Excel.  There  is a connector in Excel Power Query that allows using a PBI semantic model as a datasource.  This would give you access to the tables (but not the measures) in your source PowerBI report.

Hope this is helpful.