Forum Discussion

danielgajohnson's avatar
danielgajohnson
Icon for Helper II rankHelper II
4 years ago

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:

 

 

 

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

 

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

Need Help

5 Replies

    • danielgajohnson's avatar
      danielgajohnson
      Icon for Helper II rankHelper II
      4 years ago

      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.

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.

    • danielgajohnson's avatar
      danielgajohnson
      Icon for Helper II rankHelper II
      4 years ago

      v-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's avatar
        v-yanjiang-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        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 _ kalyj

         

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