Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
MartinBergstrom
New Member

DirectQuery with Oracle Datasource fails

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?

2 REPLIES 2
Anonymous
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors