Combining two or more datasets in power bi service

[Anonymous]

Hi, 

We have several companies in the Group. Each company has it's own report and dataset created and publish on the  power bi service. 

Example: Company 1 report and Company 2 report (These are two different power bi reports with different datasets but almost )

Our requirement is to create another application for the group head based on the datasets of the applications created for the companies. Since the table structures are same in all of the application is it possible to append the datasets shared in power bi service. Final application created for the group will have all the datas of companies 

[Anonymous]

@Fowmy  is it possible to share the datasets with external users and create new reports outside the organisation ? 

[v-jayw-msft · Accepted solution]

Hi @Anonymous 

Your Power BI admin can allow external guest users to edit and manage content in your organization. If so, your external users won't have that consumption-only experience. They can edit and manage content within your organization.

For more details please check the document.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-azure-ad-b2b#guest-users-who-can-edit-and-manage-content

Best Regards,

Jay

[Fowmy]

@Anonymous 

Effective December 2020 Power Bi desktop update, you can now create new reports based on different Power BI Datasets from the Power BI service. You can check out this article: 

https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn