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

Direct Query not working

I always use Import for loading the data. So, i do not have much idea about the Direct Query.

I have a requirement to load the data usign "Direct query" connecting to Oracle database. But it is not working, i tried in 3 different machines. and everywhere am getting the below error message.

Direct query error.PNG

 
I could not find a solution in the community.  Any help would be much appreciated.
 
Thanks,
Soumya
6 REPLIES 6
khlebak Regular Visitor
Regular Visitor

Re: Direct Query not working

If you haven't already.. I would start troubleshooting by checking the data source settings and verifying your database info/credentials/permissions are set correctly.

Capture.JPG

 

Also see this link for what sounds like the same issue.. could be a 32 vs 64 bit problem. https://community.powerbi.com/t5/Desktop/Oracle-Databases-Client-could-not-be-instantiated/td-p/3305...

SoumyaPuppala Regular Visitor
Regular Visitor

Re: Direct Query not working

The permissions are correct and they are working fine in import mode.

Any settings has to be changed for direct query?

TeigeGao Super Contributor
Super Contributor

Re: Direct Query not working

Hi @SoumyaPuppala ,

Please check your Oracle database version, the direct query only supports Oracle Database (version 12 and above), please refer to this document: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources

Best Regards,

Teige

SoumyaPuppala Regular Visitor
Regular Visitor

Re: Direct Query not working

We are using latest version of Oracle.

I found out that i dont have Oracle Data Access client installed and am not able to install it.

 

Once installed, hope that might solve my issue.

TeigeGao Super Contributor
Super Contributor

Re: Direct Query not working

Hi @SoumyaPuppala ,

Any updates? Does it solve your problem?

Best Regards,

Teige

Highlighted
SoumyaPuppala Regular Visitor
Regular Visitor

Re: Direct Query not working

sorry for the late reply.

Yes we were able to install it in one of the machines and it is working now.

Thank you all for the help.

 

Thanks,

Soumya

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors