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 Pow...
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.