Wrong data displayed on Report Server

[Anonymous]

In my powerbi file I have several calculated columns.

My organization uses PowerBI 2021 September version.
Problem I'm having is with this one in particular: I'm calculating difference in minutes between two datetime columns. Another column is created to assign ID ranges to time for instance if time difference is less than 30 minus I'll return 1 for its range. I have another ranges and labels table which is connected to my table on this calculated ID of 1 with corresponding text label "<30 min" that I'm using to display in a table visual. Wherever it's possible I'm using SWITCH statement.

If I refresh the report (it's based on import query) on desktop ranges are assigned correctly and where it's calculated range is 1, it's getting assigned correct range but when the report is published to the server instead of "<30 min" it might display "4-8hours". 

Can anyone suggest what can be potentially wrong or how do I debug to find the issue?

[Anonymous]

Hi @Anonymous ,

Is your problem solved, and if so, can you mark it as a solution?

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @Anonymous ,

Since you mentioned using Power BI 2021 September version, verify if there are any known issues or limitations with calculated columns or DAX expressions in this specific version when published to the server.

With the January 2022 release, power bi is optimised for switch.

What's new in Power BI Report Server - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.