Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I am getting the below error when conneting through a end user account.
"ole db or odbc error type mismatch exception from hresult 0x80020005 disp_e_typemismatch"
I tried out the same view using admin privileges, which worked very well. But with a user account it transformed decimal columns in to an identified format. Transformation is as follows.
Actual Value SAP View is 11,3000,4500.2345 this but query editor shows this as 11.3000.4500.2345. All commas for thousands have been transformed to ".". Any idea why? Is it problem with the connector or problem in the SAP side or problem in the query editor?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.