Merging Data from Excel and Oracle SQL Table Slow

[karmaimages]

HI,

I'm fairly new to Power Query so trying things out for the first time learning as I go.

I have a table of data in Excel which I'm linking to a table an Oracle SQL table using the merge function to pull data based on a matching reference in both excel and the SQL table.

The data refresh is very very slow, this maybe because the table it's looking up contains millions of rows and I only need to lookup the ones contained in my excel data.

Is there a better way or way to speed this up to refresh the data quicker?

 

[Coding4Fun]

As you mentioned its likely pulling in too much data dn limiting this would be a good start, if you are simply doing something like Select * From Some Table with a million + records then this is going to take a while, but if you alter your query to select a more limited data set this should help.

 

[arunsjain]

Hi,

If you need data that match with your excel table then you don't need to add SQL table in data model, keep it as connection only. It will not increase the size of the file and refresh will run faster. Try and share your experience.

Cheers!!!