Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
We are having the very exact issue here, with SQL server as our data source.
We are having same exact issue with direct query for oracle database. From many days searching for the solution but didnt find any
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
4 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |