Oracle Date field transformation throwing error 'ORA-01830: date format picture ends before convert'

[kvraghavaiah]

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.

[v-robertq-msft]

Hi, 

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://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[fbottazzoli]

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