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 definitely hit the reset to default button, I kept that on there to highlight that I added a filter which is what caused the data to not match up; it's all correct before I add the filter.

I attempted to do a save as on the PBI report and upload a completely new report and it still had this issue. I even uploaded it from a different computer on an older version of PBI.

Each card visual is referencing multiple other measures I built (all just simple counts and sums)

Only after the last update in November is this not working anymore, I simply just went onto the services; without uploading a new version or anything; and it was showing incorrectly like this.

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

Hello RocketmanJP 

 

I have tested the slicer on the service and it won't affect the result of the card. So the version issue you mentioned should not be.

What you said is a bit messy... So I want to ask

Did you add a filter in desktop or service?

The result doesn't match, so where(desktop or service) the data is correct?

If you update the desktop version but don't republish to the service, it won't affect the existing report in the service.

So what is the scene where the problem occurred, can you rephrase it?

 

Best Regards,
Community Support Team _ Janey