Forum Discussion

mr_guedes's avatar
mr_guedes
Icon for Helper I rankHelper I
8 years ago
Solved

Different values from PBI Desktop to Web Version

Hey guys,   Something strange is going on for a while and as I thought this would be fixed with the updates I never care to point it out. But, since this october update didn't make it, here it goes...
  • mr_guedes's avatar
    mr_guedes
    8 years ago

    Yes,

     

    Just recently I found out that I've merged two queries and as a result the lines were doubled. As this specific query was used over and over again, I took me a lot of time to find out what was going on.

     

    So, check it out if you have merging queries that are doubling any lines. This might be what you are looking for.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

That is so bizarre. I can't fathom a cause for that off the top of my head and I realize that you can't share your PBIX file because you have sensitive information in it. If there is any possibility that you can remove or obfuscate the sensitive information and share the file that's the only way that I can think of to troubleshoot what is going on.

mr_guedes's avatar
mr_guedes
Icon for Helper I rankHelper I
8 years ago
@smoupre wrote:

That is so bizarre. I can't fathom a cause for that off the top of my head and I realize that you can't share your PBIX file because you have sensitive information in it. If there is any possibility that you can remove or obfuscate the sensitive information and share the file that's the only way that I can think of to troubleshoot what is going on.

 

Ok, I'll do that! How can I share the file? Can't find a way to attach it (I'm new to this forum).

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi mr_guedes,

     

    You could upload the .pbix file on OneDrive and attach the shared link here.

     

    Regards,
    Yuliana Gu

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Hi mr_guedes,

         

        I encounter the same problem as yours if I directly publish the .pbix file you provided. By checking the report, I noticed that the start date and end date in slicer are changed after publishing to service. That is why the total value is different in desktop and service.

        Desktop

         

        Service

         

        However, if I create below two measures and republish report to service, the date is correct.

        Today = TODAY()
Today90 = TODAY()+90

        Besides, if I don't create above two measures, just delete the calendar table and re-create it using the same formula, then, re-publish report to service, the date slicer displays the same as desktop also.

         

        Best regards,
        Yuliana Gu