I'm having a problem refreshing my report online. Everything works fine on the desktop version where I can easily update my dataset, but when uploading it and trying to refresh I get the following message:
Last refresh failed:
Data source error:
Not a legal OleAut date.. The exception was raised by the IDataReader interface. Table: ProfileScore.
I have read the other post with the same issue but those solutions do unfortunately not work for me.
Is there any way to convert dates before 1.1.1900 for the whole table? I have a bunch of tables with several columns including dates before 1.1.1900. Those dates come straight from ERP database and most of those cannot be changed in ERP GUI, (without manipulating the database).
Maybe some power query string? Table.ReplaceValue ?