Values different from Desktop to Power BI Service and disappearing visuals

[JohnSkillington]

Hey all,

I´ve seen this issue posted by sveral people but I am yet to find a solution.  

We with most others when I publish my dashboard to the service it appears as it should.  However once I refresh some values change, I suspect this is related to what day is set as the start of the week.  I initially saw that the service changed it to Sunday when it was (as it should be ofr my needs) Monday in the desktop.  I first suspected it may be an issue with the "out of the box" time intelligence which I used to provide the start of the week from the date in my date table.  I then wrote a dax measure to bring the start of the week and force it to return Monday.  This seemed to fix the issue in terms of seeing dates in the viuals with remained as Monday after refresh.  Here is that measure:

WK Start Date = Rolling_Calender[Date] - WEEKDAY(Rolling_Calender[Date],2) + 1

However, I have some values that remained incorrect and appeared in the current week when it should have been in the previous week.  I have seen some people suggest it´s an issue with the regional setting in the desktop and service potentially not being aligned.  However, I can not find where in the Power BI service I can see what the regional setting are.  

Furthermore, I have visuals (not custom, just standard line and clustered column charts) which have no values in the service once I publish.  

I would greatly appreciate any help anyone can provide.  

thank you all in advance,

John

[v-yadongf-msft]

Hi @JohnSkillington ,

The change is due to the regional settings which are different for your Power BI Desktop and Power BI Service respectively.  So if you have a regional setting on Switzerland in PBI Desktop, same query manipulations could potentially result in different results in PBI service due to different regional data formatting.

Please check the language settings in power BI service, whether it is consistent with the regional settings in power bi desktop.

For more information, please refer to: Supported languages and countries/regions for Power BI - Power BI | Microsoft Docs

Regarding another question, visuals have no values in the service once you published. Here's a case similar to the problem you're having, you can refer to: Solved: PBI Service Visuals showing Blanks and not in Desk... - Microsoft Power BI Community. At the same time, Please install the latest version of power bi desktop.

^{Best Regards,}

^{Yadong Fang}

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

[lbendlin]

Mondays are overrated anyway.

On a more serious note - Power BI Service operates on UTC.  Depending on where you are in the world their Monday may not be your monday.

[JohnSkillington]

I´m not convinced this is the case.  If I could see what the regional settings are for the Power BI Service (Online) I could then check against those in Power BI Desktop and align, which in theory should irradicate this probem.  However I can not find where in Power Bi Service (Online) can I find where the data is being stored.