Power BI Embedded and Export Current Layout to Excel

Hi,Yggdrasill 

Your idea is excellent! Power BI now supports your requirement; you simply need to click on the three dots in the top right corner of the matrix visual to access this functionality.

Once there, select the option to maintain the current page layout:

My sample data is as follows:

Here are the final results after opening Excel:

For further details, please refer to:

Export data from a Power BI visualization - Power BI | Microsoft Learn

Of course, you can also consider using the API to achieve this requirement:

For more information, please refer to:

 How to use Power BI Rest API to export the Power B... - Microsoft Fabric Community

Of course, if you have any new discoveries or questions, please feel free to get in touch with us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.