Edit data sources in Enterprise Gateway
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.
I modified the post to only show “Edit” . You can delete data source by clicking on “…” next to the Data source instance
It's getting towards the end of 2019 and this still isn't a feature... I really hate this product sometimes
Really needed ASAP.
agree! Please add feature
Keith McGillivray commented
Wholly agreed here - having to delete and add a new one is highly inefficient.
Lewis Henderson commented
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!
Adam Gallard commented
Yeap, I have clients who will be moving their database server and I want to just change the connection in the gateway
Andrew Davis commented
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.
Totally agree! with so many data sources to manage between different Gateways, Would make it much simpler.
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?
Jonas Winther commented
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.
Agree this is a must have feature to make administration of online datasources so much easier
Jonathan Poulin commented
Agree. This is a must-have.
It doesn't make sense to need to delete + create a new data source.
Alexis Legrand commented
There feature will definitively simplify administrator's life. It is a real pain when you want to rename a data source and to achieve that you need to re-create it. Totally agree!
Dave Ruijter commented
I Support this idea. Recreating a datasource, just to change the name of the data source or the name of the referenced Database is not a desirable.
The Joe Jetta commented
If you need to "edit" a datasource beyond changing the user and password you can just delete the one that is there and create a new one with the changes you need.
Melissa Klein commented
Agree. I need the ability to connect to multiple Salesforce orgs. Currently I don't think that there's a way to switch between them or to even remove one and add another.