HANA Calculation View with IP and filter expressions are not working with PowerBI

[vazaryan]

Hello, 

I have a calculation view with Input parameters with constant (*)(to get all the values if nothing provided) and I'm using filter expression to apply those filters. everything works fine in HANA and Analysis for Office, but once I try to get the Direct Query in PowerBI I see an error. I was thinking it might be the special character (*), but if I change the * to any value it also does not work. I even tryed to remove the constant value in the Input Parametr and still having the issue, unless i remove the filter expression it does not work. 

does anyone has a workaround as I do not want to load the large sets of the data into power BI.

input parameters

Filter expression

IP Properties

Hana Pop-up screen

PBI error

PBI error with different values

#DataSource.Error: ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error:  [34023] Instantiation of calculation model failed;exception 306002: An internal error occurred

#DataSource.Error: ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;339 invalid number: not a valid number string '' at function __typecast__() (at pos 0)

[v-juanli-msft]

Hi @vazaryan 

when you connect to the data source, do you see a data preview you should be able to choose the required input parameter?

If so, please enter the valid value, then you could see the data preview based on that input parameter right.

From your screenshot, it seems what you input is not a valid value.

How about changing this to a normal value instead from your SAP?

As a workaround, you could create parameter with Power BI Desktop to filter data from the data source.

You can follow below blogs to use query parameter in M query.

Power BI Desktop Query Parameters, Part 1

Solved: Passing multiple parameters to SAP BW Query

Best Regards

Maggie

[vazaryan · Accepted solution]

Hi @v-juanli-msft 

Thanks for the reply. 

I acctually found the problem and the solution. 

​ok, here is the solution: first in the HANA Input Parameter you have to remove the "Multiple Entries" check-mark, somehow power BI cannot handle that, but there is still a way to select multiple in Power BI, you just need to enter values like this XXX' , 'XXX  what happens is Power BI takes the whole value and puts it in singe quotes end result is 'XXX', 'XXX' and so on and it returns the values. 

hope this will help someone.