SQL query in advanced settings in PBI desktop for Oracle

[Arioli_Chezhian]

Hi,
I am using Oracle as data source in PBI desktop.
In oracle the data appeared as shown below:

In PBI desktop am getting the below error:

The query I required is:
Select * From ACTIONLOG
Where LOGGED_TIME >= '01-07-2023';

I tried lot of queries but still getting the above metioned error.
SELECT * FROM ACTIONLOG WHERE LOGGED_TIME >= TO_DATE('2023-07-01');
SELECT * FROM ACTIONLOG WHERE LOGGED_TIME >= TO_DATE('2023-07-01');
SELECT * FROM ACTIONLOG WHERE TO_DATE(LOGGED_TIME) >= TO_DATE('2023-07-01');
SELECT * FROM ACTIONLOG WHERE LOGGED_TIME >= DATE '2023-07-01';

Please advice the correct syntax to be used in PBI desktop in advanced settings to achieve my requirement.
Thanks in advance..!

[amitchandak]

@Arioli_Chezhian , Try like

SELECT * FROM ACTIONLOG WHERE LOGGED_TIME >= TO_DATE('2023-07-01', 'YYYY-MM-DD');

in case this does not work check the driver is correct

Topic description have steps

https://community.powerbi.com/t5/Desktop/Getting-Power-BI-Desktop-to-work-with-Oracle-ODAC-after-ver...

[Arioli_Chezhian]

Hi @amitchandak 
SELECT * FROM ACTIONLOG WHERE LOGGED_TIME >= TO_DATE('2023-07-01', 'YYYY-MM-DD');

I tried the above query as well. It's not working. 
Just to add up few more points to give you a better view, only if I try to filter based on this date/time field am getting that error.

Example: if I try to import data based on below query it's working.
SELECT * FROM ACTIONLOG
WHERE USER_NAME IN ('abcd','efgh');

In this case still do you think it's due to the driver issue?

Please advise.