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

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.

SAP HANA parameters are not getting selected correctly

Power BI  Issue.PNG

Hello

 

When I connecting my SAP HANA view it is not taking my input for paramters correctly (These HANA view level paramters).

This is a multi value paramter and selection is mandatory.

 

When I select only one value as input for my parameter it gives error as above.

 

When I multi select it  always miss my very last value of inputs,

For example if I select A , B and C it will only consider A and B while fetching the data.

 

Please help.

 

Regards,

Mohit vyas 

 

 

Status: Needs Info
Comments
v-qiuyu-msft
Community Support

Hi @mohitvyas,

 

From the screenshot, it seems that you connect to SAP HANA via ODBC connector in Power BI desktop, right? 

 

Please try to use SAP HANA connector directly in Power BI desktop. Also please update the Power BI desktop to the latest version 2.56.5023.1021 to see if the same issue occurs. 

 

Best Regards,
Qiuyun Yu 

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
mohitvyas
New Member

Hello Qiuyun Yu

 

I was always using SAP HANA connector only.

I replaced the setup to new version as you suggested but the problem is same.

 

When I select only 1 parameter value it gives error same as before.

When I select two paramter value it say only 1 paramter selected and remove my second paramter input by itself.

same with 3 paramter values as it keep first two values selected and remove 3rd one by itself.

 

Regards,

Mohit Vyas

 

attached screen shots.3rd value removed by power BI by itself.PNGAfter okay it shows 2 values selected.PNGpower bi paramter 3 values selected.PNG