Data in an online board doesn't update correctly and not synced with desktop app

[idoselli]

Hi all,

I have a problem with my board. 

The values that I see in my desktop app are not in sync with the data I see in the online board (when both are refreshed)

for example, desktop app:

and in the online board:

The 'Latest RC' values doesn't even show up in the online board, and the values in the 'Stage' column are not correct.

Maybe this is relate to the fact that some of these are from calculated columns or tables?

all the data comes from azure storage explorer and I simply added some calculated measures,columns and tables.

Thanks for help.

[collinq]

Hi @idoselli ,

If you look at the query in the desktop, are there any fields with errors in them for either of those fields?  Are you using a divide or some other sort of math that is not handling a "0" correctly?

I would confirm that the following process is working.

1. Open report in Desktop, confirm Desktop is working and then refresh it and then publish it.

2. Open report online (if you already have it open, refresh the browser) and confirm that it looks the same .

Are they the same now?

[idoselli]

Hi @collinq ,

Thanks for the reply.

There are no errors or math errors, and 0s are being handled correctly.

I have tried the steps that you suggested and it still doesn't work unfortunately. 

[collinq · Accepted solution]

Hi @idoselli ,

Is the data type for the field numeric or alpha or any?  Please ensure that the field is not"any".  And, there is no RLS settings?

[idoselli]

Hi @collinq ,

Seems like this was the problem, some fields was 'any' type.

Thanks!