cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
utkubag Occasional Visitor
Occasional Visitor

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

 

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to use different datasets(pbi projects on the same account) for one report on powerbi servic

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: How to use different datasets(pbi projects on the same account) for one report on powerbi servic

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: How to use different datasets(pbi projects on the same account) for one report on powerbi servic

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.