Home » SSAS

Fabric Persona(s)

With the release of Fabric, the Power BI (Fabric) portal has been updated. In order for a better look and feel, Microsoft has decided to split the areas into Personas. That was so all the artifacts available will…

Read More »

Power BI Row Level Security

Yes, there is row level security in Power BI datasets. The same functionality in Analysis Service is in Power BI through Roles. There is a difference because once the dataset is deployed to the Power BI Service (app.powerbi.com),…

Read More »

Power BI Summit April 19-32 (Virtual)

The next virtual summit coming up is April 19-23, 2021. It is called Power BI Summit and is hosted by Radacad. There are MVPs, Microsoft employees and Power BI experts from all around the world sharing almost every…

Read More »

SQL Server Analysis Services 2019–New Features

The biggest news as far as I can see about SSAS 2019 is Calculation Groups. This is the long awaited feature, define calculated measures, used by many in Multidimensional Cubes. The new ‘table’ contains the Time intelligence (among…

Read More »

Power BI Read Only XMLA endpoints–Public Preview Premium Users

Microsoft announced the Public Preview in Premium Edition for XMLA endpoints.  What does that mean? Not too long from now, you will be able to connect to Data Sets created in Power BI unloaded to the service with…

Read More »

OLAP Acronym returns

After reviewing Azure Data Architecture Guide, I noticed the label Online Analytical Database (OLAP) referenced as the description for Azure Analysis Services. I will call Azure Analysis Services AAS from here on. The AAS is using tabular models…

Read More »

Analysis Services Series on SQLShack

Please visit SQLShack.com for new articles on many facets of SQL Server. I have been trying my best to document how to create SQL Server Analysis Service databases with Multidimensional Cubes as well as Tabular Models. The start…

Read More »

Live! 360–Speaking at SQL Server Live Orlando 2016

If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different areas of IT (including SQL Server) with some of the great experts presenting sessions for 5 days. The…

Read More »

Why use a Date Dimension Table in a Data Warehouse

In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you are using the Kimball Dimensional Modeling method. In the beginning of Dimensional Modeling, it was called a Time…

Read More »

Analysis Services: Solving Hierarchy Errors of Uniqueness

Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice or group the measures by dimension attributes helps with a quick analysis and flexible/interactive reporting. Configuring these attributes…

Read More »