Forum Discussion

RocketmanJP's avatar
RocketmanJP
Regular Visitor
4 years ago
Solved

Published Report Filters Differently than PBI Desktop

Ever since the November 2021 release I am having issues when filtering a particular published report which gives different (incorrect) results versus the same report and filters in PBI Desktop. I exp...
Need Help
  • RocketmanJP's avatar
    RocketmanJP
    4 years ago

    I logged in and checked my reports again and this is working correctly now on the services so something must have changed back. I just opened the same report that was incorrect before and it is correct now today.

RocketmanJP's avatar
RocketmanJP
Regular Visitor
4 years ago

I will try to rephrase it;

Since the November 2021 update I am running into a bug where if you try to add any filter to a report that is published to the service it calculates everything incorrectly. Even if I upload the report with a filter already checked, it will come up showing incorrectly. On the same report in Desktop everything works correctly.

If you look back to my past posts you can see the screenshots I posted that show how the data looks different from PBI desktop vs PBI service (I did a save as, published the report to the service, and took the screenshots side by side to illustrate the bug).

Service:                                                       Desktop (correct) :

As you can see, same opp ID's being referenced, same filter. Only difference is that Service is calculating contexting incorrect since the update.

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

RocketmanJP 

 

Simple test can't find the problem like yours:

What is the data source of the report that has the problem? Are you connected to the gateway in the service, can it be refreshed normally?

 

Do you mean that any newly created report will have this problem?

If yes, Can you provide your current desktop version and service version?

If possible, please provide a sample file with the problem (without privacy).

 

Best Regards,
Community Support Team _ Janey

 

    • RocketmanJP's avatar
      RocketmanJP
      Regular Visitor
      4 years ago

      I logged in and checked my reports again and this is working correctly now on the services so something must have changed back. I just opened the same report that was incorrect before and it is correct now today.

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        4 years ago

        Hi, RocketmanJP 

         

        Okay, If your problem has been solved, you can mark your answer as solution to close the thread. If my post helps, please consider Accept it as the solution to help the other members find it more quickly. If not, please feel free to ask me.

         

        Best Regards,
        Community Support Team _ Janey