Changing data source server

[marty_w]

Hello Power BI Community,

I'm hoping for some advice on how to best change the server in a data source, my goal is to go from a current IP based server to a FQDN value.  I have 100's of data sets & data sources tied to several 100's of reports so something at scale would be appreciated if possible, manually if needed.

Via the portal, app.powerbi.com, it appears the server value in the data set needs to match the data source to be a selectable mapping.  So creating a new data source with a FQDN value results in being unable to select it in mappings from the data set.  Deleting the data set results in the reports being also deleted automatically which is less than ideal.  

Via the REST API's the best we have gotten is updating the data set server form IP to FQDN and this breaks the data set to data source mapping.  I can create a new data source with same server (FQDN) and then map them together but this is naturally a multi step manual process - pretty messy.

Any advice would be much appreciated

[Greg_Deckler]

@marty_w So were these data sets and reports created via PBIX files or directly in the Service? 

[marty_w]

@Greg_DecklerReports and data sets created via publishing PBIX files into manually created workspaces in the service with data sources calso manually reated before this publish in the portal.

[Greg_Deckler]

@marty_w Well, so you would generally go into the PBIX file, Power Query, Advanced Editor and change the data source there in the Source line, save and publish. Obviously that is going to suck if you have 100's of PBIX files that you need to edit.

[marty_w]

@Greg_Deckler Thanks for the feedback - I had hoped to get this done staying away from the PBIX layer and get things done on the backend more or less.  I was able to work up a ~ 12 step manual process to get things changed, painful but at least

[Greg_Deckler]

@marty_w Yeah, figured that was the case, perhaps you could do something with the Power BI REST API, Update datasources:

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasources