Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 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.

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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.