Forum Discussion

3508026's avatar
3508026
Helper II
3 months ago
Solved

Performance Issues in Customer-Centric Power BI Model (Large Dataset)

Hi all, I’m building a customer-centric PBI dashboard using a large dataset for the 12 months (43,617,492 rows) already aggregated at customer-month level (not transactional). It includes multiple ...
Need Help
V-yubandi-msft's avatar
V-yubandi-msft
Community Support
3 months ago

Hi 3508026 ,

Thank you for contacting the Microsoft Fabric Community. When handling customer level KPIs with a large dataset, you may experience performance issues due to the data model or DAX logic. Microsoft recommends using a star schema, simplifying your measures, and applying aggregation tables or incremental refresh to help reduce workload. CU spikes and query conflicts are common in shared capacity, so for more consistent performance, Premium or Fabric capacity provides dedicated resources.

For more information, please refer to the attached document.

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn
Understand star schema and the importance for Power BI - Power BI | Microsoft Learn
What is Power BI Premium? - Microsoft Fabric | Microsoft Learn

I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.

 

 

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    2 months ago

    Hi 3508026 ,

    If you get a chance, please review the response  and let us know if it aligns with your expectations. Should you need any additional details or clarification, feel free to let us know.

     

    Regards,
    Yugandhar.