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

Issue with accessing Oracle database using DirectQuery

Hello everyone, I need help due Direct Query Error .
I’m trying to contact with Oracle Schema using an Direct Query option but unfortunately it gives me this Error Message:
“Cannot load model
We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct, and that you have permission to access them.

The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Unable to find the requested .Net Framework Data Provider. It may not be installed. “

Noted that Oracle ODP.net driver
already installed and also .Net framework
And I can access data sources using lmport option

Please advise , if I need to reinstall anything Appreciate send Link to download

4 REPLIES 4
v-jingzhang
Community Support
Community Support

Hi @vpshamsbi 

 

Try installing a different ODAC client. I found a similar issue to this and the user resolved it by installing a different ODAC client. Something like below.

vjingzhang_0-1638353887593.png

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Thanks, @v-jingzhang I will try and update the outcome here.

 

@vpshamsbi Did you solve it? Is there any update?

vpshamsbi
Regular Visitor

any input on this issue is highly appreciated.

Helpful resources

Announcements
Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

PBI April Release 2022 768x460.png

Check it out!

Click here to read more about the April 2022 updates!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!