cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
steph_io Regular Visitor
Regular Visitor

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 existing entities. 

Why don't I see my existing entities available in the table selections?

 

MergeTablesCDS.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
SKH19 Member
Member

Re: Power query combine tables not working in PowerApps

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

Annotation 2019-12-06 132046.png

View solution in original post

3 REPLIES 3
isacontreras Frequent Visitor
Frequent Visitor

Re: Power query combine tables not working in PowerApps

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?

SKH19 Member
Member

Re: Power query combine tables not working in PowerApps

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

Annotation 2019-12-06 132046.png

View solution in original post

Highlighted
steph_io Regular Visitor
Regular Visitor

Re: Power query combine tables not working in PowerApps

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.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors