Deployment Issues with Analysis Services Model with Partition

[DamolAAkinleye]

We are currently experiencing an issue with the deployment pipeline following an upgrade to the release of the analysis. When we expose new columns in the models and deploy them into AAS. The changes are not showing through even though it worked in the past.

However, when we open the bim file in visual studio and create an explicit partition and process locally then deploy from the Visual studio interface that works. Using the new file saved in visual studio and deploying using the extension it does not work

[liprec]

Can you share the pipeline log with debug (System.Debug) set to true?

[DamolAAkinleye]

Hi Liprec, thanks for taking a look into this. I have below the debug logs that are showing up when I trigger deployment of the bim file.

2022-01-21T19:23:11.0396648Z ##[debug]Evaluating condition for step: 'Deploy AAS Model' 2022-01-21T19:23:11.0398696Z ##[debug]Evaluating: succeeded() 2022-01-21T19:23:11.0399252Z ##[debug]Evaluating succeeded: 2022-01-21T19:23:11.0400660Z ##[debug]=> True 2022-01-21T19:23:11.0401259Z ##[debug]Result: True 2022-01-21T19:23:11.0401928Z ##[section]Starting: Deploy AAS Model 2022-01-21T19:23:11.0557796Z ============================================================================== 2022-01-21T19:23:11.0558185Z Task : Tabular Database Deployment 2022-01-21T19:23:11.0558623Z Description : Deploy tabular databases to Azure Analysis Services or Power BI Premium 2022-01-21T19:23:11.0558950Z Version : 1.5.8 2022-01-21T19:23:11.0559210Z Author : Jan Pieter Posthuma 2022-01-21T19:23:11.0560146Z Help : More Information 2022-01-21T19:23:11.0560561Z ============================================================================== 2022-01-21T19:23:12.1032756Z ##[debug]VstsTaskSdk 0.11.0 commit 7ff27a3e0bdd6f7b06690ae5f5b63cb84d0f23f4 2022-01-21T19:23:12.7857164Z ##[debug]Entering D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\deploy-aas-db.ps1. 2022-01-21T19:23:12.8193141Z ##[debug]INPUT_CONNECTEDSERVICENAMESELECTOR: 'ConnectedServiceNameARM' 2022-01-21T19:23:12.8288489Z ##[debug]INPUT_CONNECTEDSERVICENAMEARM: '4958ef81-8daf-47fd-b9ed-2f0fa9b9f811' 2022-01-21T19:23:12.8374832Z ##[debug]ENDPOINT_URL_4958ef81-8daf-47fd-b9ed-2f0fa9b9f811: 'https://management.azure.com/' 2022-01-21T19:23:12.8402295Z ##[debug]ENDPOINT_AUTH_4958ef81-8daf-47fd-b9ed-2f0fa9b9f811: '****' 2022-01-21T19:23:12.8436715Z ##[debug]ENDPOINT_DATA_4958ef81-8daf-47fd-b9ed-2f0fa9b9f811: '{"environment":"AzureCloud","scopeLevel":"Subscription","subscriptionId":"f11177889-7a8d-4921-912a-7efc55b76131","subscriptionName":"Non-production (EA)","creationMode":"Manual","environmentUrl":"https://management.azure.com/","galleryUrl":"https://gallery.azure.com/","serviceManagementUrl":"https://management.core.windows.net/","resourceManagerUrl":"https://management.azure.com/","activeDirectoryAuthority":"https://login.microsoftonline.com/","environmentAuthorityUrl":"https://login.windows.net/","graphUrl":"https://graph.windows.net/","managementPortalUrl":"https://manage.windowsazure.com/","armManagementPortalUrl":"https://portal.azure.com/","activeDirectoryServiceEndpointResourceId":"https://management.core.windows.net/","sqlDatabaseDnsSuffix":".database.windows.net","AzureKeyVaultDnsSuffix":"vault.azure.net","AzureKeyVaultServiceEndpointResourceId":"https://vault.azure.net","StorageEndpointSuffix":"core.windows.net","EnableAdfsAuthentication":"false"}' 2022-01-21T19:23:12.8469310Z ##[debug]INPUT_AASSERVER: 'asazure://uksouth.asazure.windows.net/edpbase:rw' 2022-01-21T19:23:12.8533384Z ##[debug]INPUT_DATABASENAME: 'Planning' 2022-01-21T19:23:12.8536965Z ##[debug]INPUT_MODELNAME: 'Planning' 2022-01-21T19:23:12.8550565Z ##[debug]INPUT_LOGINTYPE: 'user' 2022-01-21T19:23:12.8572376Z ##[debug]INPUT_PATHTOMODEL: 'D:\a\r1\a\EDP_AAS_CI\drop\EDP_DataIntegration\EDP_AAS_DataIntegration\Model.bim' 2022-01-21T19:23:12.8598193Z ##[debug]INPUT_CONNECTIONTYPE: 'sql' 2022-01-21T19:23:12.8628739Z ##[debug]Retrieving 'sql' credentials 2022-01-21T19:23:12.8654929Z ##[debug]INPUT_SOURCESQLSERVER: 'edp-uat-azsql-01.database.windows.net' 2022-01-21T19:23:12.8680828Z ##[debug]INPUT_SOURCESQLDATABASE: 'DataIntegration' 2022-01-21T19:23:12.8704586Z ##[debug]INPUT_SOURCESQLUSERNAME: 'uataad' 2022-01-21T19:23:12.8733907Z ##[debug]INPUT_SOURCESQLPASSWORD: '*' 2022-01-21T19:23:12.8780376Z ##[debug]INPUT_OVERWRITE: 'true' 2022-01-21T19:23:12.8809804Z ##[debug] Converted to bool: True 2022-01-21T19:23:12.8834532Z ##[debug]INPUT_REMOVE: 'false' 2022-01-21T19:23:12.8854256Z ##[debug] Converted to bool: False 2022-01-21T19:23:12.8879922Z ##[debug]INPUT_PARTITIONDEPLOYMENT: 'deploypartitions' 2022-01-21T19:23:12.8904936Z ##[debug]INPUT_ROLEDEPLOYMENT: 'deployrolesandmembers' 2022-01-21T19:23:12.8931017Z ##[debug]INPUT_IPDETECTIONMETHOD: 'autoDetect' 2022-01-21T19:23:12.8957850Z ##[debug]INPUT_DELETEFIREWALLRULE: 'true' 2022-01-21T19:23:12.8977563Z ##[debug] Converted to bool: True 2022-01-21T19:23:12.9034962Z ##[debug]Loading module from path 'D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\psmodules\VstsAzureRestHelpers\VstsAzureRestHelpers_.psm1'. 2022-01-21T19:23:12.9836524Z ##[debug]$OVERRIDING $global:DebugPreference from 'Continue' to 'SilentlyContinue'. 2022-01-21T19:23:12.9864428Z ##[debug]Loading resource strings from: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\psmodules\VstsAzureRestHelpers/module.json 2022-01-21T19:23:13.0119639Z ##[debug]Loaded 11 strings. 2022-01-21T19:23:13.0161186Z ##[debug]SYSTEM_CULTURE: 'en-US' 2022-01-21T19:23:13.0465918Z ##[debug]Loading resource strings from: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\psmodules\VstsAzureRestHelpers\Strings\resources.resjson\en-US\resources.resjson 2022-01-21T19:23:13.0492433Z ##[debug]Loaded 11 strings. 2022-01-21T19:23:13.1537101Z ##[debug]Loading module from path 'D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\psmodules\TlsHelper\TlsHelper_.psm1'. 2022-01-21T19:23:13.1603152Z ##[debug]Loading resource strings from: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\psmodules\TlsHelper/module.json 2022-01-21T19:23:13.1693262Z ##[debug]Loaded 3 strings. 2022-01-21T19:23:13.1720547Z ##[debug]SYSTEM_CULTURE: 'en-US' 2022-01-21T19:23:13.1741144Z ##[debug]Loading resource strings from: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\psmodules\TlsHelper\Strings\resources.resjson\en-US\resources.resjson 2022-01-21T19:23:13.1840235Z ##[debug]Loaded 3 strings. 2022-01-21T19:23:13.1851058Z ##[debug]Exporting function 'Add-Tls12InSession'. 2022-01-21T19:23:13.1906097Z ##[debug]Exporting function 'Assert-TlsError'. 2022-01-21T19:23:13.1925016Z ##[debug]Importing function 'Add-Tls12InSession'. 2022-01-21T19:23:13.1940964Z ##[debug]Importing function 'Assert-TlsError'. 2022-01-21T19:23:13.3517772Z ##[debug]TLS 1.2 already present in session. 2022-01-21T19:23:13.3538532Z ##[debug]Exporting function 'Add-AzureSqlDatabaseServerFirewallRule'. 2022-01-21T19:23:13.3556504Z ##[debug]Exporting function 'Remove-AzureSqlDatabaseServerFirewallRule'. 2022-01-21T19:23:13.3574299Z ##[debug]Exporting function 'Get-AzStorageKeys'. 2022-01-21T19:23:13.3591936Z ##[debug]Exporting function 'Get-AzRMStorageKeys'. 2022-01-21T19:23:13.3609754Z ##[debug]Exporting function 'Get-AzRmVmCustomScriptExtension'. 2022-01-21T19:23:13.3628926Z ##[debug]Exporting function 'Remove-AzRmVmCustomScriptExtension'. 2022-01-21T19:23:13.3659132Z ##[debug]Exporting function 'Get-AzStorageAccount'. 2022-01-21T19:23:13.3667403Z ##[debug]Exporting function 'Get-AzRmStorageAccount'. 2022-01-21T19:23:13.3680591Z ##[debug]Exporting function 'Get-AzRmResourceGroup'. 2022-01-21T19:23:13.3699031Z ##[debug]Exporting function 'Get-AzureNetworkInterfaceDetails'. 2022-01-21T19:23:13.3717112Z ##[debug]Exporting function 'Get-AzurePublicIpAddressDetails'. 2022-01-21T19:23:13.3735027Z ##[debug]Exporting function 'Get-AzureLoadBalancersDetails'. 2022-01-21T19:23:13.3752418Z ##[debug]Exporting function 'Get-AzureLoadBalancerDetails'. 2022-01-21T19:23:13.3768933Z ##[debug]Exporting function 'Get-AzureRMLoadBalancerFrontendIpConfigDetails'. 2022-01-21T19:23:13.3787131Z ##[debug]Exporting function 'Get-AzureRMLoadBalancerInboundNatRuleConfigDetails'. 2022-01-21T19:23:13.3805922Z ##[debug]Exporting function 'Get-AzureRMAccessToken'. 2022-01-21T19:23:13.3822016Z ##[debug]Exporting function 'Get-ExceptionMessage'. 2022-01-21T19:23:13.3840605Z ##[debug]Exporting function 'Get-ConnectionType'. 2022-01-21T19:23:13.3858103Z ##[debug]Exporting function 'IsAzureRmConnection'. 2022-01-21T19:23:13.3876971Z ##[debug]Importing function 'Add-AzureSqlDatabaseServerFirewallRule'. 2022-01-21T19:23:13.3892547Z ##[debug]Importing function 'Get-AzRmResourceGroup'. 2022-01-21T19:23:13.3909638Z ##[debug]Importing function 'Get-AzRmStorageAccount'. 2022-01-21T19:23:13.3925569Z ##[debug]Importing function 'Get-AzRMStorageKeys'. 2022-01-21T19:23:13.3942277Z ##[debug]Importing function 'Get-AzRmVmCustomScriptExtension'. 2022-01-21T19:23:13.3958196Z ##[debug]Importing function 'Get-AzStorageAccount'. 2022-01-21T19:23:13.3973935Z ##[debug]Importing function 'Get-AzStorageKeys'. 2022-01-21T19:23:13.3989568Z ##[debug]Importing function 'Get-AzureLoadBalancerDetails'. 2022-01-21T19:23:13.4006406Z ##[debug]Importing function 'Get-AzureLoadBalancersDetails'. 2022-01-21T19:23:13.4022411Z ##[debug]Importing function 'Get-AzureNetworkInterfaceDetails'. 2022-01-21T19:23:13.4039177Z ##[debug]Importing function 'Get-AzurePublicIpAddressDetails'. 2022-01-21T19:23:13.4057721Z ##[debug]Importing function 'Get-AzureRMAccessToken'. 2022-01-21T19:23:13.4076360Z ##[debug]Importing function 'Get-AzureRMLoadBalancerFrontendIpConfigDetails'. 2022-01-21T19:23:13.4088867Z ##[debug]Importing function 'Get-AzureRMLoadBalancerInboundNatRuleConfigDetails'. 2022-01-21T19:23:13.4105122Z ##[debug]Importing function 'Get-ConnectionType'. 2022-01-21T19:23:13.4132172Z ##[debug]Importing function 'Get-ExceptionMessage'. 2022-01-21T19:23:13.4148260Z ##[debug]Importing function 'IsAzureRmConnection'. 2022-01-21T19:23:13.4151321Z ##[debug]Importing function 'Remove-AzRmVmCustomScriptExtension'. 2022-01-21T19:23:13.4166411Z ##[debug]Importing function 'Remove-AzureSqlDatabaseServerFirewallRule'. 2022-01-21T19:23:13.4192452Z ##[debug]Loading module from path 'D:\a_tasks\deploy-aas-dba55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\VstsAzureRestHelperExtra.psm1'. 2022-01-21T19:23:13.4263183Z ##[debug]Loading resource strings from: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8/psmodules/VstsAzureRestHelpers/module.json 2022-01-21T19:23:13.4304759Z ##[debug]Loaded 11 strings. 2022-01-21T19:23:13.4331789Z ##[debug]SYSTEM_CULTURE: 'en-US' 2022-01-21T19:23:13.4354301Z ##[debug]Loading resource strings from: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\psmodules\VstsAzureRestHelpers\Strings\resources.resjson\en-US\resources.resjson 2022-01-21T19:23:13.4390922Z ##[debug]Loaded 11 strings. 2022-01-21T19:23:13.4412921Z ##[debug]Importing function 'Add-Tls12InSession'. 2022-01-21T19:23:13.4428320Z ##[debug]Importing function 'Assert-TlsError'. 2022-01-21T19:23:13.4448051Z ##[debug]TLS 1.2 already present in session. 2022-01-21T19:23:13.4469188Z ##[debug]Importing function 'Add-AzureSqlDatabaseServerFirewallRule'. 2022-01-21T19:23:13.4485806Z ##[debug]Importing function 'Get-AzRmResourceGroup'. 2022-01-21T19:23:13.4518499Z ##[debug]Importing function 'Get-AzRmStorageAccount'. 2022-01-21T19:23:13.4534463Z ##[debug]Importing function 'Get-AzRMStorageKeys'. 2022-01-21T19:23:13.4551441Z ##[debug]Importing function 'Get-AzRmVmCustomScriptExtension'. 2022-01-21T19:23:13.4567674Z ##[debug]Importing function 'Get-AzStorageAccount'. 2022-01-21T19:23:13.4583886Z ##[debug]Importing function 'Get-AzStorageKeys'. 2022-01-21T19:23:13.4599767Z ##[debug]Importing function 'Get-AzureLoadBalancerDetails'. 2022-01-21T19:23:13.4616956Z ##[debug]Importing function 'Get-AzureLoadBalancersDetails'. 2022-01-21T19:23:13.4632780Z ##[debug]Importing function 'Get-AzureNetworkInterfaceDetails'. 2022-01-21T19:23:13.4649009Z ##[debug]Importing function 'Get-AzurePublicIpAddressDetails'. 2022-01-21T19:23:13.4664247Z ##[debug]Importing function 'Get-AzureRMAccessToken'. 2022-01-21T19:23:13.4681015Z ##[debug]Importing function 'Get-AzureRMLoadBalancerFrontendIpConfigDetails'. 2022-01-21T19:23:13.4697122Z ##[debug]Importing function 'Get-AzureRMLoadBalancerInboundNatRuleConfigDetails'. 2022-01-21T19:23:13.4712675Z ##[debug]Importing function 'Get-ConnectionType'. 2022-01-21T19:23:13.4727255Z ##[debug]Importing function 'Get-ExceptionMessage'. 2022-01-21T19:23:13.4744082Z ##[debug]Importing function 'IsAzureRmConnection'. 2022-01-21T19:23:13.4759676Z ##[debug]Importing function 'Remove-AzRmVmCustomScriptExtension'. 2022-01-21T19:23:13.4774398Z ##[debug]Importing function 'Remove-AzureSqlDatabaseServerFirewallRule'. 2022-01-21T19:23:13.4793187Z ##[debug]Exporting function 'Add-AzureAnalysisServicesFirewallRule'. 2022-01-21T19:23:13.4809885Z ##[debug]Exporting function 'Remove-AzureAnalysisServicesFirewallRule'. 2022-01-21T19:23:13.4826912Z ##[debug]Exporting function 'Get-AzureAnalysisServicesStatus'. 2022-01-21T19:23:13.4844523Z ##[debug]Importing function 'Add-AzureAnalysisServicesFirewallRule'. 2022-01-21T19:23:13.4862817Z ##[debug]Importing function 'Get-AzureAnalysisServicesStatus'. 2022-01-21T19:23:13.4881118Z ##[debug]Importing function 'Remove-AzureAnalysisServicesFirewallRule'. 2022-01-21T19:23:13.4904318Z ##[debug]Loading module from path 'D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\deploy-aas-db.psm1'. 2022-01-21T19:23:13.5256639Z ##[debug]Exporting function 'LoadDlls'. 2022-01-21T19:23:13.5273050Z ##[debug]Exporting function 'LoadTabularDatabaseFromFile'. 2022-01-21T19:23:13.5290095Z ##[debug]Exporting function 'LoadTabularDatabaseFromServer'. 2022-01-21T19:23:13.5307048Z ##[debug]Exporting function 'MergeDatabases'. 2022-01-21T19:23:13.5323222Z ##[debug]Exporting function 'Get-AgentIpAddress'. 2022-01-21T19:23:13.5340206Z ##[debug]Exporting function 'ProcessMessages'. 2022-01-21T19:23:13.5358854Z ##[debug]Importing function 'Get-AgentIpAddress'. 2022-01-21T19:23:13.5378471Z ##[debug]Importing function 'LoadDlls'. 2022-01-21T19:23:13.5395045Z ##[debug]Importing function 'LoadTabularDatabaseFromFile'. 2022-01-21T19:23:13.5413770Z ##[debug]Importing function 'LoadTabularDatabaseFromServer'. 2022-01-21T19:23:13.5431173Z ##[debug]Importing function 'MergeDatabases'. 2022-01-21T19:23:13.5447774Z ##[debug]Importing function 'ProcessMessages'. 2022-01-21T19:23:13.5573625Z ##[debug]Loading assembly: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\assemblies\Microsoft.AnalysisServices.Core.dll 2022-01-21T19:23:13.8971343Z ##[debug]Loading assembly: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\assemblies\Microsoft.AnalysisServices.dll 2022-01-21T19:23:13.9530386Z ##[debug]Loading assembly: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\assemblies\Microsoft.AnalysisServices.Tabular.dll 2022-01-21T19:23:14.0143877Z ##[debug]Loading assembly: D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\assemblies\Microsoft.AnalysisServices.Tabular.Json.dll 2022-01-21T19:23:14.0947498Z ##[warning]The 'overwrite' option will be deprecated in a future version. 2022-01-21T19:23:14.0958095Z ##[debug]Processed: ##vso[task.logissue type=warning]The 'overwrite' option will be deprecated in a future version. 2022-01-21T19:23:14.0959601Z ##[debug]Retrieving user/password 2022-01-21T19:23:14.0977006Z ##[warning]Be adviced that the user/password authentication will be deprecated in a future version. Please switch to 'SPN' or 'inherit' option 2022-01-21T19:23:14.0978074Z ##[debug]Processed: ##vso[task.logissue type=warning]Be adviced that the user/password authentication will be deprecated in a future version. Please switch to 'SPN' or 'inherit' option 2022-01-21T19:23:14.0999750Z ##[debug]INPUT_ADMINNAME: 'svc-EDP-AZAS-PRD@another.onmicrosoft.com' 2022-01-21T19:23:14.1023996Z ##[debug]INPUT_ADMINPASSWORD: '*' 2022-01-21T19:23:14.1443987Z ##[debug]Entering Get-AzureAnalysisServicesStatus. 2022-01-21T19:23:14.1576393Z ##[debug] endpoint: '@{Url=https://management.azure.com/; Data=; Auth=}' 2022-01-21T19:23:14.1595548Z ##[debug] serverName: 'edpbase' 2022-01-21T19:23:14.1612894Z ##[debug]Getting running status of azure analysis services server: edpbase 2022-01-21T19:23:14.1699789Z ##[debug]Connection type used is ServicePrincipal 2022-01-21T19:23:14.1721448Z ##[debug]Connection type used is ServicePrincipal 2022-01-21T19:23:14.1777250Z ##[debug]Getting azure analysis service properties: 'edpbase' 2022-01-21T19:23:14.2003469Z ##[debug]Fetching Access Token (spn) 2022-01-21T19:23:14.2240146Z ##[debug]POST https://login.windows.net/***/oauth2/v2.0/token with -1-byte payload 2022-01-21T19:23:14.2993612Z ##[debug]received 1368-byte response of content type application/json; charset=utf-8 2022-01-21T19:23:14.3071089Z ##[debug]Get Resource Groups 2022-01-21T19:23:14.3127298Z ##[debug]Fetching Resources from https://management.azure.com//subscriptions/f11177889-7a8d-4921-912a-7efc55b76131/resources?api-version=2014-04-01 2022-01-21T19:23:14.3150790Z ##[debug]GET https://management.azure.com//subscriptions/f11177889-7a8d-4921-912a-7efc55b76131/resources?api-version=2014-04-01 with 0-byte payload 2022-01-21T19:23:14.8019328Z ##[debug]received 6077-byte response of content type application/json; charset=utf-8 2022-01-21T19:23:14.8104731Z ##[debug]Fetching properties from https://management.azure.com//subscriptions/f11177889-7a8d-4921-912a-7efc55b76131/resourceGroups/EDP-UAT-ARG/providers/Microsoft.AnalysisServices/servers/edpbase?api-version=2017-08-01 2022-01-21T19:23:14.8124316Z ##[debug]GET https://management.azure.com//subscriptions/f11177889-7a8d-4921-912a-7efc55b76131/resourceGroups/EDP-UAT-ARG/providers/Microsoft.AnalysisServices/servers/edpbase?api-version=2017-08-01 with 0-byte payload 2022-01-21T19:23:14.9593438Z ##[debug]received 1115-byte response of content type application/json; charset=utf-8 2022-01-21T19:23:14.9653901Z ##[debug]Remove leftover firewall rule 2022-01-21T19:23:14.9710233Z ##[debug]Entering Remove-AzureAnalysisServicesFirewallRule. 2022-01-21T19:23:14.9728370Z ##[debug] endpoint: '@{Url=https://management.azure.com/; Data=; Auth=}' 2022-01-21T19:23:14.9746858Z ##[debug] serverName: 'edpbase' 2022-01-21T19:23:14.9764056Z ##[debug] firewallRuleName: 'vsts-release-aas-rule' 2022-01-21T19:23:14.9780432Z ##[debug]Removing firewall rule 'vsts-release-aas-rule' on azure analysis services server: edpbase 2022-01-21T19:23:14.9799638Z ##[debug]Connection type used is ServicePrincipal 2022-01-21T19:23:14.9818032Z ##[debug]Connection type used is ServicePrincipal 2022-01-21T19:23:14.9837231Z ##[debug]Getting azure analysis service properties: 'edpbase' 2022-01-21T19:23:14.9857732Z ##[debug]Fetching Access Token (spn) 2022-01-21T19:23:14.9877662Z ##[debug]POST https://login.windows.net/***/oauth2/v2.0/token with -1-byte payload 2022-01-21T19:23:15.0846014Z ##[debug]received 1368-byte response of content type application/json; charset=utf-8 2022-01-21T19:23:15.0869295Z ##[debug]Get Resource Groups 2022-01-21T19:23:15.0885803Z ##[debug]Fetching Resources from https://management.azure.com//subscriptions/f11177889-7a8d-4921-912a-7efc55b76131/resources?api-version=2014-04-01 2022-01-21T19:23:15.0905311Z ##[debug]GET https://management.azure.com//subscriptions/f11177889-7a8d-4921-912a-7efc55b76131/resources?api-version=2014-04-01 with 0-byte payload 2022-01-21T19:23:15.5371490Z ##[debug]received 6077-byte response of content type application/json; charset=utf-8 2022-01-21T19:23:15.5402271Z ##[debug]Fetching properties from https://management.azure.com//subscriptions/f11177889-7a8d-4921-912a-7efc55b76131/resourceGroups/EDP-UAT-ARG/providers/Microsoft.AnalysisServices/servers/edpbase?api-version=2017-08-01 2022-01-21T19:23:15.5420973Z ##[debug]GET https://management.azure.com//subscriptions/f11177889-7a8d-4921-912a-7efc55b76131/resourceGroups/EDP-UAT-ARG/providers/Microsoft.AnalysisServices/servers/edpbase?api-version=2017-08-01 with 0-byte payload 2022-01-21T19:23:15.5832268Z ##[debug]received 1115-byte response of content type application/json; charset=utf-8 2022-01-21T19:23:15.5892395Z ##[debug]Removed firewall rule 'vsts-release-aas-rule' on azure database server: edpbase 2022-01-21T19:23:15.5916274Z ##[debug]Get agent IP address 2022-01-21T19:23:18.0500615Z ##[debug]Loading database from 'D:\a\r1\a\EDP_AAS_CI\drop\EDP_DataIntegration\EDP_AAS_DataIntegration\Model.bim' 2022-01-21T19:23:18.0562743Z ##[debug]Loading tabular database from file 2022-01-21T19:23:18.7752461Z ##[debug]Loading database 'Planning' from 'asazure://uksouth.asazure.windows.net/edpbase:rw' 2022-01-21T19:23:18.7803217Z ##[debug]Loading tabular database from server 2022-01-21T19:23:19.0645937Z ##[debug]Using 'Azure SQL (single connection)' details 2022-01-21T19:23:19.0795293Z ##[debug]Applying datasouce credentials for 'SQL/edp-dev-azsql-01 database windows net;DataIntegration' 2022-01-21T19:23:19.1359698Z ##[debug]Merge database with the following options: DeployPartitions, DeployRolesAndMembers 2022-01-21T19:23:19.1937855Z ##[debug]Overwriting target partitions 2022-01-21T19:23:19.1991280Z ##[debug]Overwriting target roles and members 2022-01-21T19:23:19.4296911Z ##[debug]Deploying database to asazure://uksouth.asazure.windows.net/edpbase:rw 2022-01-21T19:23:21.8515519Z Deploying database ('Planning') to 'asazure://uksouth.asazure.windows.net/edpbase:rw' complete 2022-01-21T19:23:21.8938116Z ##[debug]Leaving D:\a_tasks\deploy-aas-db_a55f5b79-9828-4b7f-9528-85e9e826c028\1.5.8\deploy-aas-db.ps1. 2022-01-21T19:23:21.9489224Z ##[section]Finishing: Deploy AAS Model

[liprec]

Thanks for the log, but unfortunately I do not see any errors. Are you active using the scale out functionality as you are connecting to the management server?

[DamolAAkinleye]

Yes, this is being used for managing the workload on the server. could this be a problem with the deployment ? There is no error when deploying. The only issue is that I cannot see the changes after a successful deployment.

[liprec]

Just to be sure: you do not see the new model at the management server?

[DamolAAkinleye]

Yes that is correct

[liprec]

Sorry, but I have to dig into this to see if I can reproduce it and/or what is causing this. And as there is no error it will take some time, unfortunately.

[liprec]

Unfortunately I cannot see what is causing this behavior: is it possible that I take a look at your configuration to see what is happening? Feel free to discus the options with me via email: mail@datascenarios.nl

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.