Diffrent data from refresh in desktop and from PBI service

[Drors]

Hi,

I have a BPIX file that contain more then 10 tables.

In one table i have a column that I use sum measure in a card visual, the result is 3600 after refreshing it in the desktop.

when i publish it, and create a scheduled refresh, the number go down to 500

all the measures from diffrent tables are OK, its only that spacific table

something very weird, anyone had this issue?

I use that file for a year and everything was ok, just in the last 2 days.

maybe microsoft change something in the way pbi service refresh the data?

Thanks

[v-yuta-msft]

Hi Drors,

Is the result correct in your power bi desktop? If in power bi desktop the result is correct, update your gateway and restart your computer. In addtion, after schedule refreshed implemented, wait a few minutes and check if the value is correct. If the issue still occurs, could you please share some fiddler traces when the issue happpens?

Regards,

Jimmy Tao

[Drors · Accepted solution]

Hi, 

I solved the issue, I recreated the table and the problem has been fix.

PS, my gateway was up to date so its not related to the gateway

[freder1ck]

What's the data source?

I've had bad refreshes when connecting to SQL Linked Tables. The query completes with no errors, but the data from the linked table is incomplete.

You may also try updating to the latest version of the gateway...

Fred