Forum Discussion
Changing data source, how to make the migration (easily)
Hi,
I have lots of variables in lots of tables that are currently in SQL database and this database is going to die and the data be moved into PostgreSQL database. Table names are slight different. Variables names are slights different and might not be found in both... My questions is 1. How to change the datasource. 2 how to make this work easier... ?
Hi. I think the best you can do is actually go table by table of your power bi and create for each of the a postgresql query that make the table the most similar as possible as it is with sqlserver. The most important thing is try renaming the columns in order to get them all as they already are. Once you have that you go and change the "Source" step of each table with it's postgresql query in power query. If you manage to change like this, the report should stay equally related and working. The problem is if you forget a column or you use different names, in that case you have to relate again the tables and move again the columns to charts and measures.
Regards,
1 Reply
Hi. I think the best you can do is actually go table by table of your power bi and create for each of the a postgresql query that make the table the most similar as possible as it is with sqlserver. The most important thing is try renaming the columns in order to get them all as they already are. Once you have that you go and change the "Source" step of each table with it's postgresql query in power query. If you manage to change like this, the report should stay equally related and working. The problem is if you forget a column or you use different names, in that case you have to relate again the tables and move again the columns to charts and measures.
Regards,