Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Babycakes_00
Helper I
Helper 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 Script to refresh all and link it to a power automate. 

Babycakes_00_1-1736910191769.png

 That too is saying successful but not refreshing file.

 

Babycakes_00_0-1736909751611.png

 

 

My Ultimate goal is to refresh this automatically overnight without human intervention

 

Any ideas please?

1 ACCEPTED SOLUTION
christinepayton
Super User
Super User

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. 

View solution in original post

8 REPLIES 8
v-menakakota
Community Support
Community Support

Hi @Babycakes_00 ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

I just wanted to kindly follow up to see if you had a chance to review the previous response provided by @christinepayton . Please let me know if it was helpful. If yes, please Accept the answer so that it will be helpful to others to find it quickly.

Regards,
Menaka

Hi @Babycakes_00 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

Hi @Babycakes_00 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Regards,
Menaka.

christinepayton
Super User
Super User

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
Super User
Super User

Can you open the file manually and refresh the Power Query queries? If so, then the issue is not with Power Query.

Is it possibly a credentials issue? What account is your Power Automate running under? Is it you?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





ToddChitt
Super User
Super 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?




Did I answer your question? If so, mark my post as a solution. Also consider helping someone else in the forums!

Proud to be a Super User!





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.

Thank you for you assistance! This relates to a power query not refreshing - it is a power query forum.

 

Apologies I impacted your day!

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors