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:

 

I have this cashflow panel that tells me the amount of payables and receivables on a daily basis, but the sum changes wheter I'm using the desktop or the web version of the app. 

 

The tables below show my receivables during a specific amount of time.

 

This is the info I get when I'm using the desktop version:

 

And this is the info I get when checking the web version:

Notice the I only covered my personal data, the rest is exactly the same. I know for sure that the web version is showing the right data, but why on heaven do I get doubled values when I use the desktop version? The column "A Receber" shows the amount of money. The report was developed on the desktop version and then uploaded to the web.

 

Thank you for your attention.

  • 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.

17 Replies

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

    Would have to see what the formuals were for the columns you are showing.

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

       

      @smoupre wrote:

      Would have to see what the formuals were for the columns you are showing.


      This column actually has no formula. It is as downloaded from my sql database. In the query editor the values are correct, just like in the web version.

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

        Sooo...you are saying that when you import the data from your database that the values shown are in your actual data in Desktop. You aren't doing any aggregation of the column in the visual. But, when you publish that to the Service that your values actually change to different values? I'm rather confused.

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

    Hi mr_guedes,

     

    What is your desktop version? Currently, the latest release is 2.51.4885.701 64-bit (October 2017), could you have a try?

     

    Regards,
    Yuliana Gu

    • mr_guedes's avatar
      mr_guedes
      Icon for Helper I rankHelper I
      8 years ago
      v-yulgu-msft wrote:

      Hi mr_guedes,

       

      What is your desktop version? Currently, the latest release is 2.51.4885.701 64-bit (October 2017), could you have a try?

       

      Regards,
      Yuliana Gu

      I'm updated to the last version (2.51.4885.701 64-bit )