Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow adding of Service Principals to Gateway Datasource Users

Vote (1) Share
Matt Butler's profile image

Matt Butler on 22 Jun 2021 13:36:19

Please allow the adding of Service Principals to the Gateway Datasource Users list.

Workaround:

I was working to implement true CI/CD between Azure DevOps and our Power BI service.

Had a lot of trouble updating the Dataset's (report) Datasource and having it automatically "Maps To" the correct Gateway Datasource (DSN).

So, here is the solution that worked:
The Service Principal has access to update the Dataset's datasouce, but doesn't have access to the Gateway datasource (interface doesn't allow it at this time). So, we use the Service Principal to update the datasource in one PowerShell script, and a Generic Id to refresh the gateway (Bind To Gateway) in another PowerShell script. These two tasks, running sequentially, now run successfully in our DevOps Release Pipeline.