Forum Discussion

Yggdrasill's avatar
Yggdrasill
Responsive Resident
1 year ago

Power BI Embedded and Export Current Layout to Excel

We're using Matrix visuals to represent numbers over time with dimensions on Rows and Year-Month on Columns. The request from our client is to have a "Excel" button where the users can download th...
General Comment
Need Help
Tips and Tricks
Yggdrasill's avatar
Yggdrasill
Responsive Resident
1 year ago

Thanks for the reply but I knew about the 3-dots and export option but I do not want that. 

 

I need to be able to do the exact same thing but via API request so I can create a button that does what you described. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, Yggdrasill 

    Your idea is excellent; however, at present, the export API does not support exporting standard reports directly to CSV, and your requirements also include preserving the current layout.

    Below is a screenshot of the relevant documentation:

    For further details, please refer to:

    Reports - Export Report In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

     

    The current alternative is to use the export solution I mentioned previously:

     

    If you feel that performance needs to be improved, you can also submit an idea on

    https://ideas.fabric.microsoft.com/ and wait for users with the same needs as you to vote for you and help you realize the idea as soon as possible. Many features of our current products are designed and upgraded bed on customers’ feedback.  With requirements like this increase, the problem may well be released in the future.

     

    Thanks for your understanding.

     

    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.