cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
danielgajohnson
Helper I
Helper I

Visual displaying different results on Service than on Desktop

Hi All,

 

I can't figure this one out. Here is what my visual looks like on the desktop app:

 

Desktop.PNG

 

 

And here's what it looks like in the cloud service:

 

Service.PNG

Neither visual has any filters applied to it. What am I missing???

5 REPLIES 5
v-kalyj-msft
Community Support
Community Support

Hi @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.

@v-kalyj-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?

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 user@domain.com | 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 _ kalyj

 

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



aj1973
Community Champion
Community Champion

Hi @danielgajohnson 

Check these out, it could be either one:

Solved: Desktop & Service renders differently - Microsoft Power BI Community

Solved: Desktop & Service renders differently - Microsoft Power BI Community

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

@aj1973 thanks for the reply. You sent the same link twice, was there another post with a similar problem? The one you sent wasn't the same problem I'm having.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors