Forum Discussion
Helper IISQL query in advanced settings in PBI desktop for Oracle
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..!
2 Replies
- amitchandak
Super User
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
Arioli_ChezhianHi 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.
