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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors