How to COMBINE DATA with MERGE and APPEND in Power BI

What if there is 2 tables...one in portrait form n another in landscape.. also having no similar column or rows?

Thanks a lot for merge by mult columns, it's very useful!

Hi,
Great video, really appreciate your time and effort putting it all together.
Queston: how to join tables, where one row is related to multiple rows in another table?

Should you be able to merge two data sources e.g. excel and a BYOD. I have been able to do it in desktop and refresh without issue but as soon as I publish to the web the refresh stops working - data connection issue but no error info of any help.

I have been able to drill down to my merge tables being the issue, as if I disable them, the rest of the report refreshes ok.

Thank you for the video - really great. I have 3 tables for historic and current data that I append together. I have unclicked the enable load of the historic data but when I refresh the big appended table ( historic + current) the historic data refreshes again - even though it never changes. As the historic data contain about 5 million rows this takes a long time. Is there a way to stop this?

Great explanation, very helpful! Thanks!

Thanks for he video. Should I limit the rows (50k) in every table b4 want to merge before and also on the merged table as well?

Thanks for the video. I have two identical datasets: one is a historical data and saved as a csv file and the other one is from an API which gets refreshed everyday. I have built all my dashboards based on the API. Now if I follow your steps and append the historical one with the API one, does the data that’s coming from API in the appended table still gets updated or it overwrites the historical one as well? I need to keep the historical data fixed and refresh the API data daily.

This video was amazing! I am currently working on a project very similar to the examples that you showed. I'll be implementing the steps that you've mentioned. Gracias!!!

Super video. Thanks Bas

Thanks for your sharing, it is useful for me to load excel files in a folder. But I am facing an issue, everytime I refresh, I am required to wait to refresh old files(which no changes) May I know it is possible only refresh new files? Thanks.

Hello everyone , I have a question , can we merge two pages into a single page in power bi? Any help will be appreciated 🙂

Thanks

Fantastic video! Thanks a lot!

Hi, great video i do have a question what if the salary for the employee is updated from a new file in the folder can powerbi update the salary column

Your video was SO helpful! Thank you so much!
I just have one question, how do I combine 2 unrelated tables?
For example:
Table 1: Fruits
Apple
Strawberry
Table 2: Vegetables
Kale
Lettuce
Spinach

Desired result:
Fruit,Vegetable
Apple,Kale
Apple,Lettuce
Apple,Spinach
Strawberry,Kale
Strawberry,Lettuce
Strawberry,Spinach

Is It possible? How?

Great content, tyvm for sharing. Question: what if the headers of one file are in Dutch and the other in English? So contentwise it is ok to append but the names are different?

Very well explained (again). Any chance of creating a video that shows how to append powerbi datasets to each other please?

Great video, I want to know all the option given in merging data and you clear my all doubts Thanks 😊 👌🏻

Amazing

My append adds data horizontally instead of vertically, like I have 2 tables with 3 columns each, it creates another table with 6 columns instead of APPENDING, why??

Can you enable auto captions please? It's essential for the hard of hearing. Thanks!

hi !
awesome video! the bonus content helped me a LOT. It's some daily problems that other videos doesn't show.
thanks a lot :)

It is still very confusing, i have a zip file which contains various data like few excel files (which is fine), but a map, and some random pdf and text file which are not in the form of table, I don't know what to do

Hi Can anyone help with the error message (" [Expression, Error] The key didn't match any rows in the table") I am getting while running the power query? Basically, I have a Power Query appending 19 Excel files from a folder but sometimes when I am refreshing the data the files may be in use by users and this error message will pop up.

Hey Bas, starting from the bottom of your catalogue and working my way up. REALLY should have watched this one a few weeks ago, would have saved myself a lot of hassle! Thanks for all the help.

amazing content, i find your video yesterday and browse your channel , you helping a lot sir thank you so much

Oh my I've been trying to work this out for hours- this was so much clearer thank you!!!!!!

I have scene many video on appending but most of them just explained the definition and done, but you showed different scenarios and their outcome. It was really amazing brother just subscribed you immediately.

If I have 2 excel sheets one contains 100 records other contains 200 records. No common column between them to create relationships. But I have to perform an addition operation on the unit price column which is present in both but the value contains different . How can I perform an addition and generate a new column ? If merg is used then it will need the same number of records and append i don't want. What is the solution for this? Please tell me the solution?

Hey, can you help me with how to append Table 2 (ID, Name, Sal) into Table 1 (ID, Name, Sal) where filter out the IDs from Table 2 if the same ID is already exist in Table1 using M-Query in Power Query editor. Thanks!!

hey buddy, i need assistance in power bi query, i'm facing a issue when upload the table in the existing report

gracias maestro

This video really helped

Man, this was a life-saver!!Thanks a ton!

Amazing video❤!

Great Work!! You make power Bi so easy, love your explanation

Thanks for this. Also when you count the rows it would help if you show exactly what you click to remove the row count. I just started over with combining the tables since I wasn't able to find how to remove row count

You are an Excellent Teacher !!!!

Very comprehensive explanation! Appreciate your efforts!

After appending queries and creating new one as a result, if we disable load, how can we then ensure that it gets the latest data?

not to hate on the vide. Because I appreciate you explaining stuff....but note to self....I would rather you just show the window in full screen, than a smaller window and be showing mostly yourself on the video. I think it helps to see the full screen. But at the end of the day this is your video. Just a suggestion on my part. But again, thankful for the information being taught.

Perfect explanations.

When I went to home I could not find the option to append quires. Would anyone know why?

I need your help please! You re very good. But what i need to do is to put precisely two columns stacked one on top of the other without merging the rows. How can i do that?

You rock!

To be honest you are a life saver on this video ....Because when my instructor was explaining I was lost and I find it hard to understand.

pls what if we have just 2 tables, should we select 2 tables or 3 or more tables ?

how to export data merge after join 2 table