I wish to merge 2 existing entities into 1 tables, within the Power App CDS. In the Dataflow, Power Query has a 'Combine tables' option to Merge queries as new, but this does not access the existing entities. Why don't I see my existing entities available in the table selections?

steph_io Did you add the other entity as a data source in Power Query Online? You can only combine the data sources that are in your list of queries.

Power query combine tables not working in PowerApps

Anonymous
Not applicable
6 years ago
It appears that Power BI is not recognizing stg_Encumbrance_Static. Are you able to visualize the content of the table in Power BI Desktop?
Anonymous
Not applicable
6 years ago
steph_io
Did you add the other entity as a data source in Power Query Online? You can only combine the data sources that are in your list of queries.
- steph_io
  Advocate II
  6 years ago
  I had made a separate query to load each entity. These were essentially my staging tables. I had planned to do the transformation individually then combine the results into the 1 production table, with the Merge function.
  
  I have a 'clean up' mapping file that I will need to run against each fact table. So with this restriction, I would need to bring that file into each query (each dataflow will need to load this file). That is unfortunate. In the Desktop app, it is possible (and more efficient) to just reference the 1 existing mapping table in Power Query.
  
  Thank you for your quick response.