Forum Discussion

steph_io's avatar
steph_io
Advocate II
6 years ago
Solved

Power query combine tables not working in PowerApps

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 existin...
Need Help
  • Anonymous's avatar
    Anonymous
    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.

Anonymous's avatar
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's avatar
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.