API change Analysis Services database in gataway data sources

Question

Hi!&nbsp;I'm trying programmatically change/update database in an Analysis Services Gateway data source - is there any way to do so?&nbsp;I trying to to&nbsp; &nbsp;1. publish an PBIX file (with data source on premise Analysis Services database through Gateway)&nbsp; &nbsp;2. Remap the data source to a different database on same on premise server&nbsp;Is this possible in Power BI API?&nbsp;Or is it programmatically possible to change data source database in PBIX file before publishing it?&nbsp;Any automated solution/workaround is&nbsp;appreciated :-)&nbsp;Kind regards,&nbsp;NAJ

eric_zhang · Answer

Anonymous wrote:
Hi!
&nbsp;
I'm trying programmatically change/update database in an Analysis Services Gateway data source - is there any way to do so?
&nbsp;
I trying to to
&nbsp; &nbsp;1. publish an PBIX file (with data source on premise Analysis Services database through Gateway)
&nbsp; &nbsp;2. Remap the data source to a different database on same on premise server
&nbsp;
Is this possible in Power BI API?
&nbsp;
Or is it programmatically possible to change data source database in PBIX file before publishing it?
&nbsp;
Any automated solution/workaround is&nbsp;appreciated :-)
&nbsp;
Kind regards,
&nbsp;
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&nbsp;that can change the connection string , however it only supports&nbsp;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.
&nbsp;
By the way, for the gateway REST API operations demo, you could reference this Knowledge base.

anonymous · Answer

thank you for the reply Eric,&nbsp;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&nbsp;SSAS On-prem live source.&nbsp;I have already tried most of the Gateway API functions (created new datasource , set all connections, etc.) - without any luck.&nbsp;&nbsp;Above request seems to be a limitation of the current REST API?&nbsp;Kind regards,&nbsp;NAJ

anonymous · Answer

Did you ever find a work around for this?&nbsp;Thanks, Shilpi

Forum Discussion

Related content

Cohort analysis

Azure Analysis Service Migration Scenarios

Error with externally shared semantic models and "Analysis Services Database" connector

Database connectivity.

Error Querying from Analysis Services Source