Forum Discussion
Refresh Appending Queries
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_48381 year agoHelper IV
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-Rathinavel1 year agoSuper User
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