Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.