Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
vishanshul
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? 

Want to map this to another gatewayWant 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
Jayendran
Solution Sage
Solution Sage

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
Solution Sage
Solution Sage

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors