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
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!