An important part of any data source system is monitoring when the admins can check the health of the system and be aware of consumption rate. In Azure Analysis Service…
Author: Ali Sharifi

Analysing Customer Sales by RANKX() and What If Parameters
In this post I am going to show how to use a combination of RANKX() function and Power BI What-If parameters to analyse the customers’ monthly sales and find out…

Power BI Design Modes - Part 3 - Live Connection
Live Connection In this mode the model components and definitions such as tables,column’s attributes and datatypes, relationships, hierarchies, calculated tables and calculated columns are implemented in a semantic SSAS model…

Power BI Design Modes - Part 2 - Composite mode and Aggregation
Composite mode In composite model both import and direct query data can be combined in one Power BI model. Imagine you want to create a report of sales and budget …

Power BI Design Modes - Part 1: Import & Direct Query
Introduction Before start of developing Power BI reports, the important step is choosing the right architecture design from the multiple available models that suits best for your organization and allows…
Dynamic Partitioning in SSAS Tabular Using M Query
One feature that makes SSAS Tabular a good choice for handling the large datasets is table partitioning.Table partitioning allows a big table be split into multiple partitions based on values…