Forum Discussion
Need help reading data off a matrix into an Excel table 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.
2 Replies
- freginierSolution Sage
Maybe you can use Excel analysis service from Power BI
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
- AnonymousNot applicable
Hi Anonymous,
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