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…
Category: SSAS
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…
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…
Date Custom Format in SSAS Tabular
Some days ago I been asked by a BI developer about how to set format of SSAS Tabular date column to dd/mm/yyyy in SSDT(Sql Server Data Tools). If you…
How to manage ambiguous relationship in Power BI
One issue you may have faced during modeling in Power BI and SSAS tabular is getting error on creating relationship between 2 tables and when this new relationship makes a…