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

Merge data into a table without creating a new table?

Hi there,

I have a main table I pull from Redshift.  All my queries and measures and reports are from this table.

I have mapping tavble I want to merge with it.  I know how to merge tables but it creates a new table.  

Can I do with without creating a new table?

The downside of creating a new table would be changing all my formulas and visuals to use the new fields.

In merging into the existing table it only adds one more field.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Merge data into a table without creating a new table?

So generally you would create the query for your second table. You would disable load on this table to prevent it from creating a new table in the model. You would then add a merge step to your first query to merge it with your second query.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

2 REPLIES 2
Super User IV
Super User IV

Re: Merge data into a table without creating a new table?

So generally you would create the query for your second table. You would disable load on this table to prevent it from creating a new table in the model. You would then add a merge step to your first query to merge it with your second query.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

HarryT Regular Visitor
Regular Visitor

Re: Merge data into a table without creating a new table?

Thanks that was it.  I've always used the merge on the left hand side and not directly on the table.

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