Last week I loaded up a U-Haul trailer and moved back to my home north of Boston to start my own data and analytics consulting
Tag: SSAS
Tabular Model Explorer for SSDT
SQL Server Data Tools (SSDT) 16.3 was made available last week and features a new Analysis Services Tabular Model Explorer for SSAS 2016 (1200 compatibility level) models.
Power BI Desktop Sample File from Monitor On-Premises Data Gateway
Hi, As mentioned in last week’s Power BI August Update to the On-Premises Data Gateway I’ve attached a sample of the Power BI Desktop file
Role-Based Default Filter Context for Power BI
Update (9/26/2017): An improved approach to dynamic (user role based) default filter context for Power BI is detailed in Chapter 8 of the Microsoft Power
SSAS Tabular 2016: Direct Query vs. In-Memory
Hi, With the release of SSAS 2016 last month I’ve been thinking about the enhanced Tabular Direct Query mode and the trade-offs with In-Memory mode (default).
Dynamic Filter Context Messaging for Power BI and SSAS Tabular
Summary A user’s filter selections and the filters applied at the report level (not visible to the user) can be computed via DAX functions and then exposed