How to use different datasets(pbi projects on the same account) for one report on powerbi service?

[utkubag]

 

I have 2 datasets on my powerbi service account, I want to merge these two and create one report from them. The table names on those and components are the same. Also my problem comes from that I have many local places that are using powerbi desktop, and those uses same powerbi account, they publish their datasets to powerbi service by gateway from their servers to cloud. So I need to merge them on powerbi service, not desktop because I have no authority to connect to locals.

[v-danhe-msft]

Hi @utkubag ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

Hi @utkubag.

Based on my test, in your situation, I am afraid you could not achieve this feature for your dataset in different report in Service, but you could try to use dataflow to create differnt entities for your different data source:

https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use

Regards,

Daniel He