Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I have 1 million rows in PowerBI Matrix , can i exports that much data(rows) to excel file?? ??
And What are the limitation of Data export in Power BI in Both PowerBi desktop ...... and when report is published and we want to export from report ?
Please find the limitations in Power BI here: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/
In Desktop you can bypass the limitation by using an R-script using this function:: https://gist.github.com/ImkeF/ea234e7a77f2ccae9d798f2a9ad76701
Details see here: http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
is it save to Use R scripts in Power BI ?
Not sure how to understand your question: The R-script from PowerBI will be executed on your local R-engine. So you can do via PBID just the same (bad things) than with your local R-machine.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 101 | |
| 76 | |
| 56 | |
| 51 | |
| 46 |