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

  • ilav's avatar
    ilav
    Frequent Visitor
    5 years ago

    Were you able to map the DSN associated to the gateway via an Powershell or API?

    • brentcarlson's avatar
      brentcarlson
      Frequent Visitor
      5 years ago

      We still have not been able to get this work. We got the gateway to show the Service Principal using the API call; however we think the issue stems inside of SQL Server and/or SQL Server Analysis Services. When using Azure hosted SQL Analysis Servvices there is an option to add an appid (of the Service Principal); on-premise SQL Analysis Services does not give this option. We think this is why it is not working (and makes sense); as the Service Principal doesn't have access to SQL. We are looking at alternatives on how to translate the authentication from the gateway into SQL Analysis Services. The documenation implies this should work but doesn't give any details on how to make it work.