Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

build data model with data from different, external organizations

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.

4 Replies

  • venal's avatar
    venal
    Icon for Memorable Member rankMemorable Member

    Anonymous 

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable

      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? 

  • v-eachen-msft's avatar
    v-eachen-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    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