Power Query Excel Refresh Done but data not getting updated

[aman_0504]

Hi ,

I am facing this issue for the last few days and i am totally unable to understand the reason , i have tried my best to search online but .

I have taken data from 3 folders each having multiple Excel sheets and imported it in separate query for each folder. 

Every day EOD is a new file in all the folders. 

Once the data is loaded in the three queries respectively, then it flows to other queries where custom coloums are added with some calculation. 

Data flows through multiple queries one after the other and the last query is displayed. 

Issue is when I refresh i don't get any error. And data is not updated.

I manually checked each query whether new data files are being read. And yes they are. It is just that it is not flowing to the following query. 

And even manually refreshing the query is not working . 

PS--- This issue started after is changed my workstation and hence had to re-configure the data source address. ( FROM 😧 to E:). 

[aman_0504]

Should I clear my cache ?

[aman_0504]

The new data is in the source queries. I have filtered out and verified. 

I cannot see the new data in the appended query. 

There are multiple appended queries one after other. Each as a source for the next query. 

All i am doing is pulling data as source from the previous appended query. 

What can be the issue?? How do I solve it. ?

[Imrans123]

Alright, so it's a chain of queries until you reach the final query? Or are you using Data Flows where you have a chain of multiple data flows where one refreshes following the next and so on?

Issue isn't related to cache as far as I understand since it's refreshing successfully. It's something to do you in your transformations in power query. Also, I am assuming that if it's multiple dataflows, all data flows are being sucessfully refreshed in the correct order to make sure the latest data flows into the final query in the chain.

One way I would troubleshoot is that for each appended query, I would filter out the sample new data both right after the append step and at the end of the query. If it doesn't show up right after append step, you're not appending the correct query. If it is showing up right after append but not at the end, there may be a transformation filtering out new data.

If it's a chain of appended queries, I would see on which specific query the data stops flowing in and address it from ther.

[aman_0504]

Hi ,

I filtered out the query which in which data flow is not going . But now what??

Is there i can share with you the file ,or i can share my screen ?? 

I am attaching the screenshots. 

There is one screenshot of advance editor , this is the query in which data is not flowing. Before this i have manually traced the data by filtering it out. But it's not flowing in the advance editor screenshot query. 

 

  

[Imrans123]

So if I understand correctly, you have 3 source queries for 3 folders and a consolidated query which appends all the 3 queries together and applies calculation, 

I would check the 3 source queries first. Filter out a row that you know is new and see whether you can see that row. If you cannot see the new row, then your data source address is wrong. 

If you can see the new row, then remove the filter and go on to the consolidated query. Add the same filter on the consolidated query right after the append step and see whether you can see the new rows. If you can see the new rows, then it maybe that one of the calculations is filtering out the new rows. If not, then you may not be appending the right queries.