Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

SAP BW Connection Issues

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?

Status: Delivered
Comments
v-haibl-msft
Employee

@nimanthaf

 

I cannot repro the same issue on my side. Could you please check the Region settings in Control Pane?

If issue persists, I suggest you to create a support ticket at http://support.powerbi.com (see bottom of page).

 

Support Ticket.gif

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Delivered