Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
How can we export large amount of tabular format of data in power bi in single page? If I export in excel then I am getting pivot table , but I confused which fields I move to in rows and which fields I move to column ,when I do the update I am getting pop up as “The Pivot Table report will not fit on this sheet”. Please help me.
Hi @Anonymous ,
If the export data from the visual meets the requirements, please try exporting the data from the visual.
Here are some references that may be helpful.
Export data from a Power BI visualization
How can I export the underlying data in Power BI?
Solved: Export underlying data - Microsoft Power BI Community
If this doesn't work for you or I misunderstand your needs, please consider sharing more details about it.
Best Regards,
Community Support Team_Gao
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 feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
I have tried from power bi services but its getting me pivot table. i confused how i work in pivot table.
Hi @Anonymous ,
How are you currently exporting your data?
There are options to export your data as .csv in Power BI Service. May be you can try that
Regards,
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!