Forum Discussion
Solved
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 Mode...
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.
