Forum Discussion
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.
Community SupportHi holgergubbels ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution we provided for your issue worked for you or let us know if you need any further assistance?
Your feedback is important to us, Looking forward to your response.