Forum Discussion
Solved
PowerBI Import Issues
I have an existing query that I need to pull into PowerBI. The query runs in dBeaver, SAS EG, Toad but when I paste the query into the SQL Statement under Advanced Options when I 'Get Data' it provi...
Thanks for your help but I figured out a solution.
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.