How can i have two datasets in a report?

[grimyz]

So for my project, my teacher requested me to have two different datasets in one report so i can compare the different datasets in order to come out with a conclusion. However after googling i can't seem to find any info on how to merge two datasets into a report. Need urgent help please, thank you!

The datasets are like an excel table data ish (tidydata)

[Sujit_Thakur]

Dear @grimyz  ,

Thanks for kudos and accepting as solution 

If in future you have anydoubts

Please feel free to ask a question and tag my user name 

I'll be more than happy to help you 

Regards , 

Sujit Thakur 

[Sujit_Thakur]

Hello friend ,

You can use get data --> combine folder. To merge to data 

If and only if you have same column name and same excel sheet name in both the data files 

Tag me if you have doubts , I'll be more than happy to help 

Please give a kudos if you feel helped 

And if this solved your querry please accept this post as solution so that our other global friends can see this answer too😁

Regards ,

Sujit Thakur 

[Sujit_Thakur · Accepted solution]

@grimyz  

For more help you can go watch this video from Avi singh 

https://youtu.be/9sfCDCpWTfc

If this solves your problem please give kudos by clicking thumbs up Button and accept this post as an solution 😁

This will get you to your solution 

I do expect a kudos and accepting this post as solution .

Thanks in advance brother 😊

Regards 

Sujit Thakur

[grimyz]

Am i able to add the second dataset into an EXISTING report that i have made one the first dataset? or is it not possible? thank you

[Anand24]

Hi @grimyz ,

You can add as many datasets as you want in your existing report.

You just need to go to Get Data and select desired data source.

Reference Image:

After adding new datasets, if you want to view the data and or perform/change datasets joins, you can go to data and model tabs.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Syndicate_Admin]

Good afternoon friend.

I try to do what you mention with power BI dataset and it won't allow me to.

When doing it with another type of data like excel, .csv, text if it gives me the option but when I want to add another dataset it does not give me the option.

thanks for your support