cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
joubertsaquett Frequent Visitor
Frequent Visitor

problem while syncing

Has anyone encountered any data synchronization errors?
My report after being published, when I click on refresh data source, it is synchronized but the data comes back wrong.

Capturar.PNG

 

Published report 

Capturar3.PNG

 

Synced report

Capturar2.PNG

 

seems to be a conflict...

1 ACCEPTED SOLUTION

Accepted Solutions
joubertsaquett Frequent Visitor
Frequent Visitor

Re: problem while syncing

Good Morning,

Thank you all for the help,

Problem is related to UTC, perform the date conversion to DATE / TIME / ZONE and the problem has stopped

7 REPLIES 7
joubertsaquett Frequent Visitor
Frequent Visitor

Problem syncing

Has anyone encountered any data synchronization errors?
My report after being published, when I click on refresh data source, it is synchronized but the data comes back wrong.

Capturar.PNG

 

Published report 

Capturar3.PNG

 

Synced report

Capturar2.PNG

 

seems to be a conflict...

Super User
Super User

Re: problem while syncing

Hi @joubertsaquett

 

Can you click on the Refresh button in the report, which will re-load the cache for your report and should then show the updated data.

 


Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
joubertsaquett Frequent Visitor
Frequent Visitor

Re: problem while syncing


So it actually updates the data, but when I do the update the report results in incorrect numbers. Only when I use the "Bi web"

v-yulgu-msft Super Contributor
Super Contributor

Re: problem while syncing

Hi @joubertsaquett,

 

Do you mean the report visual show wrong data after refreshing data source in Power BI Service? Or do you mean the report visual keep the original result even you have updated the data source? While this problem doesn't occur in Power BI desktop, right?

 

Was the data still wrong after refreshing the report page manually after updating the data source? Could you please try to re-publish the report? 

 

Besides, what is the data source? Do you use import mode or live connection to fetch data? Do you update data source manually or on schedule? 

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
joubertsaquett Frequent Visitor
Frequent Visitor

Re: problem while syncing

I use Power Bi with SqlServer, so the information on the desktop is correct, when I upload the file the report returns wrong values, so if I download the same report and open it on power bi desktop and click refresh, it displays me the information correctly.

v-yulgu-msft Super Contributor
Super Contributor

Re: problem while syncing

Hi @joubertsaquett,

 

You mean the value was incorrect once you published report to service, although you didn't make any operation, right? Can re-publishing report solve this problem? 

 

By the way, I noticed that the data range selected in slicer was different, did this cause the different result?

 

Besides, if your report connects to data source with import mode, could you share your pbix file so that I can test in my environment?

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
joubertsaquett Frequent Visitor
Frequent Visitor

Re: problem while syncing

Good Morning,

Thank you all for the help,

Problem is related to UTC, perform the date conversion to DATE / TIME / ZONE and the problem has stopped

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 309 members 3,413 guests
Please welcome our newest community members: