Forum Discussion

BenMackin's avatar
BenMackin
Icon for Helper I rankHelper I
8 years ago
Solved

PBRS March Update breaking existing RDL reports that use LOOKUP function

It looks like something in the March update for Power BI Report Server is causing a breaking issue on RDL/SSRS reports that utilize the Lookup function (or it's derivatives LookupSet or MultiLookup)....
  • mgmeyer's avatar
    mgmeyer
    8 years ago

    The changelog should be updated soon but to answer your question yes this build addresses the nested Lookup function expression errors as well as several other bug fixes.

  • BenMackin's avatar
    BenMackin
    8 years ago

    I just wanted to confirm that the latest build:

     

    Version 1.2.6690.34729 (Build 15.0.2.402)

     

    Does indeed fix the issues we were having. At this point, we are going to be moving this to our produciton instances, as it has passed all of our internal regressions.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi mgmeyer 

 

2 weeks ago you mentioned that a possible solution was found to fix this issue.

 

This issue prevents us to put the PBIRS March Version into production (again).

The March version includes some new PowerBI functionality that our Dashboard designers are waiting for a long time already.

 

Could you please communicate a time schedule when a new PBIRS March patch will be available that also fixes this issue.

Or is MS planning to deliver an April version that includes the latest PowerBI functionality such as "buttons to trigger actions" and "Combo chart line styles"?

 

Thank you in advance,

 

 

thomdan's avatar
thomdan
Regular Visitor
8 years ago

I'm running into the same issue after installing Power BI Report Server version 1.2.6660.39920 (Build 15.0.2.389) released March 28, 2018.

 

We have an expression that uses the MultiLookup function to filter the data in a matrix. When the report is run on the March 2018 version of Power BI Report Server it returns the following error: Failed to evaluate the FilterExpression of the Tablix ‘tblxName’. (rsFilterEvaluationError). However, the report runs fine on the October 2017 version of Power BI Report Server and in Visual Studio.