DirectQuery with Oracle Datasource fails

MartinBergstrom — Tue, 12 Mar 2019 07:18:24 GMT

Running Power BI Report Server version Version 1.4.6969.7395 (January 2019)

Using the 12.2.0.1 Oracle 64-bit drivers.

Creating a very simple report in PowerBI desktop Version: 2.65.5313.1562 64-bit (januari 2019) using DirectQuery against an oracle database. The Report works from PBI Desktop, but when uploaded to the Report Server it fails with a "Unable to access the the Analysis Services" message.

Creating the same report as an imported report works fine on the PBI Report server, even when doing a scheduled refresh.

In both cases using basic authentication.

I notice that the datasources under the Manage/Datasources info in Report server look different in the two cases:

For DirectQuery: "datasource=myserver.company.com; persist security info = True"

For Imported: "myserver.company.com"

However since they cant be changed I dont know if this matters.

Any suggestions on how to get this to work?

Re: DirectQuery with Oracle Datasource fails

Anonymous — Wed, 13 Mar 2019 02:06:12 GMT

We are having the very exact issue here, with SQL server as our data source.

Re: DirectQuery with Oracle Datasource fails

Anonymous — Fri, 13 Dec 2019 11:31:06 GMT

We are having same exact issue with direct query for oracle database. From many days searching for the solution but didnt find any

topic DirectQuery with Oracle Datasource fails in Report Server

DirectQuery with Oracle Datasource fails

Re: DirectQuery with Oracle Datasource fails

Re: DirectQuery with Oracle Datasource fails