cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

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.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors