How to Combine 2 published data sets in to 3rd PBIX.

[srinivaspappu]

I am unable  to Combine 2 published data sets in to 3rd PBIX.

I have published 2 datasets to PBI service. I want to combine the data of Dataset1 and Dataset 2 in to a PBIX. But the moment I finished Get data of Dataset1, The Getdata is disabled to fetch the data of Dataset2.

Any suggestions please.

[srinivaspappu]

Thanks Dinesh,

My requirement is to combine both datasets' data and show in a single visual.

I am able to achieve it by the dataflows, but landed in to refresh delay.

The Dataflow refresh takes 16 minutes and the Report Refresh takes 9 minutes. But The refresh schedule is for every 30 minute interval. So to get the latest data, it takes 30(16 min of data flow exec time and 14 minutes waiting)+9(Report refresh) = 39 minutes.

Is there any way I can reduce this time ?

[Dinesh_Suranga]

@srinivaspappu ,

Hi,

As my knowledge there is no an option to get data from two existing data sets in power bi. But you can create one dashboard using visuals of your two reports.

Thank you.