Forum Discussion
Oracle data load speed into Power BI Desktop
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
Hi,
I recently worked with SSIS +Oracle combination. I had the same performance issue with the Oracle OLEDB provider. Fortunately, we have Attunity connectors to Oracle that use a different mechanism to extract or load data to oracle much much faster than the OLEDB. I dont think we have the same support for Power BI (at least I havent found something yet). May be you can try using /+PARALLEL(X)+/ hints in your select statements.
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