Forum Discussion

Ynr225's avatar
Ynr225
Icon for Helper II rankHelper II
1 year ago
Solved

Dataset refresh taking long time to complete the refresh

Hello All,   One of the user has created the Power BI report in Desktop using multiple data sources as Excel file(8 Excel files), Power platform dataflows, SQL server, web data sources and publishe...
Show and Tell
  • GilbertQ's avatar
    GilbertQ
    1 year ago

    Hi Ynr225 

     

    I would recommend looking at the star schema and semantic model as this is contributing to you going over your interactive capacity usage.

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
1 year ago

Hi Ynr225 

 

I would just like to know when you mentioned it is degrading your capacity. Is this degrading your capacity for the refresh? If so, the refreshes are. sent to be smoothed over 24 hours, so that should not be a big impact. Possibly could it be that when users are using the report using high capacity usage, if that is the case, then you need to make sure that your model is designed with a star skimmer in mind and using optimized DAX measures to reduce the capacity consumption.

Ynr225's avatar
Ynr225
Icon for Helper II rankHelper II
1 year ago

Hello GilbertQ ,

 

Thanks for the reply, yes the capacity is degrading with the refresh. Due to this daily %Base capacity is consuming 18% and at the same time some others are using their reports with high capacity usage. Because of this our capacity is reaching 150%. So we want to reduce the refresh time without changing the existing data sources in Power BI report.

 
  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    1 year ago

    Hi Ynr225 

     

    I would recommend looking at the star schema and semantic model as this is contributing to you going over your interactive capacity usage.

    • v-aatheeque's avatar
      v-aatheeque
      Icon for Community Support rankCommunity Support
      1 year ago

      Hi Ynr225 ,
       If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.

      If you have any further questions, feel free to reach out.
      Thank you for being a valued member of the Microsoft Fabric Community Forum!