ORA-01843: not a valid month

[gbigorra21]

When I upload a dataset from my Power BI desktop to the cloud and try to update it, I get the error ORA-01843: not a valid month. Is there any way to resolve this? I have checked the dates in the tables I import to Power BI, but I don't see any errors in the date format.

[LiperaDev]

To work with dates in PBI, you need to explicitly specify the formatting to avoid errors, for example:

TO_DATE(FECHA_MOVIMIENTO,'dd/mm/yyyy')

[Veronica25]

Have you resolved it? I have the same issue

[amitchandak]

@gbigorra21 , are you using any M parameters to filter the dates, or have used query, Seem like issue is there

[gbigorra21]

@amitchandak  No, I haven't used any M parameters. I simply imported the views that I use from my Oracle database, and as I mentioned, it updates correctly in Power BI Desktop. However, when I upload it to the cloud and schedule a refresh, I see that it fails most of the time due to this error.