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:
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.
What is the setting to exclude the state column from the tabular editor in command line? Is there a ps script
Sorry, I mean How to exclude the state column from the TMDL model ? It would be much more helpfull if it is via command line
I don’t believe the TMDL serializer has an option to specify whether inferred properties such as “State” should be included or not. In any case, it is not something Tabular Editor lets you specify.