cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ashwindd Frequent Visitor
Frequent Visitor

Power BI Desktop - Slow connection to Oracle

We have been trying to connect Power BI desktop to an Oracle table to import data into Power BI. The connection has been extremely slow with a througput of only 8-10 records per seconds. We have 19 million records to be imported and have not been able to successfully import the data even once.

 

Please let us know if there are ways to increase the throughput when connecting to Oracle?

Is the throughput better when we connect to SQL server or SSAS cubes using Power BI?

1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Power BI Desktop - Slow connection to Oracle

Hi @ashwindd,

 

In my opinion, as there are large amount of records returned from the Oracle database, it's take a long time to import data to desktop. I would suggest you Using Application Tracing Tools to trace the desktop running against the Oracle database. Also please try to connect to Oracle database in DirectQuery which will not import any data to desktop.

 

It's hard to say whether the performance connect to SSAS cube is better than Oracle database or not, the performance when get data can be affected by many factors, like database server performance, connect mode (Import, DirectQuery or Live connection), number of records, etc. But if there are large amount of data, I would like to connect in DirectQuery or Live connection. When we interact with the data, it will send backend query to access target database.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.