Unanswered

Export Power BI Matrix visual data into excel

(0) Share

Report

Posted on 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.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
gujralh 29 on at

Like (0)

Report

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

Was this reply helpful? Yes No