Forum Discussion
PowerBI Import Issues
Thanks for your help but I figured out a solution.
Maybe take it a bit easy on the date formatting
FROM db.census
LEFT JOIN db.enroll ON
census.id = enroll.id
AND census.term = enroll.term
WHERE enroll.date = '2024-01-29'
AND (census.start_dt IS NULL OR census.leave_dt >= '2024-01-22')
AND census.include_flag = 'Y'
Note that
WHERE enroll.date = '2024-01-29'
changes this to an inner join.
When I do that the error message changes to:
DataSource.Error: ODBC: ERROR [HY000] [Oracle][ODBC][Ora]ORA-01861: literal does not match format string
Are your date columns actual date columns or something else?
My belief is they are date/time - there is no data model for me to review and the only 'access' is through Access which I don't use. In Access when you link to the underlying table - the column says it is Date/Time and the column in the table is stored as 1/29/2024 12:00:37 AM
Thanks for your help but I figured out a solution.