Using version 1.2.5
When deploying to azure analysis services receiving the error shown below when using "auto detect" in the firewall rules configuration.

When specify an IP range the following error is received

Hi Team,

On VSTS , I wanted to use SPN to connect to analysis services on Production environment, But when I am trying to pass variables with SPN username and Password, it is not logging in to analysis services, it give error exception has been thrown by target of invocation.
Can you please guide me on User credentials I need to give.

I have the below TMSL script where I want to pass variable for Database name and the member. This variable already exist in the release pipeline, but it doesn't allow me to use $(AASdbName) variable.

{ "createOrReplace": { "object": { "database": "AzureASDB", "role": "PowerBIEmbed_Role" }, "role": { "name": "PowerBIEmbed_Role", "description": "Reads custom information for Users.", "modelPermission": "read", "members": [ { "memberName": "", "identityProvider": "AzureAD" } ], "tablePermissions": [ { "name": "DIM_company", "filterExpression": "OR('DIM_company'[gcc_code_BK]=CUSTOMDATA(),OR('DIM_company'[gcc_code_BK]=\"ZCS\",'DIM_company'[gcc_code_BK]=\"ZZA\"))" } ] } } }

Would it be possible to add an option to the Azure Analysis Services Deployment step to invoke a refresh on the data model after the deployment completes successfully ?

Hi,

I Have a scenario where i have to load data into AAS model from a datalake store or a blob storage, currently i m not able to deploy it as there is no configuration for such data sources.

Thanks,
Punith.

In Azure Analysis Services it is possible to deploy to a special Management Server by using the special :rw (read-write) qualifier. This way you are able to deploy to the processing server without impacting your querying pool during deployment. After deployment you perform a synchronization to promote the changes in your processing server to the querying pool. Please see the scale-out documentation for more information https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-scale-out.

Currently when using this special qualifier the deployment tasks fails with the following error:

Error during adding firewall rule (Could not find server: '[servername]:rw' in any resource group in the currently selected subscription: [subscriptionid]. Please ensure this server exists and that the current user has access to it.)

This is happening because all the used cmdlets used for deployment work with this special qualifier but the Get-AzureRmAnalysisServicesServer and Set-AzureRmAnalysisServicesServer do not. These are being used to add and remove the firewall rule and they only work with the actual server name. Therfore, the :rw part should be stripped from the server name if it is there.

I created PR #42 with the fix.

I am currently creating release pipelines using this tool in order to deploy data models to Azure Analysis Services using Azure Repos Git. When I go through the fields for connection information and input usernames/passwords in plain text directly in those fields, the release runs fine and succeeds. When I attempt to set pipeline variables to use these passwords without storing in plain text, I find that it is not actually using those variables. A common error I receive is that an invalid client secret was provided. If I put that client secret in plain text on the tasks option, then it works fine. It is only if I attempt to use it as a variable that is supposed to be locked. I'm not sure if anyone else has run into this issue or if I am doing something wrong, but it would be beneficial to be able to use the pipeline variables for passwords and such.
Thank you!

Deployment task is not able to bypass the firewall using the hosted agent (cant be whitelisted in firewall since the hosted agent IP is dynamic)

Hi Jan Pieter, so you intend to support the Az Module in the near future?

Scenario: when aas is taking long to load model, our developer may cancel the job. This leaves a firewall rule named vsts-release-aas. When the job is executed again, a naming conflict prevents the job from proceeding.
A similar issue was reported in #35 but the code addition in commit 1e3f5e5 will not work because variable $addedFirewallRule, never previously referenced, was null and thus interpreted as false. This causes the condition door to remain closed in all circumstances. The variable $addedFirewallRule should be removed.

I would like to run the deployment using a service principle. I've tried different ways of passing the credential information, using AppId, ObjectId, and the app:AppId@TenantId. All of these options lead to an error "Error during deploying the model (Exception has been thrown by the target of an invocation.)".

I've looked in the code and I see that you do not use "Login-AzureAsAccount". Using this commandlet is the only way that I manage to get these database level commandlets working with my service-principal. Are you considering adding support for service principals / apps?

Hello, can you please investigate this? thank you for your time.

2017-08-23T17:50:31.7143905Z ##[debug]Caught exception from task script.
2017-08-23T17:50:31.7143905Z ##[debug]Error record:
2017-08-23T17:50:31.9019278Z ##[debug]D:\Agent_work_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.0.0\deploy-aas-db.ps1 : Exception setting "members": "The property 'members' cannot be found on this object. Verify that the property exists and can be set."
2017-08-23T17:50:31.9019278Z ##[debug]At line:1 char:1
2017-08-23T17:50:31.9019278Z ##[debug]+ . 'D:\Agent_work_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e8 ...
2017-08-23T17:50:31.9019278Z ##[debug]+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2017-08-23T17:50:31.9019278Z ##[debug] + CategoryInfo : NotSpecified: (:) [deploy-aas-db.ps1], SetValueInvocationException
2017-08-23T17:50:31.9019278Z ##[debug] + FullyQualifiedErrorId : ExceptionWhenSetting,deploy-aas-db.ps1
2017-08-23T17:50:31.9175469Z ##[debug]
2017-08-23T17:50:31.9175469Z ##[debug]Script stack trace:
2017-08-23T17:50:31.9175469Z ##[debug]at RemoveSecurityIds, D:\Agent_work_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.0.0\deploy-aas-db.psm1: line 99
2017-08-23T17:50:31.9331735Z ##[debug]at , D:\Agent_work_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.0.0\deploy-aas-db.ps1: line 58
2017-08-23T17:50:31.9331735Z ##[debug]at , : line 1
2017-08-23T17:50:31.9331735Z ##[debug]at , : line 22
2017-08-23T17:50:31.9331735Z ##[debug]at , : line 18
2017-08-23T17:50:31.9331735Z ##[debug]at , : line 1
2017-08-23T17:50:31.9487977Z ##[debug]Exception:
2017-08-23T17:50:31.9487977Z ##[debug]System.Management.Automation.SetValueInvocationException: Exception setting "members": "The property 'members' cannot be found on this object. Verify that the property exists and can be set." ---> System.Management.Automation.RuntimeException: The property 'members' cannot be found on this object. Verify that the property exists and can be set.
2017-08-23T17:50:31.9487977Z ##[debug] at System.Management.Automation.Language.PSSetMemberBinder.SetAdaptedValue(Object obj, String member, Object value)
2017-08-23T17:50:31.9487977Z ##[debug] --- End of inner exception stack trace ---
2017-08-23T17:50:31.9487977Z ##[debug] at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception)
2017-08-23T17:50:31.9644178Z ##[debug] at System.Management.Automation.Interpreter.ActionCallInstruction2.Run(InterpretedFrame frame) 2017-08-23T17:50:31.9644178Z ##[debug] at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) 2017-08-23T17:50:31.9644178Z ##[debug] at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) 2017-08-23T17:50:31.9644178Z ##[debug] at System.Management.Automation.Interpreter.Interpreter.Run(InterpretedFrame frame) 2017-08-23T17:50:31.9644178Z ##[debug] at System.Management.Automation.Interpreter.LightLambda.RunVoid1[T0](T0 arg0) 2017-08-23T17:50:31.9800602Z ##[debug] at System.Management.Automation.PSScriptCmdlet.RunClause(Action1 clause, Object dollarUnderbar, Object inputToProcess)
2017-08-23T17:50:31.9800602Z ##[debug] at System.Management.Automation.PSScriptCmdlet.DoEndProcessing()
2017-08-23T17:50:31.9800602Z ##[debug] at System.Management.Automation.CommandProcessorBase.Complete()
2017-08-23T17:50:32.0581540Z ##[error]Exception setting "members": "The property 'members' cannot be found on this object. Verify that the property exists and can be set."
2017-08-23T17:50:32.0581540Z ##[debug]Processed: ##vso[task.logissue type=error]Exception setting "members": "The property 'members' cannot be found on this object. Verify that the property exists and can be set."
2017-08-23T17:50:32.0581540Z ##[debug]Processed: ##vso[task.complete result=Failed]

I'm trying to set up an AAS deploy using this extension and I'm getting the following errors. Its configured to deploy with a named user who is configured as an AAS admin.

ERROR:
Error during adding automatic firewall rule (Authentication failed: User ID and Password are required when user interface is not available.)

Authentication failed: User ID and Password are required when user interface is not available.

Tried installing on a Server installation, didn't install. So is it possible to support a Azure DevOps Server installation?

Thanks for the extension, which is mostly working well for me.

When I check 'remove before deploy', I get:
Error during deploying the model (The property 'database' cannot be found on this object. Verify that the property exists and can be set.)

I can do this by using a TMSL script, but it would be nicer to have just one step.

we running into the same issue with the aas like in the the adf extension.

Is it possible to update also the aas extenion with that fix?

Greets
Christoph

Error:

2019-03-28T08:12:29.4547930Z ##[section]Starting: Deploy model to Analysis Service
2019-03-28T08:12:29.4998897Z ==============================================================================
2019-03-28T08:12:29.4999846Z Task         : Azure Analysis Service Deployment
2019-03-28T08:12:29.5000448Z Description  : Deploy Azure Analysis Service databases
2019-03-28T08:12:29.5000988Z Version      : 1.2.5
2019-03-28T08:12:29.5001489Z Author       : Jan Pieter Posthuma
2019-03-28T08:12:29.5002069Z Help         : [More Information](https://github.com/liprec/vsts-deploy-aas)
2019-03-28T08:12:29.5002695Z ==============================================================================
2019-03-28T08:12:34.4750218Z Added TLS 1.2 in session.
2019-03-28T08:12:42.7285736Z ##[command]Import-Module -Name C:\Program Files\WindowsPowerShell\Modules\AzureRM\6.13.1\AzureRM.psd1 -Global
2019-03-28T08:12:43.6547097Z ##[error]The following error occurred while loading the extended type data file: Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.Abstractions.IAzureContextContainer": The TypeConverter was ignored because it already occurs.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.Abstractions.IAzureContextContainer": The member SerializationDepth is already present.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.ProtectedFileTokenCache": The member PropertySerializationSet is already present.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.ProtectedFileTokenCache": The member SerializationMethod is already present.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.AuthenticationStoreTokenCache": The member PropertySerializationSet is already present.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.AuthenticationStoreTokenCache": The member SerializationMethod is already present.
Error in TypeData "Microsoft.Azure.Commands.Profile.Models.PSAzureContext": The member SerializationDepth is already present.
Error in TypeData "Microsoft.Azure.Commands.Profile.Models.PSAzureProfile": The member SerializationDepth is already present.

2019-03-28T08:12:43.7243435Z ##[section]Finishing: Deploy model to Analysis Service

deploy fails with the error message ##[error]The variable '$PSEdition' cannot be retrieved because it has not been set, i get this error message regardless if i choose "use latest installed version" option or if i specify a specific version such as "2.0.0"

Hi,

We are using the on Azure devops for the last 1year and so far everything was working good.

Now we are adding a new model\database, and its has an strange behavior. Some times works and other times show the error:
##[error]Error during deploying the model (The server sent an unrecognizable response.)

The strange thing its on the server side, Model is deployed and looks good. but on the release it shows error and does not allow the process to go on.

We are using the model version 1500. But we are using for another models and they are working fine. I guess its a problem on the model, but working on the server side and not showing anything else than a message with only "Error during deploying the model (The server sent an unrecognizable response.)" its very frustrating.

Hope you guys can help

Thank you
Francisco Menezes

When setting remove to 'true' for the deploy-aas-db task the following error is produced:

Error during deploying the model (The property 'database' cannot be found on this object. Verify that the property exists and can be set.)

I suspect the reason lies in a missing ConvertFrom-Json statement at line 158 in the following code which when produces the error in line 161:

I can create a pull request for this issue.

Hi!
I use the pipeline task for deploying AAS db and I'm deploying a tabular model with an Azure SQL Data Warehouse-data source.
I get the following error message:
##[error]Error during deploying the model (A semicolon was expected at index 158 in the connection string.)

I have no control over the connection string (and is it connection string to AAS or to the data source?). Any ideas of what is wrong?

Erik

When we run the CD, we are getting the following error message:
2019-11-13T14:32:10.1696600Z ==============================================================================
2019-11-13T14:32:10.1696834Z Task : Azure Analysis Service Deployment
2019-11-13T14:32:10.1696961Z Description : Deploy Azure Analysis Service databases
2019-11-13T14:32:10.1697055Z Version : 1.2.5
2019-11-13T14:32:10.1697153Z Author : Jan Pieter Posthuma
2019-11-13T14:32:10.1697253Z Help : More Information
2019-11-13T14:32:10.1697401Z ==============================================================================
2019-11-13T14:32:11.2556546Z Added TLS 1.2 in session.
2019-11-13T14:32:12.2685530Z ##[command]Import-Module -Name C:\Program Files\WindowsPowerShell\Modules\AzureRM\6.13.1\AzureRM.psd1 -Global
2019-11-13T14:32:12.4760410Z ##[error]The following error occurred while loading the extended type data file: Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.Abstractions.IAzureContextContainer": The TypeConverter was ignored because it already occurs.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.Abstractions.IAzureContextContainer": The member SerializationDepth is already present.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.ProtectedFileTokenCache": The member PropertySerializationSet is already present.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.ProtectedFileTokenCache": The member SerializationMethod is already present.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.AuthenticationStoreTokenCache": The member PropertySerializationSet is already present.
Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.AuthenticationStoreTokenCache": The member SerializationMethod is already present.
Error in TypeData "Microsoft.Azure.Commands.Profile.Models.PSAzureContext": The member SerializationDepth is already present.
Error in TypeData "Microsoft.Azure.Commands.Profile.Models.PSAzureProfile": The member SerializationDepth is already present.

I saw that somebody already had the same issue, but I was not sure what the resolution is.
We are using the On-Premise build and the version of AzureRM.profile we have is: 5.8.3.

Do we need to downgrade to a lower version? If so, which version we should use?

https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-scale-out#connections

As per the above, when using scale-out there are two different server names - one for management and one for end users. In the current task a server name is provided which is used for both deployment, and updating the firewall. The management server name has :rw appended and doesn't match the resouce name in Azure so the firewall update fails.

Currently this task requires that the firewall be updated on deployment so the only way to successfully deploy when using replicas is to enable "continue on error" and not set the firewall when deploying as it will error.

Would it be possible to look at adding a setting for deploying against replicas? This can automatically append :rw where relevant in the task.

Another useful addition to consider is an optional a sync to the replicas after the model is deployed.

Hi,
When deploying the model to AAS, I get an exception thrown. Any idea? the AAS is built through the same release pipeline (so using the same SPN), but does the SPN need to be added as an Admin to the Analysis Service?

2018-07-09T14:26:24.1776209Z ##[section]Starting: Deploy model to Analysis Service
2018-07-09T14:26:24.1780760Z ==============================================================================
2018-07-09T14:26:24.1781090Z Task : Azure Analysis Service Deployment
2018-07-09T14:26:24.1781289Z Description : Deploy Azure Analysis Service databases
2018-07-09T14:26:24.1781463Z Version : 1.1.2
2018-07-09T14:26:24.1781647Z Author : Jan Pieter Posthuma
2018-07-09T14:26:24.1782039Z Help : More Information
2018-07-09T14:26:24.1782286Z ==============================================================================
2018-07-09T14:26:29.9159390Z ##[command]Import-Module -Name C:\Program Files\WindowsPowerShell\Modules\AzureRM\2.1.0\AzureRM.psd1 -Global
2018-07-09T14:26:48.5300332Z ##[warning]The names of some imported commands from the module 'AzureRM.Websites' include unapproved verbs that might make them less discoverable. To find the commands with unapproved verbs, run the Import-Module command again with the Verbose parameter. For a list of approved verbs, type Get-Verb.
2018-07-09T14:26:48.5367245Z ##[warning]The names of some imported commands from the module 'AzureRM' include unapproved verbs that might make them less discoverable. To find the commands with unapproved verbs, run the Import-Module command again with the Verbose parameter. For a list of approved verbs, type Get-Verb.
2018-07-09T14:26:48.5941694Z ##[command]Import-Module -Name C:\Program Files\WindowsPowerShell\Modules\AzureRM.profile\2.1.0\AzureRM.profile.psd1 -Global
2018-07-09T14:26:48.6744640Z ##[command]Add-AzureRMAccount -ServicePrincipal -Tenant *** -Credential System.Management.Automation.PSCredential -EnvironmentName AzureCloud
2018-07-09T14:26:49.7200515Z ##[command]Select-AzureRMSubscription -SubscriptionId *** -TenantId ***
2018-07-09T14:26:52.0114503Z ##[error]Error during deploying the model (Exception has been thrown by the target of an invocation.)
2018-07-09T14:26:52.0575058Z ##[section]Finishing: Deploy model to Analysis Service

We build the AAS using ARM templates and then use the Azure Analysis Service Deployment task to deploy the model to the AAS.
Any input is highly appreciated.

Error message:

Error during adding firewall rule (Firewall rule names should be unique. Duplicate name vsts-release-aas-rule is not allowed.)
Firewall rule names should be unique. Duplicate name vsts-release-aas-rule is not allowed.

I get the following error when I'm trying to publish an azure analysis services model:

Error during adding automatic firewall rule (Unable to obtain authentication token using the credentials provided. If your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please remove the user name and password from the connection string, and then retry. You should then be prompted to enter your credentials.)

Any ideas what's wrong?

I've looked through both the opened and the closed issues, but no issue seem to have my problem

I'm using the Login Type=Named User

Things I've tested:

• I've verified that the account used can connect to the model and is admin on the azure analysis service.
• the account doesn't require MFA (Tested by connecting from SSMS)
• I've tested both turning the firewall on and off
• I've added the system.debug = true variable in the pipeline
• Regular publish from VS works fine

When using the task there are instances where the firewall was created on the analysis services. On failure the firewall does not get removed from analysis.

This scenario causes an issue where when rerunning the task it tries to put in the firewall again and it fails when it checks and finds out the firewall name already exist.

I am happy to open a PR for this issue and fix this because I think checking if it exist already and updating if it does will work in this scenario, given the name has to be vsts-release-aas.

Also adding in error handling into the code might help revert the firewall when an exception occurs during processing for instance.

@liprec Is there a way to enable OAuth authetication in case of deployment of .bim files for Data Model deployment through the VSTS task?

Hi Team,
I am using AAS model:1400 and have only 1 data source: Azure data warehouse

So after running the task, all the roles are getting deleted and the connection string details of the data source(Azure data warehouse) are not getting updated as per the details provided in the task.
So am I missing out anything?
Isn't there any feature similar to Deployment wizard: To retain existing configurations?

Our release runs successfully and deploys the models but without their partitions. The partitions are in the solution when it is opened (and pushed) from visual studio but do not appear in the model once released. Is this a bug or a config issue on our end?

Hello,

we try to create a release pipeline for an AS Deployment.
for authentication we use a service principal. in this case we get the error:
Cannot bind argument to parameter 'RolloutEnvironment' because it is null.
i think you use an older azure powershell library?

any ideas?
Best regards
André

Thank you for a great plugin!

I have successfully been able to deploy my model to the AAS instance via the Deployment task with all AAS, auth, and sql connection information configured. In addition to the deployment, I've been able to verify within SSMS that the model and associated sql connection is there within my AAS instance.

The next task in the release pipe executes a Refresh TMSL script and this is where I am running into issues. The TMSL task has the requisite AAS, and auth configured as well as an inline TMSL script. Here is the basic script I'm trying to execute to refresh the data:

{
"refresh": {
"type": "full",
"objects": [
{
"database": "MY_MODEL"
}
]
}
}

I have also tried different permutations with override values but nothing seems to work. This is the error I'm getting:

The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'The given credential contains a property with a null value. Data source kind: SQL. Property name: EncryptConnection. . The exception was raised by the IDbConnection interface.

Any guidance you could provide would be incredible thank you!

Jan, is this already fixed? Can we deploy using SPN ?

At this moment depoying a model via a SPN is not yet supported. I am in the process of rewriting all my VSTS extensions to NodeJS to be platform independent (and the are running faster) and it will include the deployment with SPNs, but it will take a little bit longer.

So at this moment you need an user and that user needs to be service admin to be able to deploy a model to AAS. And with the new version this user can be changed to an SPN, because you need access to both the Azure resource and the service itself.

(Duplicate of #5)

Originally posted by @liprec in #11 (comment)

Hello,

I'm trying to change the data source from my model when deploying it, but I'm getting this error whenever I try.

Any help?

Hi,

my name is Marcel Bindseil, working for Microsoft Germany.
At our client we use AAS and want to automate deployment process.
So I stumpled over your great VSTS extension but I don´t get it run.

I have tried to deploy the attached asdatabase or bim file. Neither the as database nor the bim file worked for me.
I also attached the task configuration in VSTS release definition.
vststask1
vststask2

asdatabase.txt
bim.txt

Deployment Task just returning:
2017-11-09T19:15:02.9454304Z ##[command]Import-Module -Name C:\Program Files (x86)\Microsoft SDKs\Azure\PowerShell\ResourceManager\AzureResourceManager\AzureRM.Profile\AzureRM.Profile.psd1 -Global 2017-11-09T19:15:03.3624369Z ##[command]Add-AzureRMAccount -ServicePrincipal -Tenant ******** -Credential System.Management.Automation.PSCredential -EnvironmentName AzureCloud 2017-11-09T19:15:04.7292901Z ##[command]Select-AzureRMSubscription -SubscriptionId 4025db3d-bb6f-4de1-8485-36a843f29882 -TenantId ******** 2017-11-09T19:15:05.4500959Z ##[error]Error during deploying the model (The property 'database' cannot be found on this object. Verify that the property exists and can be set.) 2017-11-09T19:15:05.4700937Z ##[section]Finishing: Deploy model to asazure://westeurope.asazure.windows.net/sppdefaultasdev01

Another company I know is using the same asdatabase file structure and there it works
´{
"name": "Evobus Telemetry Data Model",
"compatibilityLevel": 1400,
"model": {
"name": "Evobus Data Model",
"culture": "en-US",
"dataSources": [
{
"type": "structured",
"name": "SQL/evobussqldev01 database windows net;telemetrydb",
"connectionDetails": {
"protocol": "tds",
"address": {
"server": "evobussqldev01.database.windows.net",
"database": "telemetrydb"
},
"authentication": null,
"query": null
},
…..
´
Can you help to investigate?

Thanks,
Marcel Bindseil
Microsoft Modern Apps Consultant

Hi Team,

We were facing some issues while deploying the model /API using azure app service.

Kindly help me on this.

Thanks,
Padma,
7829535553.

Hi,

there seems to be an issue in the new versions since 10th March 2018.
Unfortunately I can't revert to an old version in Azure DevOps, since it only has Version 1.* in the dropdown available.
I also tried to Upgrade the Global AzureRM.profile module to 5.8.3, but this also didn't help.

AzureRM Version: 6.13.1
AzureRM.profile: 5.8.3

2019-03-12T12:32:35.2613978Z ##[debug]Caught exception from task script.
2019-03-12T12:32:35.2656890Z ##[debug]Error record:
2019-03-12T12:32:35.3524863Z ##[debug]Import-Module : The following error occurred while loading the extended type data file: Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.Abstractions.IAzureContextContainer": The TypeConverter was ignored because it already occurs.
2019-03-12T12:32:35.3537706Z ##[debug]Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.Abstractions.IAzureContextContainer": The member SerializationDepth is already present.
2019-03-12T12:32:35.3550851Z ##[debug]Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.ProtectedFileTokenCache": The member PropertySerializationSet is already present.
2019-03-12T12:32:35.3564761Z ##[debug]Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.ProtectedFileTokenCache": The member SerializationMethod is already present.
2019-03-12T12:32:35.3578399Z ##[debug]Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.AuthenticationStoreTokenCache": The member PropertySerializationSet is already present.
2019-03-12T12:32:35.3592768Z ##[debug]Error in TypeData "Microsoft.Azure.Commands.Common.Authentication.AuthenticationStoreTokenCache": The member SerializationMethod is already present.
2019-03-12T12:32:35.3606355Z ##[debug]Error in TypeData "Microsoft.Azure.Commands.Profile.Models.PSAzureContext": The member SerializationDepth is already present.
2019-03-12T12:32:35.3619982Z ##[debug]Error in TypeData "Microsoft.Azure.Commands.Profile.Models.PSAzureProfile": The member SerializationDepth is already present.
2019-03-12T12:32:35.3645531Z ##[debug]At C:\VSTSAgent\_work\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.2.3\ps_modules\VstsAzureHelpers_\ImportFunctions.ps1:88 char:44
2019-03-12T12:32:35.3659672Z ##[debug]+ ... ileModule = Import-Module -Name $profileModule.Path -Global -PassThru ...
2019-03-12T12:32:35.3673194Z ##[debug]+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2019-03-12T12:32:35.3687578Z ##[debug]    + CategoryInfo          : InvalidOperation: (:) [Import-Module], RuntimeException
2019-03-12T12:32:35.3701371Z ##[debug]    + FullyQualifiedErrorId : FormatXmlUpdateException,Microsoft.PowerShell.Commands.ImportModuleCommand
2019-03-12T12:32:35.3714918Z ##[debug] 
2019-03-12T12:32:35.3736401Z ##[debug]Script stack trace:
2019-03-12T12:32:35.3773458Z ##[debug]at Import-FromModulePath, C:\VSTSAgent\_work\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.2.3\ps_modules\VstsAzureHelpers_\ImportFunctions.ps1: line 88
2019-03-12T12:32:35.3787273Z ##[debug]at Import-AzureModule, C:\VSTSAgent\_work\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.2.3\ps_modules\VstsAzureHelpers_\ImportFunctions.ps1: line 29
2019-03-12T12:32:35.3802705Z ##[debug]at Initialize-Azure, C:\VSTSAgent\_work\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.2.3\ps_modules\VstsAzureHelpers_\VstsAzureHelpers_.psm1: line 47
2019-03-12T12:32:35.3816109Z ##[debug]at <ScriptBlock>, C:\VSTSAgent\_work\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.2.3\deploy-aas-db.ps1: line 13
2019-03-12T12:32:35.3830754Z ##[debug]at <ScriptBlock>, <No file>: line 1
2019-03-12T12:32:35.3845065Z ##[debug]at <ScriptBlock>, <No file>: line 22
2019-03-12T12:32:35.3858264Z ##[debug]at <ScriptBlock>, <No file>: line 18
2019-03-12T12:32:35.3872367Z ##[debug]at <ScriptBlock>, <No file>: line 1

Hi I have today installed this plugin into our Azure DevOps. It says deployed but no tasks are available:

You can see in that screenshot it has installed. But I can't find any tasks???

Hi,

I have been running your excellent task for some time now, and I do notice that occasionally, an instance of the task fails because the firewall rule has not finished creating, so the agent cannot reach the server. My scenario is that I have several instances of the task in one job, all run sequentially, not in parallel, and it only happens perhaps 1 in every 20 times. Is there a way to possibly customize the timeout of the firewall rule creation, to be able to increase it if necessary, or does the code already perform a watch on the rule creation, and if so, maybe that needs a bit of a delay?

Sam

I am deploying a tabular model from one environment to another via VSTS, where I want to modify the data source connection in the <model_name>.asddatabase and the auth credentials (tokens). My data source is Azure Datalake.

When deploying from one environment to another manually and modifying the data source connection so that the model points to the new Datalake, we get a prompt to enter the credentials for that particular datalake data source. Once we authenticate,the credentials of the model for that analysis service gets refreshed as new tokens are generated on oauth.

Question: Is there any way to modify the data source connection of a bim file and authenticating it simultaneously when deploying to a new env

Hi @liprec ,

We are getting below error while deploying model to AAS using SPN.

Could you please help us to resolve this.
"
Error during deploying the model (Authentication failed: User ID and Password are required when user interface is not available.)
"

Please add functionality for having multiple SQL Server databases as data sources.

While running the Azure Analysis Service Deployment task Deploy Azure Analysis Service databases on the Microsoft Hosted Agent, we are getting this error in the Azure Pipeline. It looks like openssl is missing in the bundle:

Hosted Agent: (Region Central US)

Starting: Initialize job
Agent name: 'Hosted Agent'
Agent machine name: 'fv-az363'
Current agent version: '2.173.0'
Operating System
Virtual Environment
Current image version: '20200802.1'
Agent running as: 'VssAdministrator'
##[debug]Triggering repository: as-ddm-marketing. repository type: Git
Prepare build directory.
##[debug]Creating build directory: 'D:\a\1'
##[debug]Delete existing artifacts directory: 'D:\a\1\a'
##[debug]Creating artifacts directory: 'D:\a\1\a'
##[debug]Delete existing test results directory: 'D:\a\1\TestResults'
##[debug]Creating test results directory: 'D:\a\1\TestResults'
##[debug]Creating binaries directory: 'D:\a\1\b'
##[debug]Creating source directory: 'D:\a\1\s'
Set build variables.
Download all required tasks.
Downloading task: deploy-aas-db (1.3.3)
##[debug]Task 'deploy-aas-db' has been downloaded into 'D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3'.
Checking job knob settings.
Knob: AgentToolsDirectory = C:/hostedtoolcache/windows Source: ${AGENT_TOOLSDIRECTORY}
Knob: AgentPerflog = c:\vsts\perflog Source: ${VSTS_AGENT_PERFLOG}
Finished checking job knob settings.
##[debug]Log plugin 'TestResultLogPlugin' is disabled.
##[debug]Log plugin 'TestFilePublisherPlugin' is disabled.
Start tracking orphan processes.
Finishing: Initialize job

2020-08-06T17:56:44.1564081Z ##[debug]Evaluating condition for step: 'Deploy model to asazure://aspaaseastus2.asazure.windows.net/asddmegrrptdev' 2020-08-06T17:56:44.1566156Z ##[debug]Evaluating: SucceededNode() 2020-08-06T17:56:44.1566742Z ##[debug]Evaluating SucceededNode: 2020-08-06T17:56:44.1567827Z ##[debug]=> True 2020-08-06T17:56:44.1568451Z ##[debug]Result: True 2020-08-06T17:56:44.1569154Z ##[section]Starting: Deploy model to asazure://aspaaseastus2.asazure.windows.net/asddmegrrptdev 2020-08-06T17:56:44.1677571Z ============================================================================== 2020-08-06T17:56:44.1677976Z Task : Azure Analysis Service Deployment 2020-08-06T17:56:44.1678296Z Description : Deploy Azure Analysis Service databases 2020-08-06T17:56:44.1678573Z Version : 1.3.3 2020-08-06T17:56:44.1678815Z Author : Jan Pieter Posthuma 2020-08-06T17:56:44.1679178Z Help : [More Information](https://github.com/liprec/vsts-deploy-aas) 2020-08-06T17:56:44.1679572Z ============================================================================== . . . . . 2020-08-06T17:57:21.9684434Z ##[debug]Leaving Set-UserAgent_Core. 2020-08-06T17:57:21.9709491Z ##[command]Clear-AzureRmContext -Scope Process 2020-08-06T17:57:22.9664781Z ##[command]Disable-AzureRmContextAutosave -ErrorAction Stop 2020-08-06T17:57:23.7112975Z ##[debug]Entering Invoke-VstsTool. 2020-08-06T17:57:23.7130383Z ##[debug] FileName: 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\openssl\openssl.exe' 2020-08-06T17:57:23.7146811Z ##[debug] Arguments: 'pkcs12 -export -in D:\a\_temp\clientcertificate.pem -out D:\a\_temp\clientcertificate.pfx -password file:"D:\a\_temp\clientcertificatepassword.txt"' 2020-08-06T17:57:23.7162192Z ##[debug] RequireExitCodeZero: 'True' 2020-08-06T17:57:23.7187261Z ##[command]"D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\openssl\openssl.exe" pkcs12 -export -in D:\a\_temp\clientcertificate.pem -out D:\a\_temp\clientcertificate.pfx -password file:"D:\a\_temp\clientcertificatepassword.txt" 2020-08-06T17:57:23.8623068Z ##[debug]Leaving Invoke-VstsTool. 2020-08-06T17:57:23.8687580Z ##[debug]Leaving Initialize-Azure. 2020-08-06T17:57:23.8742741Z ##[debug]Caught exception from task script. 2020-08-06T17:57:23.8771671Z ##[debug]Error record: 2020-08-06T17:57:23.9483920Z ##[debug]Invoke-Expression : The term 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\openssl\openssl.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. 2020-08-06T17:57:23.9494688Z ##[debug]At D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsTaskSdk\ToolFunctions.ps1:107 char:9 2020-08-06T17:57:23.9506522Z ##[debug]+ Invoke-Expression "& '$FileName' --% $Arguments" 2020-08-06T17:57:23.9517562Z ##[debug]+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 2020-08-06T17:57:23.9528681Z ##[debug] + CategoryInfo : ObjectNotFound: (D:\a\_tasks\dep...ssl\openssl.exe:String) [Invoke-Expression], CommandN otFoundException 2020-08-06T17:57:23.9539411Z ##[debug] + FullyQualifiedErrorId : CommandNotFoundException,Microsoft.PowerShell.Commands.InvokeExpressionCommand 2020-08-06T17:57:23.9550413Z ##[debug] 2020-08-06T17:57:23.9567973Z ##[debug]Script stack trace: 2020-08-06T17:57:23.9601399Z ##[debug]at <ScriptBlock>, <No file>: line 1 2020-08-06T17:57:23.9613574Z ##[debug]at Invoke-Tool, D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsTaskSdk\ToolFunctions.ps1: line 107 2020-08-06T17:57:23.9624302Z ##[debug]at ConvertTo-Pfx, D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\Utility.ps1: line 230 2020-08-06T17:57:23.9635375Z ##[debug]at Add-Certificate, D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\Utility.ps1: line 13 2020-08-06T17:57:23.9646711Z ##[debug]at Initialize-AzureSubscription, D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\InitializeFunctions.ps1: line 160 2020-08-06T17:57:23.9657185Z ##[debug]at Initialize-Azure, D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\VstsAzureHelpers_.psm1: line 58 2020-08-06T17:57:23.9669069Z ##[debug]at <ScriptBlock>, D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\deploy-aas-db.ps1: line 40 2020-08-06T17:57:23.9679667Z ##[debug]at <ScriptBlock>, <No file>: line 1 2020-08-06T17:57:23.9691075Z ##[debug]at <ScriptBlock>, <No file>: line 22 2020-08-06T17:57:23.9701882Z ##[debug]at <ScriptBlock>, <No file>: line 18 2020-08-06T17:57:23.9714181Z ##[debug]at <ScriptBlock>, <No file>: line 1 2020-08-06T17:57:23.9730954Z ##[debug]Exception: 2020-08-06T17:57:23.9777697Z ##[debug]System.Management.Automation.CommandNotFoundException: The term 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\openssl\openssl.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. 2020-08-06T17:57:23.9788505Z ##[debug] at System.Management.Automation.ExceptionHandlingOps.CheckActionPreference(FunctionContext funcContext, Exception exception) 2020-08-06T17:57:23.9799338Z ##[debug] at System.Management.Automation.Interpreter.ActionCallInstruction 2.Run(InterpretedFrame frame) 2020-08-06T17:57:23.9810541Z ##[debug] at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) 2020-08-06T17:57:23.9821265Z ##[debug] at System.Management.Automation.Interpreter.EnterTryCatchFinallyInstruction.Run(InterpretedFrame frame) 2020-08-06T17:57:23.9832754Z ##[debug] at System.Management.Automation.Interpreter.Interpreter.Run(InterpretedFrame frame) 2020-08-06T17:57:23.9843482Z ##[debug] at System.Management.Automation.Interpreter.LightLambda.RunVoid1[T0](T0 arg0) 2020-08-06T17:57:23.9854632Z ##[debug] at System.Management.Automation.ScriptBlock.InvokeWithPipeImpl(ScriptBlockClauseToInvoke clauseToInvoke, Boolean createLocalScope, Dictionary2 functionsToDefine, List1 variablesToDefine, ErrorHandlingBehavior errorHandlingBehavior, Object dollarUnder, Object input, Object scriptThis, Pipe outputPipe, InvocationInfo invocationInfo, Object[] args) 2020-08-06T17:57:23.9865467Z ##[debug] at System.Management.Automation.ScriptBlock.<>c__DisplayClass57_0.<InvokeWithPipe>b__0() 2020-08-06T17:57:23.9876304Z ##[debug] at System.Management.Automation.Runspaces.RunspaceBase.RunActionIfNoRunningPipelinesWithThreadCheck(Action action) 2020-08-06T17:57:23.9887338Z ##[debug] at System.Management.Automation.ScriptBlock.InvokeWithPipe(Boolean useLocalScope, ErrorHandlingBehavior errorHandlingBehavior, Object dollarUnder, Object input, Object scriptThis, Pipe outputPipe, InvocationInfo invocationInfo, Boolean propagateAllExceptionsToTop, List1 variablesToDefine, Dictionary2 functionsToDefine, Object[] args) 2020-08-06T17:57:23.9897971Z ##[debug] at System.Management.Automation.ScriptBlock.InvokeUsingCmdlet(Cmdlet contextCmdlet, Boolean useLocalScope, ErrorHandlingBehavior errorHandlingBehavior, Object dollarUnder, Object input, Object scriptThis, Object[] args) 2020-08-06T17:57:23.9908856Z ##[debug] at Microsoft.PowerShell.Commands.InvokeExpressionCommand.ProcessRecord() 2020-08-06T17:57:23.9919578Z ##[debug] at System.Management.Automation.CommandProcessor.ProcessRecord() 2020-08-06T17:57:23.9977061Z ##[error]The term 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\openssl\openssl.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. 2020-08-06T17:57:23.9979623Z ##[debug]Processed: ##vso[task.logissue type=error]The term 'D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.3.3\ps_modules\VstsAzureHelpers_\openssl\openssl.exe' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. 2020-08-06T17:57:23.9992573Z ##[debug]Processed: ##vso[task.complete result=Failed] 2020-08-06T17:57:24.0740253Z ##[section]Finishing: Deploy model to asazure://aspaaseastus2.asazure.windows.net/asddmegrrptdev

The credentials we have in source control is OAuth2. When deploying this model this code "carries on" the encrypt connection flag and authentication kind from the source code.

$credential.credential.EncryptConnection = $dataSource.credential.EncryptConnection
$credential.credential.AuthenticationKind = $dataSource.credential.AuthenticationKind

But we need it to be changed to:

"AuthenticationKind": "UsernamePassword"
"EncryptConnection": true

Without this processing of the AAS model fails with the message

"message": "An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_MashupDataAccessError\r\nReceived error payload from gateway service with ID ***: MashupException encountered while accessing the target data source..\r\nMashupException encountered while accessing the target data source.\r\nThe given credential contains a property with a null value. Data source kind: SQL. Property name: EncryptConnection. \r\n.",

Hi ,
Thanks for your great work but i have a question or maybe an issue on the extension . My AAS model has three different servers connected to it . but the extension only allows be to input 1 so it always fails . Can you please help me how do i declare multiple source Databases

Thankyou

I've got this error, i also changed the whole name without any characters but still failed. if there are cool guys could help me?

The 'Name' property cannot contain any of the following characters: . , ; ' ` : / \ * | ? " & % $ ! + = ( ) [ ] { } < >. Technical Details: RootActivityId: ebfea9b0-e752-4ce5-ab52-adc2093fa50f Date (UTC): 5/11/2020 8:18:28 AM (ErrorCode: -1055784777)

Do you know if this should work deploying to Azure Analysis Services in Gov Cloud? When we try to do so, we get the error: Unknown Analysis Services environment name specified.

We have confirmed the pathing, names, and service account permissions are correct.

Thanks!

Hi,

I am using this task from past 2-3 months and I found that sometimes even if pipeline is successfully completed, models are not deployed in Azure Analysis Service and same pipeline works perfectly fine after sometime. Don't know the reason behind this. I am using deployment using .bim task and not using TMSL script.

Please suggest ASAP.

Hello,

First of all, thank you very much for this great functionality!
I do have a question that would help our deployments greatly:
Is it possible to support the "Retain Roles & Members" functionality present in the deployment wizard?
These deployment options are part of a separate file during deployment (model.deploymentoptions).
Currently all roles and members are overwritten during deployment to the target server and have to be reset afterwards.

Regards,

Nick de Korte

I've been trying to deploy some models using this extension, however I keep getting the error as seen below. I can't determine what exactly is going wrong by looking at the error. I have verified the SQL server, database and SSAS are deployed.

2017-09-01T14:47:21.9690899Z ##[debug]Caught exception from task script. 2017-09-01T14:47:21.9720917Z ##[debug]Error record: 2017-09-01T14:47:22.0580898Z ##[debug]Error during deploying the model (Exception has been thrown by the target of an invocation..exception.message) 2017-09-01T14:47:22.0600908Z ##[debug]At D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.0.1\deploy-aas-db.psm1:250 char:9 2017-09-01T14:47:22.0611595Z ##[debug]+ throw "Error during deploying the model ($_.exception.message ... 2017-09-01T14:47:22.0621872Z ##[debug]+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 2017-09-01T14:47:22.0631769Z ##[debug] + CategoryInfo : OperationStopped: (Error during de...eption.message):String) [], RuntimeException 2017-09-01T14:47:22.0649660Z ##[debug] + FullyQualifiedErrorId : Error during deploying the model (Exception has been thrown by the target of an invocati on..exception.message) 2017-09-01T14:47:22.0670216Z ##[debug] 2017-09-01T14:47:22.0689752Z ##[debug]Script stack trace: 2017-09-01T14:47:22.0739749Z ##[debug]at DeployModel, D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.0.1\deploy-aas-db.psm1: line 250 2017-09-01T14:47:22.0759758Z ##[debug]at <ScriptBlock>, D:\a\_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.0.1\deploy-aas-db.ps1: line 72 2017-09-01T14:47:22.0783439Z ##[debug]at <ScriptBlock>, <No file>: line 1 2017-09-01T14:47:22.0799763Z ##[debug]at <ScriptBlock>, <No file>: line 22 2017-09-01T14:47:22.0817466Z ##[debug]at <ScriptBlock>, <No file>: line 18 2017-09-01T14:47:22.0827755Z ##[debug]at <ScriptBlock>, <No file>: line 1 2017-09-01T14:47:22.0847772Z ##[debug]Exception: 2017-09-01T14:47:22.0897784Z ##[debug]System.Management.Automation.RuntimeException: Error during deploying the model (Exception has been thrown by the target of an invocation..exception.message) 2017-09-01T14:47:22.1077517Z ##[error]Error during deploying the model (Exception has been thrown by the target of an invocation..exception.message) 2017-09-01T14:47:22.1077517Z ##[debug]Processed: ##vso[task.logissue type=error]Error during deploying the model (Exception has been thrown by the target of an invocation..exception.message) 2017-09-01T14:47:22.1127511Z ##[debug]Processed: ##vso[task.complete result=Failed]

My connection string isn't being changed during the deployment, despite the variables being set, and me using an Azure SQL Database.

Here's the relevant part of the .bim file:

"model": {
    "culture": "en-US",
    "dataSources": [
      {
        "name": "SqlAzure redacted.database.windows.net DW",
        "connectionString": "Data Source=redacted.database.windows.net;Initial Catalog=DW;Persist Security Info=true;User ID=devpowerbi_read;Encrypt=True;TrustServerCertificate=False;Authentication=Sql Password",
        "impersonationMode": "impersonateServiceAccount",
        "provider": "System.Data.SqlClient",
        "annotations": [
          {
            "name": "ConnectionEditUISource",
            "value": "SqlAzure"
          }
        ]
      }
    ],

However, the ApplySQLSecurity Powershell function appears to be looking for a .type element in the json which isn't there. Is there something I need to do to get Visual Studio to add this element - or can the powershell be fixed to remove this criteria?

Here's the line in question: