Forum Discussion
Data Appending from different servers
I'm importing data from mysql database , from DEV,ITG,PROD environment and creating a single dashboard which will show data of all the 3 environment. All the tables and columnns in each environment ...
Is there any way other than combine/append as there are many tables and each time if I combine/append the tables the performance is poor and replication of data is more.
HI Anonymous ,
You can try to do merge operation on the local file(e.g. put load data and merge data steps into excel worksheet), then you can use power bi to get the merged file, it should have better performance to loading data. (merge operations on the huge amount of file will spend lots of resources and cause the performance issue)
I haven't found methods/options to effectively increase the performance of the query table who contains large amount of records and heavy calculation.
Regards,
Xiaoxin Sheng