Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I keep getting the following error:
Query 'Merge2' (step 'Expanded Workbook(2)') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
This is the merged query:
let
Source = Table.NestedJoin(#"Matching(3)", {"Unique ID"}, #"Workbook(2)", {"Unique ID"}, "Workbook(2)", JoinKind.RightOuter),
#"Expanded Workbook(2)" = Table.ExpandTableColumn(Source, "Workbook(2)", {"Unique ID", "What WG SFS Intervention level is intervention best suited to? (Dropdown) See note!", "What WG thematic outcome(s) does the intervention deliver? (Dropdown - select all that apply in descending order of delivery magnitude)"}, {"Unique ID.1", "What WG SFS Intervention level is intervention best suited to? (Dropdown) See no", "What WG thematic outcome(s) does the intervention deliver? (Dropdown - select al"})
in
#"Expanded Workbook(2)"
I have tried lots of different things. Looked at https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/ but can't get it to work.
You may have more luck posting this in the Power Query area of this forum:
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services
Sorry I can't offer anything more helpful, I'm just not able to read Power Query well enough to see why that's going wrong.
Thanks @pmay have done this as well. Will hopefully get it figured out with community help
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |