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
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...

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Kraaitje,


    As stated in this blog, we would need to use Azure Active Directory to manage role based security for models.

    Thanks,
    Lydia Zhang