In DevOps pipeline, how can you handle multiple data sources in one analysis services model

user_6918146 0
Viewed 262

We are building our analysis services model off of an azure sql server data warehouse and a second azure sql server database. You can easily add multiple data sources in the visual studio AAS model/project.

However, when we setup the devops pipeline i can only add one database connection in the pipeline settings.

[![Devops Pipeline][1]][1] [1]: https://i.stack.imgur.com/nhVOb.png

Is there a workaround for handling multiple data sources in one AAS model in Devops?

azure-analysis-services azure-devops
1 Answers

Is there a workaround for handling multiple data sources in one AAS model in Devops?

I am afraid there is no such way to handle multiple data sources in one AAS model in Devops.

When I check the source code for this task, I could get following code:

switch ($connectionType) {
    "sql" {
        $model = ApplySQLSecurity -Model $model -Server $sourceSQLServer -Database $sourceSQLDatabase -UserName $sourceSQLUsername -Password $sourceSQLPassword
    }
}

It use this command line to create a Database, we could not provide one more datebase name in one command line.

To resolve this issue, you could try to add another task or add a new pipeline for another data source.

Hope this helps.

user_74607770
Related