Index Performance

[PowerBI123456]

Hi. I have a table that has millions of rows of user activity on accounts and the table has an index column which helps me determine the chronologically of specific activities in my measures. However, the performance is sucky because the size of the table. Are there any best practices on how to deal with that? Unfortuantely, I can't show any of the data because its confidential, but just wanted to see any general best practices. Thanks!

[PhilipTreacy · Accepted solution]

Hi @PowerBI123456 

Depends on what you are doing

Check these for reference

Speed/Performance aspects – The BIccountant

Watch Your Steps! Power Query Performance Caution for Power BI - RADACAD

Power Query Performance Improvements - Test Drive - Excelerator BI

Ken Puls Explains Why Excel's Power Query Refresh Speeds Suck (powerpivotpro.com)

Regards

Phil