Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I'm trying to connect to an on-primise Oracle database. I followed this instrucution and installed ODAC and instant client.
This is the connection speed if I use sqldeveloper and each row has 140 fields. At least I can fetch like 80 rows/second.
However, when I use Power BI Desktop and connect the same database and the same table, I can only import 5-8 rows/second. I have 100K rows in this table, so this is going to take forever...
Then I connected to a remote desktop to a server, Power BI can load like 500 - 800 rows per second... but I can't do the development work on my remote desktop..
Did anyone have the simliar issue? Did I set up ODAC on my laptop wrong? Or there's other componment I didn't install?
Thank you,
Matthew
in 2023 on ora 12.1 version facing worst issue with odac driver pulling just 3lacs records out of 32million per hour my bad any suggestions
I have always had issues with the slow connection to an Oracle source.
The only way I found to get the data into the service was a sheduled spool using SQLcl and then using that csv as a source to load to the Service.
My ODBC load takes 2 hours, whereas the spool and load method takes a couple minutes. I'm currently testing the old ODBC method and it is again 2 hours. I have not bothered publishing. Nothing wrong with my network connection.
My original query uses a join, but the view is already joined, it just has way too many unwanted columns.
I would be interested if there were a way to use my own SQL query to select only my columns from Oracle, when using the Oracle Database as the source and hope it's faster. I cannot make my selection in the Power BI service, only the whole view, and I'm not the owner of the view to trim it to what I need.
Same here. Slow Oracle load compared to Toad.
Same here.Still extremely slow.Takes forever.
Hi,
As a test we updated our (way to old) oracle version to 12.2. That improved the speed a lot. From 16 to 4 minutes.
Br
Stian
Yeah, i have the same slow performance accessing Oracle Database with the 64-bit ODAC installed.
Is there any update on it? I have checked with other client tools like PLSQL Developer, Toad etc, they retrieval is far faster as compared to Power BI Desktop. What we are missing here? Please some one from the product team should answer that question with the rectification.
In my case the situation got solved just by adding ' in the WHERE clause
something like SELECT A, B, C, D WHERE Key_Partition = '2019180512345'
because Oracle was doing an implicit conversion
The post was made in 2016...And the connection is still slow...any progress or updates?
It takes forever to load
Hi, Sorry for replying to an old thread, but was this issue ever solved? - I see a few other threads reporting the same issue but with no solution. I am facing the same problem - data load from Oracle is much slower compared to other DBs (Postgres, SQL Server), especially when table has a lot of columns and/or the column size is large (ex. VARCHAR2(4000)). Tableau loads the same data at least an order of a magnitude faster - so its definitely not a network speed issue.
I'd be really interested in an update on this one too.
I completely echo abkgo's comment - I'm connecting to an Oracle view I have created with both PowerBI and Tableau, yet the extraction time between them is very different (Tableau being significantly faster).
Also - probably a separate issues I know, but when I publish a PBI book to the PowerBI service and connect via a content gateway that has been installed, the performance seems somewhat hit and miss. I'm extracting about 2.5m rows on my desktop, which takes around 20-30 however the same extraction in the PBI service takes about 2hrs and frequently times out (because its hitting the 2hr limit).
Would be interested in an update as well, since we have big issues with extracting data out of an Oracle DB
Export of 134k rows, 12 mixed columns.
Oracle SQL Developer: approx 1 minute
Power BI: 20 minutes
Hi Matthew,
When connecting the Oracle Database, in the prompt (where you enter your server name etc.) Is the checkbox "Include relationship columns" checked? If it is, can you check the performance without that checked?
If you want it to be faster with that option checked, a significant Oracle performance improvement is in our near-future plans 🙂
Hello Arify,
Sorry for replying to you late. I tried your method to uncheck the box. But the speed didn't improve that much...
I guess that's mainly my connection speed issue. Maybe I should wait for the new version release. I don't think I missed any key Orcale add-in to install, right?
Thank you,
Matthew
If unchecking that checkbox didn't make it faster, then it's probably your connection speed.. Can you try some other tools to see if they're faster? (Make sure the results aren't cached, otherwise it would appear fast 🙂 )
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
85 | |
84 | |
73 | |
49 |
User | Count |
---|---|
143 | |
132 | |
110 | |
65 | |
55 |