Forum Discussion
Issue with refreshing semantic model with datasource conbected through gateway
Hi all, recently we started getting this error on all of .mdb files located on out on-premise server, to with we setup connection through gateway. This happens when trying to refresh semantic mo...
{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: FACT_1200_linereport.
You didn't change the data format of a column in that table?
Nothing was changes as far as i know - similar errors happen on at least 3 access files. I even tried to convert from .mdb to newer format but that did not change anything. Tried also putting this files on different server - also no change.
In general you should try to avoid using Access (and especially .mdb format) for your data storage. Do you have an option to migrate your data to SQL Server?