Power query combine tables not working in PowerApps

[steph_io]

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?

[Anonymous · Accepted solution]

@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]

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.

[Anonymous]

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?