Forum Discussion

Otey86's avatar
Otey86
Regular Visitor
8 years ago

SSRS to PowerBI

 

In Visual Studio I am using "=Iif((CountRows("Metallugy") < 1), True, False)" to hide a textbox. When testing the script in Visual Studio it works just fine but when I send it to the server of PowerBI I get the following error(see below). I'm using Version 1.2.6660.39920 (Build 15.0.2.389), Released: March 28, 2018. Does anyone know if the update (Version 1.2.6690.34729 (Build 15.0.2.402), Released: April 27, 2018) fixes this issue?

 

The Hidden expression for the text box ‘NumOfReports’ contains an error: Request failed. (rsProcessingError)

  • The Hidden expression for the text box ‘NumOfReports’ contains an error: Request failed. (rsRuntimeErrorInExpression)

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Have you tried using 1 and 0 ? instead of True and False? alternatively is the case of true and false important?

    • Otey86's avatar
      Otey86
      Regular Visitor
      8 years ago

      Thank you for the reply. The true and false statement isn't needed as of yet but for future maybe. I've also tried

      Sum(Fields!NumOfReports.Value, "Met") < 1 with no luck of getting PowerBi to work. I was told that the method worked before the update to Version 1.2.6660.39920 (Build 15.0.2.389). Just wondering if the latest update would fix this issue I'm having.

       

      As of now I have tried the following scripts with no luck:

      =Iif((CountRows("Met") < 1), True, False)

      =Sum(Fields!NumOfReports.Value, "Met")

      =True=isnothing(First(Fields!NumOfReports.Value, "Met") < 1)

       

      This is leading me to think it's a bug with the updated version we are currently using (Version 1.2.6660.39920 (Build 15.0.2.389)).

       

      Once again thank you for you reply.