cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thomdan Visitor
Visitor

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

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.

Moderator mgmeyer
Moderator

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

@frankvanzuilen we plan to put out a CU release which will only have bug fixes and no new features in the next week or so. For new features that have come online in the Power BI service those will get rolled into the next feature release of PBIRS which should be sometime around July.

frankvanzuilen Frequent Visitor
Frequent Visitor

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

@mgmeyer Thank for yoour feedback. Please let us know when this CU will be (is) actually available. I assume that this bug (breaking existing LOOKUP functionality) will be solved as well. BR Frank 

jbud55 Regular Visitor
Regular Visitor

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

I noticed that there is a new version of the March update available on the Report Server download page.  

 

https://www.microsoft.com/en-us/download/details.aspx?id=56722

 

It looks like it was released on Saturday.  Has anyone tried it yet?

 

 

frankvanzuilen Frequent Visitor
Frequent Visitor

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

@jbud55 thank you for notifying the community

@mgmeyer the https://docs.microsoft.com/en-us/power-bi/report-server/changelog doesn't show the details yet about this version. Does this new version solve all bugs/issues, or are there still any open items left?

Moderator mgmeyer
Moderator

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

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.

Highlighted
BenMackin Frequent Visitor
Frequent Visitor

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

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.

lberkholtz Occasional Visitor
Occasional Visitor

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

Ben, we were having the same problem and Build 15.0.2.402 update resolved it.

 

May I ask how you found out an update was available for this?

 

Len

BenMackin Frequent Visitor
Frequent Visitor

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

A few posts above this, @mgmeyer posted that a fix would be posted shortly that addressed this issue:

 

http://community.powerbi.com/t5/Report-Server/PBRS-March-Update-breaking-existing-RDL-reports-that-u...

 

Then @jbud55 posted that he saw the update was made available:

 

http://community.powerbi.com/t5/Report-Server/PBRS-March-Update-breaking-existing-RDL-reports-that-u...

jbud55 Regular Visitor
Regular Visitor

Re: PBRS March Update breaking existing RDL reports that use LOOKUP function

I just happened to check Microsoft's download page for PBI ReportServer on Monday morning.  Lucky timing!