Forum Discussion
New Appended Query issue/question
Thanks for replying.
All Data has all the other queries in the Query Dependencies in Power Query.
I am pulling all the data from the other queries so I believe I need to keep enable Load.
When I go in to Transform Data => Data Source Settings, clear the cache isn't there.
Will using Reference give me all the data in one table?
Thanks
J
When appending multiple queries, Power BI sometimes keeps references to the original queries, especially if transformations (like Replace Values) are applied before appending. This can lead to unexpected behaviour where changes don't fully apply.
Instead of appending and modifying within the same query, try referencing the "All Data" query and applying transformations separately.
Create the Appended Query:
- Append all 30 queries together into "All Data".
- Do not apply transformations (Trim, Change Type, Replace Values) inside this query.
Create a Reference to "All Data":
- In Power Query, right-click "All Data" and choose Reference.
- This creates a new query that only refers to "All Data" instead of directly modifying it.
Apply Transformations in the Referenced Query:
- Now apply Trim, Change Type, Replace Values, Sorting Rows, etc., in this new query.
- This prevents Power BI from re-evaluating the original queries when making changes.
Load Only the Referenced Query:
- Go back to Power Query.
- Right-click the original 30 queries and uncheck "Enable Load" so they don’t get loaded into the model.
- Keep only the referenced query loading into Power BI.
Let's try this and see what it does.