Performance problem in power bi

Hi holgergubbels ,

Thank you for reaching out to the Microsoft Fabric Community. 

1. Consider moving part of your ETL and business logic (such as churn classification and MRR deltas) upstream into Power BI Dataflows or Fabric Data Pipelines.

Precompute metrics in Power Query (M).

Enhance report responsiveness by loading only aggregated data.

Creating a dataflow - Power BI | Microsoft Learn

Ingest data into your Warehouse using data pipelines - Microsoft Fabric | Microsoft Learn

2. For highly customized logic and scalability, consider moving calculations to a Python Notebook exporting the results as a table to a Data Lake or SQL database, and connecting to it in Power BI.

Develop, execute, and manage notebooks - Microsoft Fabric | Microsoft Learn

3. As your data grows over time, consider using incremental refresh to reduce the load on large date-based tables and aggregation tables to speed up visual rendering.

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

User-defined aggregations - Power BI | Microsoft Learn

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.