Measures showing different values on power bi desktop than power bi service

[Anonymous]

Hi,

I created the following measure but it shows different values in power bi desktop and power bi service. This was not happening before. I set up the gateway recently and I am not sure if it is because of that since I don't see any reason that the data should be affected by the gateway.

% Unclear Categorization = (1-((SUM('structured_bill (2)'[Column 2])/COUNT('structured_bill (2)'[Column 2]))*100)/100)*100

[Greg_Deckler]

@Anonymous - Often resetting the report to default fixes these sorts of things.

[Anonymous]

@Greg_Deckler I'm not sure why that option is greyed out for me and it says you are viewing the default view of the report.

[edhans]

The data is not affected by the gateway. You should make sure your desktop and gateway are the same month - both July 2020. They do update the gateway mashup engine to correspond to the desktop. I have seen a bug in the mashup engine, but it was replicated in both the desktop and gateway - this was about 2 years ago. I've never seen them provide different results.

Are you sure your data is up to date in the service and not showing an old set of data?

[Anonymous]

@edhans @richbenmintz My data looks up to date. I don't see any difference except the measure values

[edhans]

Reset the filters. Your's may be black or a different color depending on the theme for your tenant. 

[Anonymous]

@edhans

I am not able to click it.

[edhans]

Well, I'm not sure where we go from here. I'd need to actually look at the environment at this point. I do not see how it could be a bug, as a bug that changed measure values would be HUGE. 

What is your data source? You might want to raise a support ticket. This has happened before with SQL Server in a very VERY specific set of circumstances that it took the team about 30 days to track down and another few weeks to fix. So you might have another situation like this.

[Anonymous]

@edhans I'm using Drill mapR so connecting power bi using ODBC.

[edhans]

Open a support ticket. There could be a mashup engine issue, or via screen share, something we cannot do here, they might see where you have a filter or setting that is wrong. 

I am sure the measure is fine. But it could be the underlying data isn't going through the gateway properly and returning different results. 

You could troulbeshoot that to some degree by creating big table visuals with no measures in them to see if what you expect to be there is there. If it isn't, then definitely open a ticket. This was how I found that there was a SQL Server issue several years ago.

[Greg_Deckler]

@Anonymous - Agree with @edhans 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Greg_Deckler]

@sbhambri - Often resetting the report to default in the Service fixes these sorts of things.

[richbenmintz]

Hi @Anonymous,

Any chance that you have different filters applied to each environment?

[richbenmintz]

My Only guess is that the data in the service is not as fresh as the data in power bi desktop or vice versa.

to test you can refresh your dataset in PBI desktop and then kick off a refresh in the service and see if the values match after they are complete. Note that depending on the velocity of the data coming into your source they data could still be different