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
AdamWidi's avatar
AdamWidi
Frequent Visitor
7 years ago

I did get a suggestion to try adding the Service Principal to an Azure AD group, make this group a gateway admin, and add user mapping in the gateway connection.  Has anyone had success with this approach?

baouss's avatar
baouss
Frequent Visitor
6 years ago

Hi AdamWidi 

 

did you get this solved with a service principal?

 

Cheers

  • brentcarlson's avatar
    brentcarlson
    Frequent Visitor
    6 years ago

    Was anyone ever able to solve this? I have the same issue. I was able to add the service principal to the data source on the on-premise gateway using the API; but it still doesn't seem to work even though the service principal now shows in the access list.

    Followed the example here: https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/adddatasourceuser - Tried using both ReadOverrideEffectiveIdentity and Read as the datasourceAccessRight

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      You need to add the service principal as gateway admin and not as datasource.I also have same issue as sp doenst have email id to get added it as an admin.Any one knows how to get this added?Thanks