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

Re: Very Slow Oracle Connection Speed

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.

Highlighted
Frequent Visitor

Re: Very Slow Oracle Connection Speed

Same here. Slow Oracle load compared to Toad. 

Highlighted
Frequent Visitor

Re: Very Slow Oracle Connection Speed

Same here.Still extremely slow.Takes forever.

Highlighted
Frequent Visitor

Re: Very Slow Oracle Connection Speed

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

Highlighted
Anonymous
Not applicable

Re: Very Slow Oracle Connection Speed

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors