How to refresh the Data Model link without refreshing all the tables in Data Model RRS feed

  • Question

  • Hi,

    I am encountering an issue caused by implicit measures. For example, I have a column [Sales]. When I drag [Sales] and drop it to Pivot Table value field, an implicit measure, i.e. [Sum of Sales], will be generated automatically. However, if I close this file and reopen it, when I use VBA to call [Sum of Sales], I will get below error.

    However, as long as I open Power Pivot window (Data Model) at least once, and then call [Sum of Sales] using VBA, it works fine. My thought is when you open Power Pivot window manually, the data model link is automatically refreshed, so the implicit measures can be recognized. Is there a way to refresh the data model link without refreshing the tables in data model (refreshing tables takes too much time)? Or could someone explain why implicit measures cannot be called when a user just opens the file, and how to solve this problem in a better/more robust way?


    Thursday, July 28, 2016 4:02 PM