Forum Discussion
Helper IIVisual displaying different results on Service than on Desktop
Community SupportHi danielgajohnson ,
Whether the value in the axis in your line chart is the source data or a calculated column? You can change the line chart to a table visual to see if it also differs in Desktop and Service.
In Power BI Services, UTC date time will change. If the dax function uses Today() or Now() these functions may encounter this problem, because Power BI Desktop uses our native language, and Power BI Services uses the language of the region where the account is located.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper IIv-yanjiang-msft The Time Block data is from a DAX table, but it doesn't use Today() or Now(), it just converts the numbers between 1 and 1440 into a time of day. The Y-Axis is calculated using the raw data, and the column used for that measure is a date/timestamp. I'm also a little confused because the data is coming out of our database in EST, and my PBI Service should also be in EST as I'm in New York. What am I missing?
- v-yanjiang-msft
Hi danielgajohnson ,
The region of your tenant is not certainly the location your company stayed, it's the region your tenant first been created, you can check your tenant region by this artical.
How can I check where my tenant and different workloads are located?
Our old friend named Windows PowerShell would help us to get this information. So to check where your tenant is located, first open PowerShell, connect it ot the Microsoft Online Service and to an Exchange Online session.
First you can run: Get-Mailbox -identity [email protected] | FL
This cmdlet will retrieve a long list of attributes. Here you may take a look at “OrganizatinalUnit”, which in my case is indicating an European server:
We can also check in this list for the attribute “OriginatingServer”, which in my case is a server located in the Amsterdam data center.
If you are running this cmdlets against a tenant that is provisioned in the US, the values would also indicate pretty clear that the mailbox is located in an US data center.
Also if mailboxes are located there, there is a 99,99% chance that also Sharepoint data and Skype for Business data is located in the same region.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.