Connect Oracle Database

[vijay27]

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.

[ayup]

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.

[GilbertQ]

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?

[v-haibl-msft]

@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

[vijay27]

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

[v-haibl-msft]

@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