This mirrors my experience. I am the accounting manager responsible for updating these dashboards at my saas employer. Troubleshooting powerbi errors during month-end close is the most stress-inducing thing. And whenever management wants a dashboard edit, we have to somehow know that the spreadsheets being fed the powerbi cloud data will also change. Maybe an extra row inserted into the pivot table of ARR by product. Now any formulas directly referencing the cells rather than using XLOOKUP are pointing to the wrong product category. I was chewed out hard for that one a few days ago even though IT made that change, since it updated our report after review. TLDR: Powerbi suck, use a data warehouse and SQL for data transformations.