Braggilicious's avatar
Braggilicious
Frequent Visitor
9 years ago
Status:
Done

Different results between PowerBI Desktop report and Published report

I have a report which uses an live connection to an onpremise SSAS instance and cube.

 

When viewing/designing the report in PowerBI Desktop, all measures return correct values and totals.

 

When I publish the exact same report, the measure is divided by 10000 and incorrectly totals.  

 

There is nothing special about the measure, no calculations, no custom aggreations.   I have even reinstalled the on-premise gateway a number of times, but I still get the incorrect results in the published version of the report.

 

I have even attempted to create the report online, rather than use PowerBI Desktop, and I get the incorrect result. 

 

Any troubleshooting hints, or advice would be appreciated.   Different results in a live connection are concerning.

Gateways
Reports

6 Comments

  • Braggilicious's avatar
    Braggilicious
    Frequent Visitor
    9 years ago

    I can confirm that just querying the measure through PowerBI Desktop and PowerBI Online yields different results.

     

    I've event deployed a new SSAS database and the same measure is different when queried via both methods.

     

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Braggilicious

     

    I just tried to get data from my SSAS but cannot repro the issue as you described. Are the values in Desktop and Service have the same unit?

    If issue still persists, I suggest you to create support ticket at http://support.powerbi.com (see bottom of page) since it may be account or machine specific.

     

    Best Regards,

    Herbert

  • Braggilicious's avatar
    Braggilicious
    Frequent Visitor
    9 years ago

    Thanks Herbert.

     

    Unfortunately I am still getting the error, so I will have to raise a service desk ticket as you suggested. 

     

    Cheers

     

  • OC_BI's avatar
    OC_BI
    Frequent Visitor
    7 years ago

    Hi Braggilicious,

    Did you eventually sove the issue?

    Can you share what you did?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi there,

     

    well the quick fix of this problem is to make bookmarks of the page and then publish the report.

    Note - if the reports already has some bookmarks. Don't update them, just make a new bookmark without deleteing the previous one.

     

    Hope this will help 

Completed Ideas