cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Refresh data on an excel sheet fetching data from an external data source

Hello,

 

How can we refresh data on an excel sheet (residing on OneDrive), without opening the sheet?

The data on the excel sheet is coming from a  query against an ODBC source (Snowflake connector).

 

 

 

4 REPLIES 4
Highlighted
Dual Super User III
Dual Super User III

Re: Refresh data on an excel sheet fetching data from an external data source

Hi @robin_gupta 

 

The current excel connector in Power Automate does not support refreshing a worksheet/workbook as a direct action. However, you can check out the graph API (https://docs.microsoft.com/en-us/graph/api/workbook-refreshsession?view=graph-rest-1.0&tabs=http ) and use the HTTP action or build a custom connector for this one. 

 

If you think this should be added to the existing connector as a feature, you can raise an idea request or upvote similar ones here: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Regular Visitor

Re: Refresh data on an excel sheet fetching data from an external data source

So basically there is no low-code solution to updating an excel file in a onedrive location  as of now?

I had read somewhere on the community that one of the two ways below, could help:

  1. Setting up "Refresh a Dataset" from POWERBI as a a Step
  2. " Update a file" step from Sharepoint
  3. Or adding/deleting a row as here on your reply 

 

@yashag2255  Can you please let me know if the above could help in solving the case?

Highlighted
Dual Super User III
Dual Super User III

Re: Refresh data on an excel sheet fetching data from an external data source

Hi @robin_gupta 

 

Adding or deleting a row definitely helps but then it interacts with the data. I was under an assumption that you did not want to do that and externally refresh the worksheet. 

 

Refresh Dataset in Power BI is for the powerbi datasets so if your data from excel is ultimately going there, you can definitely check that out. 

 

You can try getting the file content first and then try the update file action and replace content so it might refresh it that way. But I believe there will be certain limitations to that as well.

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Highlighted
Regular Visitor

Re: Refresh data on an excel sheet fetching data from an external data source

Tried all methods and gave up. There is no way , Power Automate or any of the Sharepoint/PowerBI/OneDrive tools can refresh data from an external source (ODBC) on an excel sheet (without opening it explicitly)

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,464)