none
Connect Excel Pivot to Tabular Model RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    We are trying to connect to tabular model from Excel 2010. The report contains many filters and every time we select one filter it takes 2-3 minutes to refresh the report from the cube. Is there a way disable the report refresh until all the filters are selected and refresh the report at one go similar to SSRS reports

    Br,

    Farha

    Friday, August 14, 2015 11:33 AM
    |

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Farha,

    Base on my test, it won’t refreshes the data from the server, it just filters current data (maybe in cache).

    I tried set ScreenUpdate to false and set the filters programmatically, but it doesn’t work. As far as I know, there isn’t a property or method in Excel object model that can disable the report refresh when change filters.

    Regards

    Starain

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Monday, August 17, 2015 2:42 AM
    |
    Moderator