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
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 