Michael Daynes on 18 Oct 2019 21:43:49
I would like to ability to change the server and/or database for a Power BI Data Gateway Data Source using a GUI.
A Database may be moved servers or change its name and I would like an easy way of amending the data source.
- Comments (3)
RE: Change Server/Database in Data Gateway Data Source
The whole gateway/data source implementation needs a re-work:Reports published to the service should not rely on the server/database combination to identify a data source to use. That match should be done as part of the publishing process and a Data Source name (or key in the background preferably) should be picked. Once on the service, the reports/datasets should rely on that key so the name or properties of the datasource can change without breaking the report.Data source admins should have the ability to see a list of objects affected by changes to the DS. I know this is possible with PowerShell, but it requires O365 Admin role. It should be available to PowerBI Admins. Having a report in the service that can be fired from the datasource properties (lineage) would also be helpful and it can be built based on the existing API.Data sources list should be paged and searchable so large implementations can still be managed.Ultimately it seems MS is looking more into the VNet setup than keeping the gateway. If that can handle security seamlessly then all this gateway work will eventually be discarded. It would be nice to know where they are going.
RE: Change Server/Database in Data Gateway Data Source
I'm surprised this doesn't have more votes. We moved our SQL databases to a new server this weekend and now I'm going to have to sit here and manually republish every single report that connects to them! Am I missing something?
RE: Change Server/Database in Data Gateway Data Source
To enhance this Idea: existing datasets that use the Data Source Connection should not need a manual republish if the server name / Database changes in the gateway.