Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Type mismatch.

[dee2019]

I have never seen this issue & I have used this data source on other projects. The data source is an SQL Table.

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)). '."

The table loads in the Query Editor but when trying to close and apply I get the above message.

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .