Forum Discussion
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.
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.
Is this a general issue. In other words: the "Lookup" functions don't work at all in this PBRIS March 2018 release.
My customer has some 15 reports using this kind of functionality.
Hard to say.
I have many reports that use lookup. Some of them have no issues. Some of them have issues. I can't exactly tell what causes the #Error, but it seems like if the lookup is used in conjunction with anything else, it fails.
Best thing I can say to do is test it out. Install the update on a test instance, and load up your RDL files. Initialy, our plan was to spot check reports, since it didn't seem like there was any real changes around RDL reports in this release. But seeing as how we have found these breaking issues, we are going through the process of evaluating all 180 reports we have on our system.
BenMackin Thank you for your feedback. We used the "Lookup" function to display the data in conjuction with other data sources data, and used in the sorting of the tables/matrices as well. Both sorting and display caused issues in all our reports.
mgmeyer We decided to rollback to the October 2017 version, which wasn't a simple uninstall of the March version, and a re-install of the October version. It seemed that the "ReportServer" database scheme was changed as well by the "March version" because the PBIRS/SSRS service couldn't connect to the "ReportServer" database anymore. After a restore of the "ReportServer" database with a back-up just before the upgrade everything was working again.
- Could you confirm that the "March version" indeed applied some changes to the "ReportServer" database scheme.
- When will a patch be available for the reported issues so far?
BR Frank
mgmeyer I noticed that a new patch/build was released for the PBIRS "March Version".
However the changelog doesn't mention that this bug/issue has been fixed as well. Could you verify whether this bug/issue was also (unmentioned) fixed in the latest patch, or that it will be fixed in another patch?
Version 1.2.6660.39920 (Build 15.0.2.389), Released: March 28, 2018
- Bug fixes
- For Power BI Reports (PBIX), fix for Export Data not working from Power BI Visuals
- For Power BI Reports (PBIX), fix for URL filters not working
- For Paginated Reports (RDL), fix for images not being displayed correctly in IE11 after upgrading to Power BI Report Server March release
Anonymous
I just installed the Version 1.2.6660.39920 (Build 15.0.2.389), Released: March 28, 2018 and tried with some of my RDL reports, and they are still getting the same errors when using the LOOKUP functions. So this is not fixed yet.
Is there any time frame for when this will be resovled?
- Bug fixes