Need to export Power BI matrix visual data into excel format on daily basis using Power Automate

[ribisht17]

Hello Community,

Need to export Power BI matrix visual data into excel format on daily basis (Exported excel report data should be based on today date - 1).eg:- In Power BI file, each Power BI page have 3 matrix visuals and total we have 5 Pages, so exported excel should contains the 5 sheets and each sheet contains 3 exported tables. Also hierarchy should be maintain as per matrix visual in Power BI.

Ritesh

[v-zhouwen-msft]

Hi @ribisht17 ,

Regarding your question, you may be able to use the Power automate visual object built into Power BI Desktop. 

Power BI export to excel and csv with Power Automate (youtube.com)

Or you can perform a DAX query on the dataset based on the filtering criteria of the matrix.

www.datalineo.com