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
Category: SQL Server Analysis Services (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
Monitor On-Premises Data Gateways
Hi, The document available for download from the following link details an approach and considerations in monitoring the On-Premises Data Gateway (formerly Power BI Enterprise Gateway):
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).
Insight Quest 