locked
Excel Pivot Table not Updating based on Powerpivot data model RRS feed

  • General discussion

  • Hello, I am running SQL Server 2014 SP2, Excel Professional Plus 2016 64 bit. I created a pivot table based on a Powerpivot data model connected to relational tables in sql server. The powerpivot data model updates properly but the pivot table does not update subtotals and totals properly. The data in the table will add up properly but the totals display a different value. I found two issues related to this: https://support.microsoft.com/en-us/help/2932559/fix-totals-are-wrong-after-you-filter-on-a-pivot-table-item-and-remove-the-filter-in-ssas-2012-or-ssas-2014 and https://support.microsoft.com/en-us/help/211470/calculated-field-returns-incorrect-grand-total-in-excel. The latter is exactly what I am experiencing but my sql server is fully patched. Can anyone tell me if this is still a known bug or has a solution?
    Tuesday, February 7, 2017 2:56 PM

All replies

  • Hi HillJohnC,

    For the issue in this article, we are currently looking into it and will give you an update as soon as possible.

    Thank you for your understanding and support.

    Best Regards,
    Angelia Zhang

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, February 8, 2017 2:13 AM
  • Thank you but that is not exactly the same issue.

    I am not using a calculated field based on other fields. I am simply calculating the values in a column of data.

    Wednesday, February 8, 2017 1:33 PM
  • Hill, any progress on this?

    Thanks!


    Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!


    Monday, October 9, 2017 8:46 PM
  • Please kindly mark the correct solutions as answers, this could be beneficial to other community members who are facing similar issue. Your contribution is highly appreciated.

    https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

    Thursday, January 18, 2018 11:43 AM
    Answerer