The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.