Forum Discussion
Save to xlsx
I posted this earlier but the post has disappeared. I’ve been a BusinessObjects developer for 20 years, my company are now moving to Power BI. They have built visual reports with conditional formatting in Power BI. Is it correct these can’t be saved as is to xlsx? When I try to do that it comes up as an option for a pivot table. Is is possible to do something with Power Automate? Normally we schedule hundreds of these reports automatically with BO daily. I know you can save to XLS with the paginated reports so they are looking into that but they need xlsx can’t be csv/ppt/pdf etc. Thanks
Hi EllieEv,
The very 1st option you can try if you have table and views in your dashboards.If your Power BI visuals are tables or matrices, users can:
-
Hover over the visual → click More options (…) → Export data
-
Choose
.xlsxformat (if allowed by admin). -
This exports the visual’s data — but without color formatting or icons.
Only plain data appears.
OR
You can use paginated report(Power BI Report Builder)Paginated Reports are your closest equivalent to BusinessObjects.
-
They preserve layout, colors, conditional formatting, and pagination.
-
You can export directly to XLSX.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
-
Hi EllieEv,
I agree with grazitti_sapna, paginated reports is the way to go here.
What are paginated reports in Power BI? - Power BI | Microsoft Learn
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
4 Replies
Hi EllieEv,
The very 1st option you can try if you have table and views in your dashboards.If your Power BI visuals are tables or matrices, users can:
-
Hover over the visual → click More options (…) → Export data
-
Choose
.xlsxformat (if allowed by admin). -
This exports the visual’s data — but without color formatting or icons.
Only plain data appears.
OR
You can use paginated report(Power BI Report Builder)Paginated Reports are your closest equivalent to BusinessObjects.
-
They preserve layout, colors, conditional formatting, and pagination.
-
You can export directly to XLSX.
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
-
Hi EllieEv,
I agree with grazitti_sapna, paginated reports is the way to go here.
What are paginated reports in Power BI? - Power BI | Microsoft Learn
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi EllieEv ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you tayloramy grazitti_sapna for the prompt response.
I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.
Thank you.
