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.

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!