Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Power Bi live connection

Can Partition in Azure analysis service help with improving performance in power bi with live connection ?

Super User
Super User

Yes, using partitioning in Azure Analysis Services can help improve performance in Power BI with a live connection. Partitioning divides a large data set into smaller, more manageable pieces, which can reduce query times and improve overall performance. By partitioning the data, Power BI can retrieve only the data that is relevant to a particular report or dashboard, which reduces the amount of data that must be processed, and thus, increases performance.

When using Power BI with a live connection to Azure Analysis Services, you can create partitions based on specific criteria such as date ranges, and configure incremental refreshes for the partitions to minimize the impact on performance. By using partitions and incremental refreshes, you can ensure that the data in your Power BI report is always up-to-date, while also improving performance.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors