Perhaps the most important decisions business intelligence professionals make is determining which technologies to learn and to what extent or depth should they grow their
Category: Analysis Services
Analysis Services vs Power BI Premium Model Feature Matrix
Over two years ago I published a blog and document with a feature matrix comparing modeling features of the different releases of Analysis Services Tabular
Analysis Services DMVs in SSMS
In the previous post we looked at using Registered Servers in SQL Server Management Studio (SSMS) to quickly and easily connect to Power BI Premium
Power BI Premium Registered Servers
XMLA endpoint connectivity for Power BI Premium represents one the most significant steps in Power BI becoming an enterprise BI platform as it exposes Power
Analysis Services Monitoring Report v1.0
In addition to the TMSCHEMA DMVs utilized by the Tabular Model Schema Reference v1.1, several of the ‘DISCOVER’ DMVs such as DISCOVER_CONNECTIONS can be useful
Models on a String
Let’s say you’re a senior BI developer responsible for several Analysis Services Tabular instances (Dev, Test, Prod), each of which may host multiple databases. Each
Insight Quest 