Report with Import from SAP Business Warehouse: Measures are twice as high while monthly switch

[C1B1]

Hello,

we created a report which uses SAP BW via Import-Function and a DataFlow for the calendar.

So far the Gateway-Connection is running fine and all incoming data has been proved correct.

When one month is over and the other one starts (e. g. September -> October), all the measures in Power BI show doubled figures, like from 97,3 % -> 194,6 %.

In SAP BW, the report shows normal data and the error can only be seen in the report in PBI.

Can u provide any information whether this problem is known or where you would start to check? We cant find the error...

Thank you in advance.

Greets

Chris

[C1B1]

Hello, 

after changing the filter context the problem seems fixed. During the change from Sep -> Oct, there were no errors.

We will be checking this during the next periods and post here, if the problem occures again.

Thank you very much for your fast response!

[C1B1]

Hi Liu Yang,

thank you for your advice. We will try this out when the monthly switch happens. I will then look up in detail, whether there is a difference in Service vs. Desktop.

Kindest Regards,

Christopher

[v-yangliu-msft · Accepted solution]

Hi  @C1B1 ,

Does Measure display normally in Power BI Desktop, or the same as in Power BI Service, which is twice the previous value.

And check the filter and slicer status, whether Power BI Desktop and Power BI Service are set the same.

If it is displayed normally in Power BI Desktop, it may involve a problem with the UTC() time zone.

Whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing.

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.