Question

How do you troubleshoot slow data model refreshes, especially when custom code (M or DAX) is involved?

I'm working on a project involving Power BI with a data model that has become increasingly slow to refresh. The model includes custom code written in M and DAX for data transformations and calculations. These customizations are essential to the analysis but appear to be affecting refresh times significantly.

Are there effective troubleshooting methods to pinpoint and resolve slow data refreshes in Power BI, especially when custom M or DAX code is involved? Any guidance on best practices or techniques to improve refresh performance would be highly appreciated!