Repointing the dataset to another gateway

[vishanshul]

Can we repoint the dataset(published in Power bi Sevice through power bi desktop Postgresql as a data source) to another gateway with different DB details in PostgreSQL already gateway configured in power bi service? 

Want to map this to another gateway

So want to map this to another gateway but only one option is showing which is the same one from which we are importing the data.

Thanks.

[Jayendran · Accepted solution]

Hi @vishanshul ,

All you can see in the Gateway Connection Page (From your screenshot),  the exact data source which you published with your report from the PowerBI Desktop. 

Once after you published the report into powerbi.com you can only use the published data source for your report and not able to see other gateway which having different db credentials.

There are 2 possible ways to achieve your requirement

1. You have to call the Update Datasource API, this will help you to update the exisiting data source to a different data source

2. While creating a report, create a new parameter and use the parameter to point your database,server details and publish it.After that you can update the parameters in the powerbi.com and use the other gateways.

See my new Article on PowerBI - CICD using Azure DevOps