02-03-2017 06:55 AM
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.
02-08-2017 01:08 AM
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.
02-17-2017 12:26 AM
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.
07-02-2017 07:31 PM
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.
07-02-2017 08:45 PM
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?
"Proud to be a Datanaut!"