cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vishanshul Frequent Visitor
Frequent Visitor

Repointing the dataset to another gateway

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? 

Gateway.PNGWant 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.

1 ACCEPTED SOLUTION

Accepted Solutions
Jayendran Established Member
Established Member

Re: Repointing the dataset to another gateway

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

View solution in original post

1 REPLY 1
Jayendran Established Member
Established Member

Re: Repointing the dataset to another gateway

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

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 54 members 1,118 guests
Please welcome our newest community members: