Bug - Boolean

[saj]

Hi, we've uncovered a bug with Report Server. If we develop a PBIX in Power BI Desktop and use boolean values in filters then when the PBIX is published there is a difference between Server and Desktop interpret boolean values.

We work around it by using explicit text/number columns 0/1  t/f  y/n etc, 

Desktop - note TRUE/FALSE

Desktop

Report Server - note 0 / -1

Thanks

[saj]

We work around it by using explicit text/number columns 0/1  t/f  y/n etc, 

Desktop - note TRUE/FALSE

Desktop

Report Server - note 0 / -1

Thanks

[v-chuncz-msft]

@saj 

The latest version below works fine for me. You may try it.

https://www.microsoft.com/en-us/download/details.aspx?id=56722

[saj]

Great @v-chuncz-msft 

We're planning to upgrade in the next few weeks. Many of our PBIX are critical to Covid-19 response so it's a balance between time and upgrade but thanks.

[Anonymous]

Hi All,

We're working on the September 2022 version of PowerBI Report Server. We're facing the problem which was described above. Was this problem re-introduced? It would be great if it could be fixed.

Best,

Loes