Forum Discussion

ForgotID's avatar
ForgotID
Advocate I
2 years ago

import data fast

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 ?

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      ForgotID
      Advocate I
      2 years ago

      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 ?