Service principal, managing on premise gateways

[juhokunnari]

According to instructions here https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/adddatasourceuser, you should be able to add service principal as user for on premise data gateway.

This is needed to make CI/CD pipeline for power bi reports in our use case.

Following instructions I'm getting error "DMTS_DatasourceAccessRightIsNotSupportedError". Is there something wrong with our service principal, access rights etc or why this cannot be done? It prevents us from making an efficient chain for reports from development to production.

[v-yiruan-msft]

Hi @juhokunnari ,

Please review the content in the following threads, hope they can help you.

DMTS_DatasourceAccessRightIsNotSupportedError when trying to grant SPN account access to gateway (last post)

Service principal with Power BI and Data Gateway

Best Regards

[juhokunnari]

The first thread you linked points to instructions https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/adddatasourceuser#example-for-giving-rea... which quite clearly states "example for giving ReadOverrideEffectiveIdentity access right to a service principal". So in theory it should work but in practice you will face an DMTS error.

Is this something that is an known issue and will be fixed? Otherwise those instructions are quite misleading and should be modified.