Refreshing data never goes right, help?!

Hi ltkort,

Firstly, after you use personal gateway to configure schedule refresh for your ODBC data source, do you check if there are any other errors in Refresh history? According to the above error message you mentioned, it can be caused by that there are incorrect date values in data source. In your scenario, you will need to correct these illegal data values to make schedule refresh work properly. There is a similar thread for your reference.

Secondly, in Power BI Service, you can specify different time to refresh the dataset and it can only be 8 times during a day. How long will the dataset refresh once? It depends on your schedule time.

Thirdly, you can use on-premises gateway to schedule refresh for ODBC data source, we should put connection string using dsn which reflects “Driver={ yourdriver};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;”.



Thanks,
Lydia Zhang