Forum Discussion
powerbiexpert22
Impactful Individual
Impactful Individualimpact analysis
how can i perform impact analysis of table or column changes on around 500 power bi reports? around 3-4 tables, 10-15 columns needs to be renamed and 5-6 tables and columns needs to be removed from d...
lbendlin
Super User
Super UserYou can use Query Diagnostics (or SQL Server Profiler) to measure the impact.
Just recently we went through that exercise and found that an innocent single column rename transform can have a massive performance impact. We refactored it to swap ALL column names (even the ones that didn't change) which used a lot (A LOT) less resources.