Refresh Appending Queries

[cheid_4838]

I have four queries using four different SQL statements that I appended into a new query.  Each query have the same columns and that has been verified.  When I make changes to one of the four queries to exclude records and then refresh, the new appended table doesn't update as it should. The changes I made work in the four main queries, but are not showing in the appended query when refreshed.  Is there a trick to refreshing an appended query in Power BI?  Thanks. 

[danextian]

Hi @cheid_4838

Any changes made to the referenced queries should be reflected in the combined query, which will prompt you to apply the changes. If this doesn't happen, it could be because you modified a non-referenced query, simply refreshed the preview, or applied extra transformations in the combined query that exclude the changes in the referenced query. Additionally, for each appended query, I suggest adding an extra column to identify the source (e.g., Query A, Query B, etc.), making it easier to track which query each record in the model comes from.

[rajendraongole1]

Hi @cheid_4838 -Ensure that all source queries have Enable Load turned on. Without this setting enabled, the appended query won't fetch updated data:
1.Go to Transform Data > Queries.
Right-click each query and ensure Enable Load is checked.

2.Refresh the entire dataset in Power BI Desktop:
3.Go to the Home tab and click Refresh.
This ensures that the data in your data model syncs with the queries.
4. Validate Query Logic
Open the Advanced Editor for your appended query and check the M code. Verify that the appended query is referencing the correct queries and transformations.

Go to File > Options and Settings > Options > Data Load > Clear Cache. clear the cache from this path.

still, if issue exist, delete the existing appended query.Recreate it using Append Queries in the Power Query Editor.

[cheid_4838]

I completed each of those steps multiple times and still no luck. I cleared the cache and then refreshed with no luck.  I will try recreating the appended query again which I did once before.  Thanks for your help

[Jai-Rathinavel]

@cheid_4838 If your are checking the data changes on power query sometimes it won't display the data with updated logic. You can refresh the data and check it in the frontend data view