Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Find articles, guides, information and community news

Most Recent
Kumail
Post Prodigy
Post Prodigy

Automatic aggregations will help unlock huge datasets for interactive analysis, enhance query performance, and enable interactive analysis over big data.

Read more...

Anonymous
Not applicable

With the rollout of Aggregated Tables in PowerBI, we gained some much-anticipated functionality to improve performance large datasets.  The problem I’ve run into is that aggregation is very subjective and can still result in datasets that are still too large for publishing to PowerBI cloud. Additionally, it can take a frustrating amount of time for those aggregate tables to import into a developer’s local instance of PowerBI Desktop.  In this article, I’d like to show you how you can leverage PowerBI's Aggregation, functionality, Direct Query and a simple calculation group to partition an aggregated table by Current (import) and Archive (Direct Query) periods. This is one way to work with aggregated tables within the constraints of your licensed capacity and budget. There are definitely caveots to this approach that I will cover along the way.

Read more...

Dianapo
Microsoft Employee
Microsoft Employee

This multi-part tutorial blog is geared to help BI Analysts create versatile Scorecards with KPIs as well as to facilitate the business reporting transition from Excel, SSRS or other apps to Power BI Desktop.

 

In this initial installment, I will illustrate how to include more than one aggregation and custom formatting in the Power BI Desktop Matrix. All tutorial steps below require acquaintance with how Power BI Desktop works as well as basic to advanced DAX skills.

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.