Forum Discussion
Not a legal OleAut date..
Getting the following error while refreshing from an Oracle DB using the Gateway refresh... The following exception occurred while the managed IDataReader interface was being used: Not a legal Ol...
Hi,
I had almost the same issue with an ODBC connection to a Progress Database. Everything works fine in Power BI Desktop but was not able to refresh once uploaded to a group.
I've applied the following work around and it works for me:
1. Go to the query designer
2. Transform the Date field(s) to a number field
3. Add another step in the Query editor
4. Set the number field back to the desired Date field.
Now i'm able to schedule and run the refresh.