Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
utkubag
New Member

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
v-danhe-msft
Microsoft Employee
Microsoft Employee

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.

View solution in original post

2 REPLIES 2
v-danhe-msft
Microsoft Employee
Microsoft Employee

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.
v-danhe-msft
Microsoft Employee
Microsoft Employee

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.