Data Source is not getting updated in Azure analysis Service Tabular model

Majumder, Manish 131

I am trying to change the connection of the data source from Dev to Test SQL Server in AAS Tabular model.
Even after entering and pressing ok, the new database parameters are not getting updated in AAS Tabular model.
Could you pls help?

1 answer

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2021-09-15T22:19:50.777+00:00

Hello @Majumder, Manish ,
Thanks for the ask and using Microsoft Q&A platform .

Just curious as to where are you updating the data sources ? If you are doing from CVS , we will have to update the *.bim file and that shoul help .

Please do let me know how it goes .
Thanks
Himanshu
Please sign in to rate this answer.
Majumder, Manish 131 Reputation points

2021-09-16T03:52:55.08+00:00

I am trying to change data source in the AAS in order to point to Pre Prod DB and publish in AAS

Steps followed ;

Copied the entire repository of the AAS model in to another folder

Opened the model in the AAS , created a new data source connection then opened the model. Dim code and changed the data source connection with new data source details and saved. Deleted the earlier data source and resaved the model.

Reopened the model and tried to process data and it is throwing error for the tables. Below is an error for one such table.
Failed to save modifications to the server. Error returned: 'Expression in partition 'Partition' in table 'BP Targets' references unknown variable or function 'SQL/shell-01-eun-sq-pbynoehrvpfddcfxbena.database.windows.net;shell-01-eun-sqdb-'.

HimanshuSinha-msft 19,381 Reputation points Microsoft Employee

2021-09-23T20:50:56.607+00:00

Hello @Majumder, Manish ,
Are you still facing the issue , my apoloziges for the late response on my side .
Thanks
Himanshu

Majumder, Manish 131 Reputation points

2021-10-04T16:59:35.24+00:00

Hello,
Good Day,

Our requirement and solutioning changed later on.
So we did not go through the same steps and hence the issue again .
Thank you so much for enquiring on the same. Much Appreciated!!!
Sign in to comment