Skip to main content

Power BI

Needs Votes

Edit data sources in Enterprise Gateway

Vote (277) Share
's profile image

on 05 Jan 2016 12:38:58

I want to be able to edit server & database setup in the Enterprise Gateway. Currently, I can add new ones, but not edit ones already setup.

Administrator on 30 Jul 2020 16:57:53

I modified the post to only show "Edit" . You can delete data source by clicking on "..." next to the Data source instance

Comments (26)
's profile image Profile Picture

David Workman on 05 Jul 2020 23:54:35

RE: Edit data sources in Enterprise Gateway

Really needed ASAP.

's profile image Profile Picture

Power BI User on 05 Jul 2020 23:37:47

RE: Edit data sources in Enterprise Gateway

agree! Please add feature

's profile image Profile Picture

Keith McGillivray on 05 Jul 2020 23:20:56

RE: Edit data sources in Enterprise Gateway

Wholly agreed here - having to delete and add a new one is highly inefficient.

's profile image Profile Picture

Lewis Henderson on 05 Jul 2020 23:02:02

RE: Edit data sources in Enterprise Gateway

This feature is fundamental to PowerBI Online. I have created dashboards and reports for a sales team on PBID, and want to give them access to PBIO for the real time data that's hooked up to a SQL DB in Azure.

All I want to do is create templates, upload those to PBIO, and then change the data source to point to the SQL in Azure.

It's this lack of functionality that is getting me to look at alternatives.

Aside from that, everything is great!

's profile image Profile Picture

Adam Gallard on 05 Jul 2020 22:59:09

RE: Edit data sources in Enterprise Gateway

Yeap, I have clients who will be moving their database server and I want to just change the connection in the gateway

's profile image Profile Picture

Andrew Davis on 05 Jul 2020 22:59:08

RE: Edit data sources in Enterprise Gateway

I don't understand why this wouldn't be a feature in the first place. Databases are portable and renamable. Just a simple hardware churn could cause days or weeks of work to update reports to use a different data source entry for the same data. This needs to be fixed ASAP and should not have been locked down in the first place.

's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:56:36

RE: Edit data sources in Enterprise Gateway

Totally agree! with so many data sources to manage between different Gateways, Would make it much simpler.

's profile image Profile Picture

Power BI User on 05 Jul 2020 22:47:28

RE: Edit data sources in Enterprise Gateway

I cannot believe that this is not just a normal everyday feature in PBI online .. How could they possibly have shipped the product without this capability and be so coy as to not talk about this fact hoping that no one will notice.. Sad ..

To say "Just use PBID" is just not an acceptable answer.. Explaining PBID to users and especially to IT is just not a pleasant experience and frankly I believe hurts the success of PBI.

If this is political (as I expect it is) then I suggest that MS grow up and realize that dumbing down PBI in order to promote PBID is just downright childish.

Get us this feature and get it right away .. Or you're gonna hear a lot more about this from people like me in much more places.

I just cannot imagine how many people have gone and created PBI solutions of complexity and effort only to find that if they want to add or change ANY data sources in a single Dataset they have no option but to DO IT ALL OVER AGAIN FROM SCRATCH !

How can you guys look yourselves in the mirror for this?

's profile image Profile Picture

Jonas Winther on 05 Jul 2020 22:44:55

RE: Edit data sources in Enterprise Gateway

YES! Totally agree. Just today, I had to create a new data source, because the database changed. The hard part was replacing all the UPN mappings...manually, since gateway level mapping doesn't exist yet.

's profile image Profile Picture

Therese on 05 Jul 2020 22:44:08

RE: Edit data sources in Enterprise Gateway

Agree this is a must have feature to make administration of online datasources so much easier