Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Is there a way to export the entire content of a table or Matrix visual from Power BI? In the report I am showing the table with lesser height (only 5 rows displayed at any time) so that a scroll bar is required to see the remaining data. But when i export to PDF I need to get the entire rows in the table to be displayed. In the case of matrix, when i export i need to get the entire columns to be displayed.
Thanks in Advance
Hi @AJose ,
If you export the report to PDF, it will be shown as same as the visual in Power BI.
You may export it as .csv file or take a look at analyze in excel feature if you want to export the underlying data.
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
Best Regards,
Jay
Hi @AJose,
Whenever you will export the data as a PDF or PPT, you will get the visual as shown in Power BI. You will get a scroll if your visual has(as it is a snapshot or image as a PDF/PPT format). If you don't want the scroll and want to see all the columns better you can increase the page size and page width then export.
If you are trying to export from the Power BI service then you can export summarised data and underlying data. CSV file has some row limit as well (see below screenshot)
Hi @AJose ,
There are row limits when exporting and you have to have the tenant settings allowing you to export. Also, when you export you may need to select "underlying data" as well (again, assuming permissions).
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @AJose ,
I do not believe that there is any to keep the exact formatting. I think that the export functionality to the output format has its own set of instructions and is more concerned about data than formatting.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi,
I am looking for an export to PDF/PPT with all the data in a table/matrix visual shown like the one in SSRS 'Export to PDF'.
Thanks
Hi @AJose ,
As you may know, you can export a Report PAGE to PDF. At this time, there is no way to export a specific visual to PDF. That functionality is still in the Report Builder and SSRS only. Perhaps you can search if there is an idea for this already and/or create your own idea.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.