This is Part 2 of the Hybrid Mode in Tabular BI Semantic Model series, where we will learn more about the design tips, a few factors to consider on Hybrid mode implementation and a summarised advantages and limitations of Hybrid Mode.
Package parameter that is to be mapped to an environment variable should be use with caution. Deleting an environment variable that is mapped to a previous deployed version and running the properly mapped parameter of a new version will cause an unexpected error.
Basic walk-through of Hybrid Mode in SSAS Tabular. Tabular databases with Hybrid mode are designed in DirectQuery, but published with either of the two available hybrid Query Modes.
Performing “Process Full” on the Tabular Model database would incorrectly show “Process Recalc” instead via SQL Server Management Studio.
SSISDB.catalog.get_any_parameter_values is an alternative to SSISDB.catalog.get_parameter_values to get all Project and Package parameter values.
Julie Koesmarno’s first SQL Rally experience in Dallas
Wednesday Pre-Con SQL Rally Dallas 2012 Review
Slide deck for Direct Query vs Vertipaq modes in SSAS Tabular Model delivered at PASS DW/BI VC on May 3rd, 2012