Forum Discussion
Export excel 150000 workarounds
Good day,
Apart from the below are there any other tricks one can use to export > 150'000 rows from a publisished RS report?
Workarounds
- Use Excel Power Query to Connect to the Semantic Model
You can use Excel's Power Query to connect directly to the Power BI semantic model (dataset). This allows you to pull full tables (excluding measures) into Excel without the export limit - Split Data Using Filters or Slicers
Apply filters or slicers to segment your data into smaller chunks. Export each segment separately and then combine them in Excel. - Copy Table from Data View in Power BI Desktop
If you're working in Power BI Desktop, go to the Data view, right-click a table, and select Copy Table. Paste it into Excel—this bypasses the visual export limit - Use Paginated Reports
Paginated Reports in Power BI Report Server are designed for large-scale exports. You can create a paginated report using Report Builder and export to Excel without the row limitations.Thanks
Dylan
Hi Dylan24 ,
Nice summary — you’ve already covered most of the solid workarounds out there. Just adding a couple more ideas that might help depending on your setup:
5. Use DAX Studio to Export
If you're working with a local model or have access to the dataset:
- Connect to your model using DAX Studio
- Run a DAX query (like EVALUATE TableName)
- Export the full result to CSV — no row limit here
It’s super handy for large exports and gives you full control over the query.
6. Use Power BI REST API (for advanced users)
If you're comfortable with scripting:
- You can use the ExportToFile API to export paginated reports programmatically
- Or use the XMLA endpoint to query the dataset and extract data in chunks
Not as user-friendly, but useful for automation or scheduled exports.
Let me know if you want help setting up DAX Studio or scripting something — happy to help.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was supported by AI for translation and text editing.
5 Replies
- burakkaragoz
Super User
Hi Dylan24 ,
Nice summary — you’ve already covered most of the solid workarounds out there. Just adding a couple more ideas that might help depending on your setup:
5. Use DAX Studio to Export
If you're working with a local model or have access to the dataset:
- Connect to your model using DAX Studio
- Run a DAX query (like EVALUATE TableName)
- Export the full result to CSV — no row limit here
It’s super handy for large exports and gives you full control over the query.
6. Use Power BI REST API (for advanced users)
If you're comfortable with scripting:
- You can use the ExportToFile API to export paginated reports programmatically
- Or use the XMLA endpoint to query the dataset and extract data in chunks
Not as user-friendly, but useful for automation or scheduled exports.
Let me know if you want help setting up DAX Studio or scripting something — happy to help.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was supported by AI for translation and text editing.
Why are using ChatGPT in all threads. Why are you spamming this forum?
v-sdhruvCommunity Support
Hi Dylan24 ,
Thank you for reaching out on Microsoft Community Forum.
While the approach mentioned by you is widely used and is quite popular among the users to export large datasets. Additionally, you can even use DAX studio for large datasets.
You might want to check out this link which explains step by step how to export using DAX.
https://stackoverflow.com/questions/51375021/export-million-rows-table-from-power-bi-overcome-the-limit-of-150k-rows
Hope this helps!
If any of the response/s has resolved your query, kindly mark it as Accept as solution so that other members can benefit from it.
