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.

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

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

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

 

v-yulgu-msft, thank you for your attention.

 

I took a step back and removed from the file every calculated column and also the calendar table. But sadly nothing changes. See how I selected just one row (filtered by the column NFS.Nº) in the query editor, and how it doubles the info in the report view.

 

Query Editor

Report Data

 

I'm attaching this new file here

  • mr_guedes's avatar
    mr_guedes
    Icon for Helper I rankHelper I
    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.

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

    Hi mr_guedes,

     

    I don't know why the filtered row will duplicate in report view. This is very odd. Have you tried to re-load your dataset to check if it helps?

     

    Regards,
    Yuliana Gu

  • kobibarac's avatar
    kobibarac
    Regular Visitor
    8 years ago

    Any update on this issue?
    Experiencing similar problems...

  • cgeraeds's avatar
    cgeraeds
    Icon for Advocate I rankAdvocate I
    5 years ago

    Had the same problem and strangely enough this also was the cause for me.

    A query was merged which had nothing to do with the calculation that doubled most lines, but removing it solved the issue for me.