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.

mgmeyer's avatar
mgmeyer
Icon for Power BI Team rankPower BI Team
8 years ago

Hey Ben, unfortuantely we didn't have a fix for this issue at the time we released the latest update but we are actively looking into this. We have a couple options we're looking at one of which is very promising, if it works out we should have an update very soon. As soon as I have some more information I will post it here.

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

Thank you for feedback.

 

If there is anything I can provide to assist (RDL files, log files, etc) please let me know.

  • messerjc's avatar
    messerjc
    Icon for Advocate IV rankAdvocate IV
    8 years ago

    Thank you for calling this out, Ben. You may have just saved our team a significant amount of pain. I suspect a decent number of our paginated reports are using LOOKUP functions but I'll have to confirm next week.