Power Bi live connection

[SumanBindu]

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

[MAwwad]

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.