import data fast

[ForgotID]

I need to import 15 million row from Oracle to Power BI Desktop.

 Currently it can import 2500 rows per second so it takes over an hour to import all the rows.

What can I do to make this importing process faster ?

[Anonymous]

Hi @ForgotID ,

You can try the following:

Please try to remove the useless columns, filter data, etc. These actions could reduce the size of the dataset and improve the performance of import data.

You could also use DirectQuery instead of Import. DirectQuery will not import any data to desktop, which could improve the performance of data import.

I saw a related discussion here that you can refer to:

Data Import Performance is very slow in Power BI D... - Microsoft Fabric Community

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ForgotID]

Thank you so much for the insightful response.  I fully agree with what you said but my problem is importing data from the oracle to the Power Bi itself.  Please correct me if I am worng that for the direct query reports we need a dataset to connect. If I was using MS sql then I could have used SSMS to create a dataset and deploy it to Power BI but can I do this in the Oracle environment ?

[jdbuchanan71]

Would using incremental refresh be an option for you?
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

[ForgotID]

No I cannot do the incremental refresh