Hidden Expression Error in Paginated Report Builder

Question

Since the last update in March to Report Builder 15.6.1207.2 I am experiencing this issue when I try to run reports on the desktop.

I have a text box that indicates that no items were returned by a query and is hidden or shown based on the following expression:

= Iif (CountRows("Announcements") > 0, true, false)

When I attempt to test my report on the desktop the following error occurs. However when I run the report in the web the error does not occur,

Here is the error message:

The Hidden expression for the text box 'Textbox1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
----------------------------
The Hidden expression for the text box 'Textbox1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
----------------------------
An error occurred during local report processing.

v-diye-msft · Answer

Hi&nbsp;Jpup7&nbsp;
&nbsp;
Sorry I can't recur the issue on my side, please kindly raise it to the support team for better advice, thanks!
https://powerbi.microsoft.com/en-us/support/&nbsp;

anonymous · Answer

Jpup7&nbsp;v-diye-msft&nbsp; &nbsp;I have the same issue . but mine has to do with the hidden expression for a rectangle in Power Bi paginated report.this is the expression&nbsp;=CountRows("LatestExtension") = 0&nbsp;The Hidden expression for the rectangle 'Rectangle4' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.----------------------------The Hidden expression for the rectangle 'Rectangle4' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.----------------------------An error occurred during local report processing.&nbsp;any possible resolution will be appreciated. Thanks&nbsp;

akorn · Answer

This is related to .Net configuration&nbsp;Can be as follows resolved, see screenshot:1. Navigate to C:\Program Files\Power BI Report Builder\RSPreviewPolicy.config 2. Create a back up of the file copying it to another location3. Open the file with Notepad and add the following script after line &lt;/PermissionSet&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;PermissionSet&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; class="NamedPermissionSet"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; version="1"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Name="ExecutionAndInfrastructure"&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;IPermission&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;class="SecurityPermission"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; version="1"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Flags="Execution,Infrastructure"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; /&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &lt;/PermissionSet&gt;4. In the section with UnionCodeGroup replace “Execution” with “ExecutionAndInfrastructure”5. Save and reopen Power BI Report Builder&nbsp;Official documentation: SecurityPermissionFlag Enum (System.Security.Permissions) | Microsoft Docs&nbsp;

Forum Discussion

Hidden Expression Error in Paginated Report Builder

3 Replies

Related content

Filter Expression for Report Builder

Power Bi Report Builder(Paginated Report)

Paginated Report Builder Treemap Issues

Power Bi Report Builder(Paginated Report) Dynamic

Paginated report - Builder