Forum Discussion

Kraaitje's avatar
Kraaitje
Icon for Helper I rankHelper I
9 years ago

Use the power BI Enterprise Gateway for multiple client on different domains ideas

We are developing a central SQL database for Power BI reporting for multiple clients. The ideal situation would be if we can upload reports to our own domain, for example [email protected] and share the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Kraaitje,

Currently, we are not able to use Power BI on-premises gateway in a single server for clients in different domains. An idea about installing multiple instances of the on-premises gateway running on one server has been submitted in the following idea, please vote it. In your scenario, when you install on-premises gateway on the servers added for clients, there is no need to install SQL Server Native Client.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16267018-support-for-multiple-instances-of-the-on-premise-d
 
In addition, another method is to create content pack for your dataset,reports and dashboard, then publish the content pack to customers. However, content pack can be only shared with users inside your organization. According to this idea, the feature that publishing content pack outside organization is under review.

Thanks,
Lydia Zhang

  • Kraaitje's avatar
    Kraaitje
    Icon for Helper I rankHelper I
    9 years ago

    Anonymous Yes that would be the solution (create content packs outside the organisation) but it's not available yet and I don't know if it will ever come!

     

    Another option could be to push the database to an Azure database and connect the reports to this database to refresh the data. The disadvantages of this solution are extra costs and extra code to write to get the data in Azure.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago
      Kraaitje wrote:

      Anonymous Yes that would be the solution (create content packs outside the organisation) but it's not available yet and I don't know if it will ever come!

       

      Another option could be to push the database to an Azure database and connect the reports to this database to refresh the data. The disadvantages of this solution are extra costs and extra code to write to get the data in Azure.

       


      Hi Kraaitje,

      Yes. The feasture that publish content pack outside organization is not avaliable yet. Please vote that idea.


      In your scenario, when sharing reports to external users, there is no direct method to give them access to the data source in Power BI. You would need to weigh the cost of Azure database and gateway on multiple servers, then choose the appropriate one.

      Thanks,
      Lydia

      • Kraaitje's avatar
        Kraaitje
        Icon for Helper I rankHelper I
        9 years ago

        Anonymous Or maybe the new SSAS Azure solution will work with role level security without the need of active directory. I can connect the SSAS to my on premise database and connect the reports to this model. I can pass the users email to the model and filter the rows...