Tag: Performance Optimizations

Exploring Automatic Partition Maintenance in Power BI datasets with Incremental Refresh, using EffectiveDate parameter

During one of my presentations on Incremental Refresh (IR) in Power BI, someone asked what happens during a Power BI automatic partition maintenance window when Power BI has an opportunity to merge smaller partitions into larger ones. Does Power BI use the data that is already imported into Power BI for the smaller partitions and … Continue reading Exploring Automatic Partition Maintenance in Power BI datasets with Incremental Refresh, using EffectiveDate parameter

A look at automatic partition maintenance by Power BI Service for datasets with Incremental Refresh

In this post, I am going to look at automatic partition maintenance by Power BI service for datasets with Incremental Refresh and focus on what happens to the partitions as time goes by. To do this, I am going to set up a couple of sample datasets with different Incremental Refresh (IR) policies with and … Continue reading A look at automatic partition maintenance by Power BI Service for datasets with Incremental Refresh

Hybrid Tables (In Power BI) Q&A

Are Hybrid Tables tied to a developer license type? No. Incremental Refresh and Hybrid tables are tied to workspace (dataset) type. They are set up in Power BI Desktop. A developer must have Pro or Premium Per User (PPU) license to publish the report to the service. See the next two paragraphs for workspace (dataset) … Continue reading Hybrid Tables (In Power BI) Q&A

Aggregations and Time Series calculations in Power BI

I have received a couple of questions about Aggregations in Power BI and whether they can be used to cover time series calculations such as Year to Date, Quarter to Date, and Month To Date. The answer is yes. Since time series calculations break down into calculations over a series of days, an aggregation table … Continue reading Aggregations and Time Series calculations in Power BI

Aggregations in Power BI

Aggregations became generally available in Power BI in July 2019. Aggregations are a modeling optimization technique that can improve user experience when dealing with large datasets. Combined with Power BI composite models, they make it possible to analyze big datasets efficiently by allowing high level analytical queries to be answered from memory while sending more … Continue reading Aggregations in Power BI