Tabular Editor Tricks - Object State

If you’re refreshing different parts of your Tabular Model at different times of the day, you may need to know what the current refresh state is, across all objects of the model. For example, running a “dataOnly” refresh on a table, does not automatically refresh calculated columns, hierarchies or relationships.

To know which objects are not in a “Ready” state, simply open Tabular Editor, load the model from your Analysis Services instance, and write the following in the Filter textbox at the top right corner of the screen:

:State<>"Ready"

Make sure to toggle the “Flat list” search result option (the right-most button on the toolbar). This should produce a result like the following:

image

In general, the Filter text box can be used to search across all object properties using Dynamic LINQ syntax. To enable Dynamic LINQ Filtering in Tabular Editor, make sure to put a colon (:) at the front of your search query.

Written on March 26, 2019 by Daniel Otykier