The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,