Power Query Excel Online

[sureshrawat048]

Need to know if we have option to autorefresh powerquery in online excel/web withoutout opening in excel in desktop. Please help me with the step by step tutorial if any has it.

[v-tsaipranay]

Hello @sureshrawat048 ,

Thanks for reaching out to the Microsoft fabric community forum.

Yes, you can set up auto-refresh for Power Query in Excel Online within Fabric without opening it in Excel Desktop. Here is a step-by-step guide to help you achieve this:

• Start by opening your Excel file in Excel Online and go to the "Data" tab in the ribbon.
• Click on "Queries & Connections" to open the pane that shows all your queries and right-click on the query you want to auto-refresh and select "Properties."
• In the Query Properties window, you will see options to set the refresh interval. Check the box that says "Refresh every n minutes" and specify the interval (e.g., every 30 minutes). Also, check the box that says "Refresh data when opening the file" if you want the data to refresh every time the file is opened.
• Ensure that the "Enable background refresh" option is checked. This allows Excel to refresh the data in the background without interrupting your work. Click "OK" to save the settings and close the Query Properties window.

For more detailed information, you can refer to the following Microsoft documentation:

Use Power Query in Excel for the Web - Microsoft Support

Add data and then refresh your query - Microsoft Support

I am also providing a similar thread that has already been accepted. Please review it for a better understanding.

Link: here.

I hope my suggestions give you good idea, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

[v-tsaipranay]

Hi @sureshrawat048 ,

I wanted to follow up on our previous suggestions regarding autorefresh powerquery in online excel/web. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-tsaipranay]

Hi @sureshrawat048 ,

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.

Thank you.

[v-tsaipranay]

Hi @sureshrawat048 ,

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.

[nilendraFabric · Accepted solution]

Hello @sureshrawat048 

Excel Online does not offer native functionality to automatically refresh Power Query queries without user intervention.
The "Refresh All" button in the web version only works for certain types of connections, such as Table/Range and OData feeds, but not for all Power Query sources.

Please accept this answer if this is helpful