Issue merging queries

[GLApplis]

Hello.

I have basically merged two queries and expanded columns. All looks good in the Query Editor, I get the columns from second query added at the end of the first query.

When I close the Query Editor, during the refresh I get the error : " Query 'Deal' (step 'Expanded Booking') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. "

I have done it again, and again from scratch, still the same. I don't know what I can do. The Booking table is loaded first in the steps, if this is needed.

Thanks for your help.

[GLApplis]

Thank you both for you answers. I had to work on other priorities but this topic will come back and I will review them. Best regards.

[Anonymous]

Hi @GLApplis 

The error message you're encountering in Power Query ("Query 'Deal' (step 'Expanded Booking') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.") suggests there's an issue with how your queries are structured, specifically regarding data access and query dependencies.

Here are some steps and considerations to resolve this issue:

1. Review Query Dependencies: Go to the 'Home' tab in Power Query Editor and click on 'Query Dependencies'. This will show you a diagram of how your queries are related. Ensure there's a logical flow and no circular dependencies.

2. Adjust Load Settings: Make sure that intermediary queries (queries that are used as a basis for further transformations but are not needed as final outputs) are not set to load to the workbook. You can adjust this by right-clicking on the query in the queries pane and selecting 'Enable load to worksheet' or 'Disable load' appropriately.

3. Reference vs. Duplicate: If you're using the 'Reference' option to create a new query based on an existing one, try using 'Duplicate' instead. 'Reference' creates a dependency on the original query, which might contribute to this issue. 'Duplicate' creates a separate copy that does not have a direct dependency on the original query.

4. Simplify Steps: Sometimes, the error can be resolved by simplifying the query steps. For instance, if you have many transformations, try to minimize them or combine them into fewer steps if possible.

5. Directly Access Data Sources: Review the step causing the error ('Expanded Booking'). Make sure that the step accesses data in a straightforward manner, without unnecessary dependencies on other queries or steps.

6. Reorder Steps: Ensure the 'Booking' table (or the data it relies on) is loaded or processed in a way that it is fully available before being referenced by the 'Deal' query. This might involve reordering your steps or ensuring that any data transformations occur before the 'Deal' query attempts to reference this data.

7. Rebuild the Data Combination: As suggested by the error, rebuilding the data combination might be necessary. This could mean redesigning how your queries merge or reference each other. It might involve creating a more linear or hierarchical structure of query dependencies.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @GLApplis 

Few items you can check
1. is 2nd table already merge with another table and do you have access that table? Please check the Privacy level.
2. When marge two tables, please check the data type of both the table
3. Please create a new pbix file, load the two files and then try to merge them
4. 'Expanded Booking' in this step, check the M Code, it is already referencing other table or not

Let me know if that works for you

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin