Poor Index performance

[Keegan_Patton]

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! 

[AbbasG]

@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-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!