Forum Discussion
Oracle Database error with date condition.
Hi,jobf .I am glad to help you.
Usually errors that start with ORA mean that they are ORACLE related errors.
So this error occurs when sending a SQL query to the database, which I would think would be a problem with your M code syntax.
You can try converting the date type to text first, then select Change Type > Using Locale...
Check if the format does not correspond due to different regions.
Solved: error date column - Microsoft Fabric Community
Or try changing your M code.
Solved: Re: ORA-01843: not a valid month - Microsoft Fabric Community
ORA-01843: not a valid month - IT Tutorial
How to Resolve the Not a Valid Month Error with Oracle TO_DATE- CodeProject
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The data for my Visual came from an Oracle Database. When writing the SQL, I tried to create a condition so that only data would come after a certain date. The problem is that it always gives an error. I tried to run the code in the database and it works fine, but for some reason in Power BI it gives an error. Does anyone have any idea why?
I tried using several date formats but none of them worked.