Connection string not being changed during deployment about vsts-release-aas HOT 8 CLOSED

The extension can only handle 1400 model definitions which contains newly defined datasource definitions.
See https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-compat-level for some more details.
If it is no problem to change the compatibility level of your model, it will release properly. Or else I have to add the options to handle 1200 models.

from vsts-release-aas.

Hi @liprec ,

We still need to update the data source and credentials manually. Compatibility set to 1400 and source database is Azure SQL Datawarehouse. Any idea?

from vsts-release-aas.

@Jordi-f, can you validate that in the .BIM has the 'type' attribute as part of the dataSources node? This is needed and is used to replace the server/username/password during deployment.

"dataSources": [
      {
        "type": "structured",...

from vsts-release-aas.

@liprec the "type" is not present in the .bim file, that will cause the deployment to leave the connectionstring then. Adding it to the json file did not work. This is probably due to the fact that we are still using visual studio 2015 ? In visual studio 2017 I just checked with a newer tabular model and the type tag is present there. Time to upgrade...

from vsts-release-aas.

@liprec We are experiencing the same issue. The connection string does not get updated during deployment. This makes the extension being not useful if we have several environments as the data source always remains the same. We also tried specifying type: "structured" and removed 'connectionstring' and 'impersonationmode' in the .bim file, but we get the following error.

Also the function 'ApplySqlSecurity' in deploy-aas-db.psm1 file(line 121) checks for the if condition based on type, but type is a string value and not a boolean as per your suggestion, How will the if evaluate to a boolean. Can you please help us on this issue.

from vsts-release-aas.

@liprec We are also facing this issue. When downloading the model from azure portal the initial connection string is configured.

from vsts-release-aas.

The extension is original created with AAS and the new 1400 compability mode in mind and those models are using the new 'modern data sources', eg 'Power Query': https://azure.microsoft.com/en-us/blog/using-modern-data-sources-in-azure-analysis-services/ or https://azure.microsoft.com/en-us/blog/1400-models-in-azure-as/
And the extension only checks if the new data sources definition is available, but doesn't warn if it is not.
I want to rewrite the extension, but I am still waiting for Power BI team to open the API/XMLA endpoints so I can also incorporate that scenario with the same extension.

Till then it is possible to manually change the JSON definition to be using the new definition or as @hoffe86 is confirming: downloading the model from the Azure Portal / AAS.

from vsts-release-aas.

Will close the issue for now. If this is still an issue, please reopen the issue and provide the requested information.

from vsts-release-aas.