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

Question

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?

Your picture was not added correctly. I could not get the detailed info. If possible, please check if this document give any help: devblogs.microsoft.com/devops/… — Leo Liu-MSFT
The link there is to the image but you would have to browse to that web link. Let me try this: ScreenshotLink — T. Byberg

Leo Liu-MSFT Leo Liu-MSFT · Accepted Answer · 2020-06-24T09:56:36

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.

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

1 Answers