Append multiple tables is slow

[Anonymous]

Hi,

I am connecting to oracle DB using import mode and have to append all DB's to 1st DB.Currently i have appended 4 tables which has total 130 rows only,but still it is taking lot time to load the data.Is there a way to load data fastly?

[Anonymous]

Hi @danextian ,

Thanks for your reply.I am connecting to on-premise database and currently i am using 4 DB but have a requirement to connect over 90 DBs and the underyling query do not have complex transformation.Is there any solution to overcome the issue?

[danextian]

Hi @Anonymous ,

If the underlying queries aren't complex and there are jsut a few rows,  then there is only so much tweaking you can do in Power Query. You need to fix the latency between your data source and your local machine first. As previousy suggested,  create a view  in your data source that combines those databases and use that instead and/or create the report in a virtual machine that is  within the server's network.

[danextian]

Hi @Anonymous ,

130 rows should normally not take long to load unless the underlying queries have complex transformations and/or the data source itself or the connection to the data is causing the latency such as connecting to an on-prem database via a VPN. Alternatively, you can create a view in SQL that combine the four tables and load that instead.