topic Re: Getting an error when we connect to Oracle data source connection through Direct query mode on P in Report Server

Getting an error when we connect to Oracle data source connection through Direct query mode on PBIRS

Anonymous — Mon, 28 Jun 2021 14:49:39 GMT

Hello All,
We're trying to connect to 'Oracle' data source connection through 'Direct Query mode' and it's working as expected on Power BI desktop application, but when we publish this report to Power BI report server ( On premise ) , we're getting the below shown error.

Note : We've validated the data source connection on power bi report server and the connection is successful, but we're seeing this error.

And current, we're using Power BI Report server May'2021 version and PBI desktop May'2021 version. We saw the same issue on earlier version ( i.e. January 2021 ) also .

Could you please look into this issue and kindly let us know your suggestions to fix it.

Thanks in advance !

- Gopi

Re: Getting an error when we connect to Oracle data source connection through Direct query mode on P

pabeader — Mon, 28 Jun 2021 17:30:56 GMT

Have you installed and tested the oracle drivers on your report server and gateway (if you have one?)

Re: Getting an error when we connect to Oracle data source connection through Direct query mode on P

Anonymous — Mon, 28 Jun 2021 19:00:25 GMT

Hi @pabeader,

Thanks for checking on this, yes, we had already installed the oracle drivers and tested on our PBI report server, but we don't use/have gateway (server).

FYI - Here, ' import mode ' type and ODBC connection type is working fine, only the issue is with 'direct query' mode.

When we test the connection of the report on PBI report server - it's working fine, but when we run the report it's throwing error.

Any suggestions please to fix this.

Thank you !

Re: Getting an error when we connect to Oracle data source connection through Direct query mode on P

pabeader — Mon, 28 Jun 2021 19:05:59 GMT

I'm just getting ready to try direct query on oracle. If I run into trouble and figure it out, I will for sure post about it.

Re: Getting an error when we connect to Oracle data source connection through Direct query mode on P

Anonymous — Tue, 29 Jun 2021 14:40:41 GMT

Hi @pabeader,

Thank you again, if you've tested this at your end, please let me know the result .

Re: Getting an error when we connect to Oracle data source connection through Direct query mode on P

Anonymous — Thu, 01 Jul 2021 01:38:31 GMT

@Anonymous
Have you tried the default Oracle database connector using Direct Query mode.
Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team

Re: Getting an error when we connect to Oracle data source connection through Direct query mode on P

Anonymous — Fri, 02 Jul 2021 15:48:09 GMT

Hi @Anonymous ,

Thanks so much for looking on this issue, actually Oracle data base direct query mode is working on power bi desktop, but the problem we're facing is in power bi report server ( on premise ) - we can test the data source connection successfully on power bi report server, but when we run the report, it's throwing the below error. We're not able to fix this error, please help us on this.

Thanks in adavance !