cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver III
Resolver III

Diffrent data from refresh in desktop and from PBI service

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver III
Resolver III

Re: Diffrent data from refresh in desktop and from PBI service

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

View solution in original post

3 REPLIES 3
Highlighted
Kudo Kingpin
Kudo Kingpin

Re: Diffrent data from refresh in desktop and from PBI service

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

Highlighted
Community Support
Community Support

Re: Diffrent data from refresh in desktop and from PBI service

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

Highlighted
Resolver III
Resolver III

Re: Diffrent data from refresh in desktop and from PBI service

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

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors