Forum Discussion
Helper IComputed Entities and merge
Technically, a dataflow is an entity if it is loaded. If it is not loaded, then it is not an entity and you can reference it in anothe query. Using my above example, right click on query A and turn off "enable load". After you do this, you can right click query A and select "reference" to build query B. This is allowed. So if you are trying to referenece (say) Customers and customers is loaded, then simply right click Customers and select "duplicate". Right click again and turn off "enable load", then right click the copy of customers and reference it. The downside is you now have 2 copies of the customer query, but the upside is you don't need to pay for premium.
Helper IWhat does setting it to "not load" do? Will I still be able to get the columns I need into the main view?
Community Championgood question - I may have my terminology wrong here. My understanding is this will prevent you connecting to them from Power BI desktop.
- MattAllington
Technically, a dataflow is an entity if it is loaded. If it is not loaded, then it is not an entity and you can reference it in anothe query. Using my above example, right click on query A and turn off "enable load". After you do this, you can right click query A and select "reference" to build query B. This is allowed. So if you are trying to referenece (say) Customers and customers is loaded, then simply right click Customers and select "duplicate". Right click again and turn off "enable load", then right click the copy of customers and reference it. The downside is you now have 2 copies of the customer query, but the upside is you don't need to pay for premium.