cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Arvis
Regular Visitor

sales data shows duble figures in online report, after scheduled data refresh

Hello! I'm having an unusual problem that I can't find an answer to. When I use the powerbi desktop version, the data is displayed correctly when saving the powerbi online, from the beginning the data is displayed correctly until the data is refreshed online or with scheduled refresh from the databases themselves, after which the sales data amounts to double. The database contains sales data for each transaction. Has anyone encountered a similar problem?
First picture for the same report online after online refresh:

Arvis_0-1642246595194.png

Second picture is from desktop version:

Arvis_1-1642248148287.png

 

 

2 ACCEPTED SOLUTIONS
Arvis
Regular Visitor

Disabled incremental refresh and it started to work correctly. Thanks

View solution in original post

Ok well that's a step forward. I'm fairly sure it will be related to the setup of incremental refresh. Guessing it's seeing the old data as new and adding it in.

 

That won't show in power bi desktop because incremental refresh only kicks in after it's in the service.

 

Confirm it by disabling to start with and then can if you can share your model we can think about making it work correctly.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

4 REPLIES 4
Arvis
Regular Visitor

Disabled incremental refresh and it started to work correctly. Thanks

bcdobbs
Super User
Super User

That is indeed very strange.

 

Few initial thoughts:

  • Do you have any incemental refresh involved?
  • I assume if you refresh in power bi desktop you don't get the same situation?
  • Does your source track historic data with datestamps?

Is the report running in premium capacity or PPU? Just wondering if we can point DAX Studio at it's xlma end point to see what the raw data is showing.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Arvis
Regular Visitor

  • Yes, I have set up incremental refresh, I will try to disable it. and check results.
  • If I refresh power bi desktop then it shows correct data.
  • Not sure, probably not.

Ok well that's a step forward. I'm fairly sure it will be related to the setup of incremental refresh. Guessing it's seeing the old data as new and adding it in.

 

That won't show in power bi desktop because incremental refresh only kicks in after it's in the service.

 

Confirm it by disabling to start with and then can if you can share your model we can think about making it work correctly.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors