Forum Discussion
Need help reading data off a matrix into an Excel table using the Power Automate Visual.
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 wit...
freginier
Solution Sage
Solution SageMaybe can you use Excel option in Power BI Service ?
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel
Thanks for the idea. However, the 'refresh data' aspect of it seems to work only on Excel desktop and not online.
I was looking into using Power Automate to be able to directly export it onto an Excel stored on sharepoint, and have it automatically be refreshed. End goal is to share the excel link with others and be able to view and edit the data online.