Issues with connection to Oracle Database data source in Power BI Desktop RS May 2026
There are two issues revealed in May 2026 version of Power BI Desktop RS app when working with "Oracle Database" data source. [1] From May 2026 version Power BI Desktop RS cannot connect to TNS names from tnsnames.ora that linked using instruction "IFILE" (include from external file): IFILE = N:\DBA\Oracle\additional_tnsnames.ora January 2026 version can work with such external TNS names (although Report Builder never can). [2] From May 2026 verson Power BI Desktop RS cannot connect to some usual TNS names that worked before. It returns strange Oracle error "Oracle: ORA-01017: invalid username/password; logon denied". But in fact credentials are correct, server is available. You can rollback Power BI Desktop RS to January 2026 version and same connection works again. Problems above looks like some new bug in "Oracle Database" data source type.
The ORACLE Selected Data extension is not installed or cannot be included
I have the error: The selected ORACLE data extension is not installed or cannot be loaded. Verify that the selected data extension is installed on the client for local reports and on the report server for published reports. in the made new connection with Oracle Database, How can fix the error? anyone see that error? Regards.Scheduled Refresh of report timing out error
We have a Power BI Desktop (Optimised for Report Server File) report built and have uploaded it to our Power BI Report Server. The report talks to our Oracle SQL Database. If I refresh the report directly from the desktop file, the report will update and bring in any changes. I've attempted to try schedule this refresh on the report server however get the following error: "Timeout expired. The timeout period elapsed prior to completion of the operation. The exception was raised by the IDbCommand interface" My confusion is that when testing the Data Sources, our Oracle connection with our authentication when clicked 'Test Connection' brings back 'Connected Successfully'. The only other observation is under 'Scheduled Refresh', the 'Status' stays stuck at "Started Data Refresh" and doesn't change regardless of the page being refreshed. Does anyone have any ideas? Confusing me as the report refreshes locally and connection should work but the scheduled refresh failsGetting an error when we connect to Oracle data source connection through Direct query mode on PBIRS
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
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?with CTE statement giving error
I am pulling query from Oracle Database into Power BI that outputs this but I want it to output this I thought MIN(I.CREATIONDATE) would give date-time with earliest hour in my original query SELECT TO_CHAR(MIN(I.INCIDENTID)) AS "Incident ID", MIN(I.CREATIONDATE) AS "Creation Date", TO_CHAR(I.CREATIONDATE,'MM-DD-YYYY') AS "Date", TRIM(MO.DOMAINUSERNAME) AS "Login ID", TRIM(M.MESSAGESUBJECT) AS "Email Subject" FROM MESSAGE M JOIN INCIDENT I ON M.MESSAGESOURCE = I.MESSAGESOURCE AND M.MESSAGEID = I.MESSAGEID AND M.MESSAGEDATE = I.MESSAGEDATE JOIN MESSAGEORIGINATOR MO ON M.MESSAGEORIGINATORID = MO.MESSAGEORIGINATORID GROUP BY TO_CHAR(I.CREATIONDATE,'MM-DD-YYYY'), TRIM(MO.DOMAINUSERNAME), TRIM(M.MESSAGESUBJECT) Then I was advised to use CTE with row_number() but now I get Message=ORA-00933: SQL command not properly ended I tried many variations. How to fix this? with CTE as ( SELECT MyTable.*, row_number() over (PARTITION BY MIN(I.CREATIONDATE) ORDER BY I.CREATIONDATE) AS rn FROM MyTable ) SELECT * FROM CTE WHERE rn = 1 SELECT TO_CHAR(MIN(I.INCIDENTID)) AS "Incident ID", MIN(I.CREATIONDATE) AS "Creation Date", TO_CHAR(I.CREATIONDATE,'MM-DD-YYYY') AS "Date", TRIM(MO.DOMAINUSERNAME) AS "Login ID", TRIM(M.MESSAGESUBJECT) AS "Email Subject" FROM MESSAGE M JOIN INCIDENT I ON M.MESSAGESOURCE = I.MESSAGESOURCE AND M.MESSAGEID = I.MESSAGEID AND M.MESSAGEDATE = I.MESSAGEDATE JOIN MESSAGEORIGINATOR MO ON M.MESSAGEORIGINATORID = MO.MESSAGEORIGINATORID GROUP BY TO_CHAR(I.CREATIONDATE,'MM-DD-YYYY'), TRIM(MO.DOMAINUSERNAME), TRIM(M.MESSAGESUBJECT)
