cancel
Showing results for 
Search instead for 
Did you mean: 

Action to Refresh Excel Tables Connections

It would be great if there is a possibility to add the "Refresh Data Table" action for "Excel Online (Business)" component. This should be the same result as clicking on "Data -> Refresh All Connections" in Excel Online.

Status: New
Comments
Level: Powered On

I'm trying to email a small section of content to a vendor each day. I have the dataset residing in Power BI, and I created a filtered table of the vendor's data in Excel (saved to a Sharepoint site, same workspace as the Power BI dataset) to pull from that dataset. My Power BI dataset refreshes a few times around noon, and I'd like to send out an email at 3pm to my vendor with updated data, in an attachment. I've figured out everything except how to update the Excel Online worksheet after the dataset refresh. Having this action is critical, please consider.