Oracle import query is very slow

Question

Hi All,I wanted to load data from an Oracle database using an import query. I have 50K rows of data that is now taking 2 hours to load. Is there a technique other than Get Data&gt;Database&gt;Oracle database that I can use to import the from oracle DB?I'm hoping there'll be a way to speed up the data load.Thanks!&nbsp;

vijay_a_verma · Answer

Importing through Power BI provided Oracle connector is definitely slower. You can check out this as alternative (but downside is that it disables query folding)

Your Oracle data import in Power BI and Power Query is slow?

Forum Discussion

Oracle import query is very slow

1 Reply

Related content

Direct Query or Import

Oracle connection error

Query folding with Oracle

Import correctly CSV into power query

Dynamic M query parameter binding to a query table which uses import mode