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.

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

Try these steps:

  • Use Incremental Refresh to load only new data.
  • Clean Power Query steps – remove extra columns and filters early.
  • Shift heavy data steps to Dataflows if possible.
  • Turn off Auto Date/Time for date columns.
  • Ask ETL team to reduce Excel file size if they can.
  • Set refresh time during non-busy hours.