Forum Discussion
On premise server migration - Repointing of data source
My Power BI reports currently source data from an on-premise SQL database however this database is being migrated to another on-premise server. In terms of repointing the reports to the new server, can this easily be achieved without having to manually having to repoint each of 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.
8 Replies
hi PaisleyPrince
it's easily doable using parameterized data source, you just have to create a new parameter for your data source and everything else will sync seamlessly.
My Work:
Analytic Pulse Blog
Docynx Productivity ToolsHi, thanks for your response. How would this work in practice ? Would the new parameter have to be inserted into every single current report ?
Hi. You can open power bi desktop, go to transform data and change the source step for the tables. As a good practice, AnalytcPulse is suggesting a parametrization. If you use parameters for the source, the next time you need a change, it's going to be really straight forward. Parameter examples:
- https://www.youtube.com/watch?v=OnaDJkGOmIE
- https://www.youtube.com/watch?v=XIq5vN5oPf8
I hope that helps
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 ?
Hi PaisleyPrince ,
Thank you for your prompt response AnalyticPulse ibarrau .
I wanted to check if you had the opportunity to review the information provided and resolve the issue..? Please let us know if you need any further assistance.We are happy to help.Thank you.
