Nowadays many systems such as cloud services and IOT devices that work globally prefer to use the UTC time zone to be consistent across different countries. When it comes to…
Category: Power BI

Monitoring Azure SSAS Performance by Power BI
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…

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…