Issue with accessing Oracle database using DirectQuery

[vpshamsbi]

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

[v-jingzhang]

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.

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

[vpshamsbi]

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

[v-jingzhang]

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

[vpshamsbi]

any input on this issue is highly appreciated.