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

ORACLE Database19c__DIRECT QUERY connection establishing

Hello,

Dear All, could you please help me with connecting to data source Oracle Database 19c via Direct Query?

Despite the Net Framework update, the connection with model can’t be established (with Oracle Database 19c).

Direct Query connection with Oracle Database 12c works fine.

 

Kind regards,
Robert

1 ACCEPTED SOLUTION

Hi @Robert01

 

Below are the limitations of direct query,be sure that you didnt trigger the limitation.

 

151.png

 

For references,pls click here.

 

Best Regards,
Kelly

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Hope you have checked , this one

https://www.solucionesleon.com/en/articles/power_bi_with_oracle.html



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi, thanks for the response.

 

Yes, I have checked "Import" method.

Unfortunatelly to the high volumes of data (mare than 50 milion records) we want to use "DirectQuery" with Oracle Database 19c.

Hi @Robert01

 

Below are the limitations of direct query,be sure that you didnt trigger the limitation.

 

151.png

 

For references,pls click here.

 

Best Regards,
Kelly

View solution in original post

Thanks for helping.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

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!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors