cannot load model when using directquery

[Anonymous]

Hi,

I am trying to connect with oracle database with direct query but getting followng error. pls guide how to fix it. previously i have connected to oracle datasource from same system.

[v-easonf-msft]

Hi , @Anonymous 

This issue should be related to the ODAC Driver ,please try to download the appropriate version.

You can try to search related posts to find more possible solutions.

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=0ac479ec-35bc-4d73-9c92-48a52f9f43e7&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi,

now i m getting following error, please advise.

[v-easonf-msft]

Hi , @Anonymous 

Could you please tell me whether your problem has been solved?
If it is,  please mark the helpful replies or add your reply as Answered to close this thread.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi , @Anonymous 

Please refer to this related post  and article:

https://community.powerbi.com/t5/Service/Direct-Query-1-million-row-limitation-in-Power-BI-Premium/td-p/847202

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#implications-of-using-directquery

If  problem has been solved ,  please mark the helpful replies or add your reply as Answered to close this thread.Other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Tahreem24]

@Anonymous ,

Are you able access Oracle DB now? There might be a change in names of Database name or Server.

First make sure that Are you able to open Oracle tool from your end?

Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

[Anonymous]

hi,

if i select import than its work fine and able to get connected with oracle db, but when use directquery from same machine getting error. pls guide.

thx

[az38]

@Anonymous 

try this solution https://community.powerbi.com/t5/Desktop/Oracle-DataAccess-Client-direct-query-error/td-p/757448

[az38]

Hi @Anonymous 

the issue in your computer settings - you should install correct clients and check permission to database server from your work computer and permissions for your personal account