Power Query Connected Excel File Not Updating

Question

When I change the data in the source Text File, the data in connected Power Query Excel File not updating after clicking on the refresh/refresh all

https://drive.google.com/file/d/1j1-SYSjy3dXaYZwkCTTlRNLJqODxLtly/view?usp=sharing

Answer 1

Hi. Thank you for your question and reaching out. My name is John and I’d be more than happy to help you with your query.

You may able to fix this kind of concern by selecting Data > Queries & Connections > Connections tab, right click a query in the list, and then select Properties. Select the Usage tab. Select the Enable background refresh check box to run the query in the background. Clear this check box to run the query while you wait.

For reference, please see https://support.microsoft.com/en-us/office/1524175f-777a-48fc-8fc7-c8514b984440

Best regards, John

Answer 2

And you did not get any error message?

Open the Queries & Connections pane, any errors in there?

I can not reproduce the behavior after I changed the path to the source file in the query.

Andreas.

Answer 3

Thanks for your reply.

The Option box "Enable background refresh" is already checked. But my destination data file is not updating while I update the source data file

Answer 4

No I did not get any error message

Answer 5

I can only shrug my shoulders at that.

Andreas.