Forum Discussion
Power Query Excel Refresh Done but data not getting updated
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. ?
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.
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.