I am looking for: Export the Power BI matrix visual data as it is (including layout) to Excel/CSV using Power Automate. Is it possible if so please guide/provide steps or info. Thanks in advance.
Export the Power BI matrix visual data to Excel/CSV
Actually what I am looking for is, in Power BI there will be "Button - Power Automate" which will holds all the steps and on click the data will be exported to csv/excel same as Power BI matrix visual with layout.
ScottShearer25,228Most Valuable Professional
on at
Export the Power BI matrix visual data to Excel/CSV
I can't think of a way to do what you have asked using Power Automate. That said, you can connect directly to the semantic model from Excel and recreate the matrix. You can set the Excel workbook to refresh when it is opened.
Scott
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.