"Aggregations" is one of the biggest features introduced to the Power BI in terms of enriching the interactive analytics over Big Data . Before Power BI team introduce this feature, It was not possible to analyze and visualize data where the large tables contains millions or even billions of records. I’m writing this post in a way you can use as a tutorial to read, understand and tryout by yourself -- How to implement Aggregations in Power BI . Before starting to read this, please download the Demo content from here . This will contain three files. AggsDemo.bak : Demo database backup build on SQL Server 2017 Create Aggs Tables.sql : SQL Query to create aggregation tables AggsDemo.pbix : Power BI demo file which implemented aggregations in this post Connection Types - Direct Query vs Import Even before we move to Aggregations, I think it is important to have an understanding of connection types in Power BI. Predominantly there are two c...
A journey towards the AI space