topic API change Analysis Services database in gataway data sources in Developer

API change Analysis Services database in gataway data sources

Anonymous — Thu, 20 Jul 2017 12:32:28 GMT

Hi!

I'm trying programmatically change/update database in an Analysis Services Gateway data source - is there any way to do so?

I trying to to

1. publish an PBIX file (with data source on premise Analysis Services database through Gateway)

2. Remap the data source to a different database on same on premise server

Is this possible in Power BI API?

Or is it programmatically possible to change data source database in PBIX file before publishing it?

Any automated solution/workaround is appreciated :-)

Kind regards,

NAJ

Re: API change Analysis Services database in gataway data sources

Eric_Zhang — Fri, 21 Jul 2017 02:55:13 GMT

Anonymous wrote:

Hi!

I'm trying programmatically change/update database in an Analysis Services Gateway data source - is there any way to do so?

I trying to to

1. publish an PBIX file (with data source on premise Analysis Services database through Gateway)

2. Remap the data source to a different database on same on premise server

Is this possible in Power BI API?

Or is it programmatically possible to change data source database in PBIX file before publishing it?

Any automated solution/workaround is appreciated :-)

Kind regards,

NAJ

Anonymous

The datasource in gateway is configured according to the SSAS dataset connection string. So I guess you're requesting to change the connection string(contains server, database info) for the dataset, right? There's an REST API Set All Connections that can change the connection string , however it only supports DirectQuery dataset. And based on my test, SSAS live connection string is not treated as DirectQuery mode. So I'm that your request is to an dead end.

By the way, for the gateway REST API operations demo, you could reference this Knowledge base.

Re: API change Analysis Services database in gataway data sources

Anonymous — Mon, 24 Jul 2017 11:03:37 GMT

thank you for the reply Eric,

yes, i'm trying/requesting to programmatically change/update the connection string (server/database) of an SSAS On-prem live dataset/source. And/or remap a dataset to a different SSAS On-prem live source.

I have already tried most of the Gateway API functions (created new datasource , set all connections, etc.) - without any luck.

Above request seems to be a limitation of the current REST API?

Kind regards,

NAJ

Re: API change Analysis Services database in gataway data sources

Anonymous — Wed, 04 Oct 2017 17:32:58 GMT

Did you ever find a work around for this?

Thanks, Shilpi