Combine Two Power BI Datasets in one Dataset with same metadata

[kolturra]

Hi,

I am working on project where i need to combined more than two Power BI Datasets in to one Power BI dataset and reason why we are doing it because of performance and maintain data standards.

Can some one help me with work around for this or articles which can help me to understand more how to do it.

Note : Here i am refering completely Power BI sets. I am open with any suggestion and also we will be using SQL to store these dataset data.

Thanks,

K Raghavender Rao

[zenisekd · Accepted solution]

Hi, what you do is you choose as the data source the "Power BI datasets".

You choose your desired dataset. Then you again go for Get data - Power Bi dataset.
It tells you, that you need to add local model.

Which you do and then you can connect to the second dataset. 

Kudos and mark as solution appreciated.