Forum Discussion
Helper IIIConvert multiple page Power BI report into an excel
I have a Power BI report where a Person ID can be chosen from the slicer.
For that Person ID chosen, all the pages of the report needs to show specific information about this person as a matrix.
And the report needs to be exported to excel where each page in Power BI is a sheet on the excel (including the formating)
It needs to be excel and not CSV. Can this be achieved ?
Hi , Hoping
According to your description, you want to create a slicer and export all the pages to excel not csv.
Depending on your needs, currently Power BI Service export only supports single visuals to Excel.
For this , you can refer to this document:
Export data from a Power BI visualization - Power BI | Microsoft LearnBut you want to achieve the export of all pages, and only the shreet in Excel.
You can try to use the paginated report feature if it can meet your need. For more information, you can refer to :
Export Power BI paginated report to Microsoft Excel (Power BI Report Builder) - Power BI | Microsoft LearnWhat are paginated reports in Power BI? - Power BI | Microsoft Learn
Bu another , you can also create the report in Excel using the "Analyze in Excel" feature.
For more information, you can refer to :
Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
- v-yueyunzh-msft
Community Support
Hi , Hoping
According to your description, you want to create a slicer and export all the pages to excel not csv.
Depending on your needs, currently Power BI Service export only supports single visuals to Excel.
For this , you can refer to this document:
Export data from a Power BI visualization - Power BI | Microsoft LearnBut you want to achieve the export of all pages, and only the shreet in Excel.
You can try to use the paginated report feature if it can meet your need. For more information, you can refer to :
Export Power BI paginated report to Microsoft Excel (Power BI Report Builder) - Power BI | Microsoft LearnWhat are paginated reports in Power BI? - Power BI | Microsoft Learn
Bu another , you can also create the report in Excel using the "Analyze in Excel" feature.
For more information, you can refer to :
Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly