Forum Discussion

dgwilson's avatar
dgwilson
Resolver III
7 years ago
Solved

Oracle data load speed into Power BI Desktop

Hi there... I seeking some advice with a loading speed experience with Oracle Database loads into Power BI Desktop. Specifically I’m loading data from an oracle database… I have permission allocat...
Need Help
  • dgwilson's avatar
    dgwilson
    7 years ago

    The parallel load commands didn't work for me - the schema needs to be configured to deliver for that.

     

    I have performed a test foing a SELECT <field>, <field>, <field> from <tableName> - i.e. only a selected numebr of fields rather than a SELECT * from <tablename> and I can say that 1.5M rows loaded in about 2.5 minutes - way better than 30+ minutes.

     

    For me the full SELECT * is OK for investigation and understanding the dataset. When it's ramped up to a production scenario it is a good idea to only load what is needed.

     

    - David

MallikarjunaBan's avatar
MallikarjunaBan
Helper III
3 years ago

any break thru for this issue please reply

dgwilson's avatar
dgwilson
Resolver III
3 years ago

> any break thru for this issue please reply

 

Nothing specific. 

Advice is to only import the columns you need. Having a narrow table will make a huge difference. And then only the rows you need - that clearly helps tool.

 

After that I believe that in the July 2023 releas ethere are some changes to the Oracle Connector - so it is worth checking out what may have changed there.

 

- David