As security best practice our Client has restricted developer roles to Contributor on their Azure Portal resource group. All is fine but this seriously restricts using any kind of azure integration (deployments, server explorer, cloud explorer etc) from Visual Studio if we use the Contributor role to sign in to azure from Visual Studio. We are working on typical MSBI services like data lake analytics (usql), azure Analysis services, dw. And we cannot use any of the visual studio azure connectivity features.
I found a solution, to use a management cert. But MS site warns against using this as it will allow access to all azure resources defeating the purpose of contributor restrictions.
Could I please request for any guidance?