Publishing duplicates values in Power BI service

[Matt78]

Hi all,

This is a strange problem but I give it a try if some could help me out. Here a simple explanation what happens

I import data from data share and in Power BI desktop everything looks fine. In this example I have sales during monday 1.4. of 209€. But when I publish this report to Power BI service, the sales is doubled (also quatities etc.) I got a feeling this has something to do with start of the week, month or so? Is there a way to solve this or maybe a link where this sort of case was fixed?



br

Matt

[Uzi2019]

hi @Matt78 

Can you try to refresh the report from PBI service?

and make sure you refresh your data (PBI desktop) before publishing .

[Matt78]

Hi

Yes, I have done this. I want to point out that in this case referring to the screenshots, Sales 209€ is correct.

br

Matti

[Uzi2019]

hi @Matt78 

Is there any icnremental refresh??

[Matt78]

Yes, incremental refresh is used on this report

[Uzi2019 · Accepted solution]

hi @Matt78 

There must be issue in your parameter setting.

make sure dont use equal condition = in both the statement.

Is after  RangeStart

and Is before and equal to RangeEnd

I hope it may resolved your issue!

[Matt78]

Thank you, that did the trick 😊