Need help reading data off a matrix into an Excel table using the Power Automate Visual.

[SamyHakim]

Hi, I'm trying to get some data to be read off a matrix and directly exported to a an Excel table, preferably on sharepoint using the Power Automate visual.

I have a matrix on Power BI filled with multiple rows and columns and a lot of data, however I only need to export to an online excel two of those columns and have it automatically refresh on excel everytime the data in the Power BI columns changes.

If someone can please provide the detailed steps of what should be done, that will be really appreciated.

Thanks.

[SamyHakim]

I have a matrix on Power BI filled with multiple rows and columns and a lot of data, however I only need to export to an online excel two of those columns and have it automatically refresh on excel everytime the data in the Power BI columns changes.

If someone can please provide the detailed steps of what should be done, that will be really appreciated.

Thanks.

[Anonymous]

Hi @SamyHakim,

According to your description, I think this requirement is more suitable to directly use excel with a data connector to connect your data source and create a pivot table.

Get data from Excel workbook files - Power BI | Microsoft Docs

Regards,

Xiaoxin Sheng

[freginier]

Maybe you can use Excel analysis service from Power BI 

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel