Aggregations and Time Series calculations in Power BI

I have received a couple of questions about Aggregations in Power BI and whether they can be used to cover time series calculations such as Year to Date, Quarter to Date, and Month To Date. The answer is yes. Since time series calculations break down into calculations over a series of days, an aggregation table … Continue reading Aggregations and Time Series calculations in Power BI

Aggregation Precedence in Power BI: How does Power BI choose between candidate aggregation tables with the same Precedence?

Precedence is one of the aggregation properties that you can define on an aggregation table in Power BI. In a model with multiple aggregation tables, you can use Precedence to define the order in which aggregation tables will be considered by Power BI to answer queries. The higher the Precedence number, the sooner the aggregation … Continue reading Aggregation Precedence in Power BI: How does Power BI choose between candidate aggregation tables with the same Precedence?

Aggregations in Power BI

Aggregations became generally available in Power BI in July 2019. Aggregations are a modeling optimization technique that can improve user experience when dealing with large datasets. Combined with Power BI composite models, they make it possible to analyze big datasets efficiently by allowing high level analytical queries to be answered from memory while sending more … Continue reading Aggregations in Power BI

A simple Power BI report to help you choose which PASS Summit 2019 activities to attend.

PASS Summit 2019 is about to start. There are many social ane educational events during this week. You can find a complete list here. It is somewhat difficult to get an overall look of events per day. I put together this simple PBI report to get a list of events by day/time/sponsor. Here is a … Continue reading A simple Power BI report to help you choose which PASS Summit 2019 activities to attend.

Another look at PASS Summit 2019 sessions using Power BI Desktop and “Get Data From Web”

Last week I published a post on how I used Power BI Desktop to import PASS Summit 2019 session schedule and build a few reports for myself to help me sort my sessions of interest by day/time/room and decide which ones to attend. In that post, I had initially tried to import the schedule with … Continue reading Another look at PASS Summit 2019 sessions using Power BI Desktop and “Get Data From Web”

PASS Summit 2019 sessions review: What sessions to attend?

PASS Summit is only 2 weeks away. It is time to review the sessions and decide which ones to attend. You can find the published schedule here. This is a great at-a-glance look. There is also a searchable version of the schedule published here. You can use this one to search by keyword or track … Continue reading PASS Summit 2019 sessions review: What sessions to attend?

Connecting live from Power BI Desktop to SSAS generates this error: The Server you’re trying to connect to doesn’t have any models or you don’t have permissions to access them.

I recently ran into an error while connecting live from Power BI Desktop to a SSAS server. Everything was on-premises.There was no cloud component involved. I had full admin rights to the SSAS server and could see all databases and models from SSMS and other tools but was getting this error from PBI Desktop. The … Continue reading Connecting live from Power BI Desktop to SSAS generates this error: The Server you’re trying to connect to doesn’t have any models or you don’t have permissions to access them.

Analysis Services Telemetry: What information does SSAS submit? and how has it changed in SSAS 2019?

Starting with SSAS 2016, SSAS sends some usage information back to Microsoft by default. This behavior is similar to how Telemetry works in SQL Server and SSMS and can be turned off. The first time I noticed SSAS Telemetry, it was while I was checking the SSAS Administrators group membership on a server and saw … Continue reading Analysis Services Telemetry: What information does SSAS submit? and how has it changed in SSAS 2019?

New QueryMemoryLimit setting in SSAS 2019

SSAS 2019 has a very useful new memory setting called QueryMemoryLimit that can be found under Advanced Prperties. While the online documentation says this setting is only available in Azure AS, I can see it in SSAS 2019 CTP. The purpose of this setting is limit the amount of memory any single query can take. … Continue reading New QueryMemoryLimit setting in SSAS 2019