Forum Discussion
Power BI DataModel refresh getting failed after 24-25GB Size with Power BI Premium Per User Capacity
- Anonymous1 year ago
Hi bilalrana
No, Power BI does not provide any interface to see live progress of an ongoing dataset refresh. In both Power BI Premium Per User (PPU) and Power BI Service generally, you can only see:
- That a refresh is in progress (rotating icon on the dataset),
- And the status (success or failure) once it finishes.
Unfortunately, there is no way to see real-time refresh progress, percentage complete, or which step is currently running. What you can do practically is, monitor the dataset’s Refresh History page to see when it started and when it finishes. Set up refresh failure alerts in Power BI Service, so you know immediately if something goes wrong (but again, no live progress). And final note is that Power BI simply doesn’t offer detailed refresh progress tracking only start/end status.
Please go through the Microsoft Official document for your reference.
Monitor Power BI data refresh - official docs
Data refresh in Power BI - Power BI | Microsoft Learn
If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.
Thank's,
Akhil.
Hi bilalrana
You're using Power BI Premium Per User, which allows up to 100 GB model size, but during refresh, it only gets about 25 GB of memory.
Your dataset grows to ~24 GB, and refresh fails because it's crossing that memory limit during processing, not after.
Move to Power BI Premium Capacity (P1 or higher)
- It gives more memory (up to 100 GB+ during refresh).
- Solves the throttling issue permanently.
If this report is business-critical and growing, Premium Capacity is the right long-term fix.
If you must stay on PPU for now, do these 3 things.
- Reduce Archive Period, change from 3 months to 1 or 2 months in incremental refresh, keeps the dataset size lighter.
- Remove Unused Columns, especially long text like ErrorMessage, every column adds memory load during refresh.
- Split Heavy Tables, create separate tables for historical and current data, only apply incremental refresh to current data.
________________________________________________________________________________________________________________________
If this response helps, consider marking it as “Accept as solution” and giving a “kudos” to assist other community members.
Regards,
Akhil.
Hi Anonymous
Thanks for the reply, I am currently using Power BI Premium Per User - Reserved which is SKU: PP3. Do we have any interface or anything which can tell us about the current progress of the refresh, as we get the status once the refresh is completed. It waste the time.