Forum Discussion

AdamWidi's avatar
AdamWidi
Frequent Visitor
7 years ago

Service Principal with Power BI using Data Gateway

Currently the Service principal account cannot leverage the On-Premises Data Gateway since it is not a mail-enabled account. This prevents a Power BI Embedded solution to leverage an on-premises SSAS...
General Comment
Need Help
Jayendran's avatar
Jayendran
Solution Sage
6 years ago

Hi AdamWidi / brentcarlson / baouss ,

 

Currently this is not yet implemented by PowerBI. I've already asked the same question long back and found this idea is already asked and waiting for more votes.

 

Please provide you vote for the below idea.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37055242-service-principal-with-power-bi-and-data-gateway

 

I'll reach out to powerbi team and will try to find the ETA for this feature.

  • brentcarlson's avatar
    brentcarlson
    Frequent Visitor
    6 years ago

    Jayendran Thanks for the info! Let us know if you hear anything from the Power BI team on this issue.

     

    Also, I read a Microsoft documents that states: Customers that configure row-level security (RLS) using an SQL Server Analysis Services (SSAS) on-premises live connection data source can enjoy the new service principal capability to manage users and their access to data in SSAS when integrating with Power BI Embedded.  (https://docs.microsoft.com/en-us/power-bi/developer/embedded-row-level-security#on-premises-data-gateway-with-service-principal).  This articles implies, that even though you have to use the API to add it, it should work? Based on what your saying is this documentation wrong (or am I misunderstanding it?)

     

    Thanks!

     

     

    • AdamWidi's avatar
      AdamWidi
      Frequent Visitor
      6 years ago

      Thanks brentcarlson for the link to the article.  Based on the date of the post, the capabability was added after we initially attempted, so this may now be possible.

      • brentcarlson's avatar
        brentcarlson
        Frequent Visitor
        6 years ago

        AdamWidi Let us know if you get this working. So far, we haven't been able to see it work; even though the service principal shows up in the access list for the gateway now.