Export Power BI Matrix visual data into excel

Like (0) Share

Report

Posted on 7 May 2024 18:01:47 by A12TCB

Hi,

Need to perform the below tasks by using Power Automate: -

1) Need to export Power BI Matrix visual data into excel format on daily basis.
for example: - In Power BI file, each Power BI page contains 3 matrix visuals and total we have 5 pages,
so exported excel should contains the 5 sheets and each sheet contains 3 exported tables.

2) Exported excel should maintain the column hierarchy same as Power BI matrix visual

3) Exported excel should maintain the $ and % format

4) Scheduled delivery of excel format report to multiple users on daily basis.

If anybody has worked on that kind of scenario, please help me on this.

All responses (2)

Answers (0)

gujralh 29 on 10 Jun 2024 at 02:59:36

Like (0)

Report

Re: Export Power BI Matrix visual data into excel

Currently this is not possible directly, you can vote for this idea as I already posted this for idea submission.

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=6c2b7ce9-d426-ef11-8ee8-000d3a0f9a18
ScottShearer 25,236 Most Valuable Professional on 07 May 2024 at 18:11:14

Like (1)

Report

Re: Export Power BI Matrix visual data into excel

@A12TCB

I suggest an alternate method that does not use a Flow.

Open Excel and connect the Power BI Semantic Model (dataset).

Pull the data that you want into pivot tables in Excel.

Set the Excel file to refresh the data on open.

You might use a Flow to send the Excel file each week but it will be the same file each week - no need to email.

Note that this solution assumes that those who receive the Excel file have access to the semantic model.