Oracle Date field transformation throwing error 'ORA-01830: date format picture ends before convert'
November (Also December) Desktop and Gateway have a Bug with respect to Oracle Date fields transformation. The reports with date fields with a Power Query transformation like
(DataSet) = Table.SelectRows((Table), each (DateColumn) >= Date.StartOfYear(Date.AddYears(DateTime.FixedLocalNow(),-10)) and (DateColumn) <= Date.EndOfYear(DateTime.FixedLocalNow()))
throw the error 'ORA-01830: date format picture ends before converting entire input string'
The particular reports were running successfully until November upgrade to Desktop/Gateway.
2 Comments
- v-robertq-msft
Community Support
Status changed:NewtoInvestigatingHi,
According to the error message, the issue seems to be related to the Oracle Date fields transformation with the Power BI.
If you want to get a solution for this kind of upgrading caused problems as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft.
https://powerbi.microsoft.com/en-us/support/
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
fbottazzoliAdvocate V
Hello kvraghavaiah , I'm facing this issue too. Did you get any answer for this? I'm still using December 2021 version.
Thank you in advance,
Francesca
