Forum Discussion
Poor 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 to create calculated index columns in other tables for reference. Has anyone found themselves needing to index a table but found ways to make it more effecient?
thank you!
2 Replies
Keegan_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-overviewKind 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!
