Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
Needs Info

Something went wrong with Parameter name when direct querying.

After refreshing a direct query to a SQL DB Table error message reads; "Expression should be true. Parameter name: Total sum of fractions doesn't equal 11. Fractions NaN, Nan, Nan." Original query ...
Gateways
Reports
MiraNi's avatar
MiraNi
Icon for Advocate IV rankAdvocate IV
6 years ago

I have the same issue with import query from SQL Server using parameters for datasource.

 

When I changed the reference from test to production server using the parameter, I got this error. Until that, everything worked fine. First I got an error: Expression should be true. Parameter name:Total sum of fractions doesn't equal 1. Fractions:0,0,0. After OK, I got an error message: No such interface supported. 

 

The extremely annoying thing here is, that I cannot close the last error message window - it just pops up again and again after choosing Cancel. I cannot go and analyze the error, instead I just have to force Power BI to close. So there is no way I can get forward with this issue.

 

Completed Ideas