Connect Excel Pivot to Tabular Model RRS feed

  • Question

  • 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



    Friday, August 14, 2015 11:33 AM


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



    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