Reply
Frequent Visitor
Posts: 4
Registered: ‎01-31-2017

Connect Oracle Database

Hi, 

 

I am connected to the Oracle database, and trying to extract some information from the DB. 

 

The SQL developer returns the rows in 2 hours, about 17 million rows, however Power BI took me 6 days to load the same rows.

 

This is the Power BI speed, can someone comment on why it is this slow, 

 

Image below with timestamp, 500 rows / minute , at this speed it will take more than 2 weeks.

Rate.png

 

 

 

 

 

 

Super Contributor
Posts: 4,720
Registered: ‎07-08-2016

Re: Connect Oracle Database

@vijay27

 

Have you tried to use Direct Query instead of Import mode? We recommend using Direct Query if the dataset is very large.

 

Best Regards,

Herbert

Frequent Visitor
Posts: 4
Registered: ‎01-31-2017

Re: Connect Oracle Database

HI Herbert, 

 

Two things here, 

 

- I have tried the direct query as well, but no impact, it still takes 4-5 days to load 17mln rows (I am evaluating options to connect Oracle to Azure DL and use Power BI with Azure, instead of direct with Oracle

 

- Also, if direct query qorks, that does not solve our problem since we have a 200+ users who will use the dashboard, and 95% of them do not have pro access, they only need read only.

 

Thoughts 

 

Thanks,

Vijay

Super Contributor
Posts: 4,720
Registered: ‎07-08-2016

Re: Connect Oracle Database

@vijay27

 

Have you tried to install PBI Desktop in the same machine where your Oracle database locates? Not sure if the network performance may affect the loading time.

 

Best Regards,

Herbert

Regular Visitor
Posts: 19
Registered: ‎10-18-2016

Re: Connect Oracle Database

Hi there

 

Did you manage to overcome the problem in retrieving data from an Oracle DB?

 

I am experiencing very similar issues concerning the query of data from Oracle, although with significantly fewer records involved.  When fetching rows via SQL Developer, I can output the result set from my query (approx 68k rows) in less than a minute.  However, in Power BI, this takes more than half an hour due to the small number of records (<20) that are fetched at a time.

Highlighted
Super User
Posts: 2,794
Registered: ‎06-24-2015

Re: Connect Oracle Database

Hi there

 

I have imported data before from Oracle and importing a few million rows took a few minutes.


So I would suggest making sure that the version of the Oracle Client that you have installed on your PC matches the same version of your Oracle installation?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"