build data model with data from different, external organizations

[fess440]

Would it be possible to build a power bi data model that imports specific tables from power bi data models of external organizations given permission? I have power bi pro only. Could I get some clarification on the licenses required? What would be the minimum required to get this done please? Ultimately I'd like the data model to rest on the service and refresh automatically using on site premises gateway. I'd like to use the 'external tables' as if they were any other table in power bi and use them in data model. Thanks for your help! Any doubts/questions please ask.

[v-eachen-msft]

Hi @fess440 ,

Yes, it is possible. If your data source is on the cloud, you don't need an on-premises gateway. You just need to input credentials to connect to data source.
Pro license has met the requirements. If your data is larger than 10G or you have special requirements in terms of capacity, you may need Premium license.

Here is the document for your reference:
https://docs.microsoft.com/en-us/power-bi/refresh-data#review-data-infrastructure-dependencies

[fess440]

@v-eachen-msft  thanks for response. it says here: https://docs.microsoft.com/en-us/power-bi/service-admin-azure-ad-b2b that '

• Guest users can't use Power BI desktop to connect to service datasets in the Power BI service

It is exactly what i'm hoping to do. any ideas please?

[venal]

@fess440 

As you confirmed that you can able to access the data, so please create a report in Power BI Desktop by using the same credntials and publish, share the report to the users.

Please refer the link for sample report creating and publishing, refresh.

https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

[fess440]

@venal  thanks for your response. i need specific directions please. assume the following: i have dataset model in my company tenant, and external company has dataset in a separate tenant. how do i exactly import a specific table from the external company's data model in the separate tenant?