Forum Discussion
Keegan_Patton
Advocate II
Advocate IIPoor Index performance
Hello, I have been having some lackluster performance and poor refresh times for a model that is heavily used by stakeholders. I have added an Index to my largest table (6 million rows) that I use ...
AbbasG
Memorable Member
Memorable MemberKeegan_Patton Hi, do you need the entire 6Mn rows to support your analysis?? Setting up the incremental refresh would help you in a better performance.
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
- Keegan_Patton
Kind of, Incremental refresh could be a good solution. In this instance I was able to alter the amount pulled from the source into the dataset, it worked ok but I am curious if there are practices that should be followed when utilizing the index column feature in power query, especially when leveraging calculated indexes against them.
Thank you for your response!
