Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Large Amount of Data

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.

3 REPLIES 3
Anonymous
Not applicable

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

Anonymous
Not applicable

I have tried from power bi services but its getting me pivot table. i confused how i work in pivot table.

Thejeswar
Super User
Super User

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,

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors