Forum Discussion
On premise server migration - Repointing of data source
have you tried to use TMDL view (preview feature in power bi desktop)?
you can script the entire model (all the tables) at once and with a Find and Replace substitue all the occurences of your old db with the new one and then publish.
https://learn.microsoft.com/it-it/power-bi/transform-model/desktop-tmdl-view
if you leverage Power BI Project you can even do it for all the reports at once.
https://learn.microsoft.com/it-it/power-bi/developer/projects/projects-dataset
anyway the parameters suggestion it's worth to be implemented asap.
ok, thanks - so apart from going into each report manually and using parameters, there is no quick way to alter the source in all the reports ?
have you tried to use TMDL view (preview feature in power bi desktop)?
you can script the entire model (all the tables) at once and with a Find and Replace substitue all the occurences of your old db with the new one and then publish.
https://learn.microsoft.com/it-it/power-bi/transform-model/desktop-tmdl-view
if you leverage Power BI Project you can even do it for all the reports at once.
https://learn.microsoft.com/it-it/power-bi/developer/projects/projects-dataset
anyway the parameters suggestion it's worth to be implemented asap.
I'm confused. Even if you have all the reports saved as TMDL, the user haven't specified that, you can't change the sources and credentials. You could write some windows script runing for all folders looking for the file with sources and try changing. The viability of doing it a script for all power bi desktop files can't be done. Credentials can't be done.
I hope PaisleyPrince you have all developments saved as power bi project in a repo, otherwise this will be opening one by one to save again.I hope that helps,
