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