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.
