March 2019

Tabular Editor Tricks – Object State

March 19, 2019 / Tips & Tricks / Daniel Otykier

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 […]

Tabular Editor Tricks – Object State Read More »

Power BI Tricks – WhatIf parameters

March 14, 2019 / C# Scripting, Power BI, What-if / Daniel Otykier

Update May 29th 2019: It turns out that the technique outlined here can be used for SSAS or Azure Analysis Services Tabular models of Compatibility Level 1400+. In fact, just by adding the ParameterMetadata Extended Property (step 9 below) to any numeric column in your model, you can instruct Power BI to display a single-select slider as

Power BI Tricks – WhatIf parameters Read More »