Forum Discussion
Babycakes_00
1 year agoHelper I
Support Needed - Cannot get query to refresh!
Hi All I have tried so many scenarios - I have a query in excel that I have set up to refresh automatically. However it will not update. The file is in sharepoint, Then I have tried a Scrip...
- 1 year ago
If you want to auto-refresh a Power Query, your best bet is to use Power BI instead. You can schedule the refresh in the cloud, people can still use Excel with it with the "Analyze in Excel" feature or just via tables in the report.
ToddChitt
1 year agoSuper User
You are in the wrong forum. This is for Power BI and Power Query.
And seriously, a title of "STUCK!!" ? Like that really describes the issue succinctly?
- Babycakes_001 year agoHelper I
Thank you for you assistance! This relates to a power query not refreshing - it is a power query forum.
Apologies I impacted your day!
- Babycakes_001 year agoHelper I
I Have the excel doc on sharepoint - after researching its not possible to automate a refresh in excel.
Ill have to work out an another way.