Model with 2.8 Million Rows Not Auto-Refreshing, Truncated

Hi Moehimby ,

Thanks for reaching out to the Microsoft fabric community forum.

lbendlin 

Thanks for your prompt response

Moehimby 

To troubleshoot your Power BI model not fully refreshing during scheduled auto refresh, start by checking the refresh history in the Power BI Service compare the row count, duration, and dataset size between manual and scheduled runs to spot inconsistencies. Ensure there's no time-based logic like DateTime.LocalNow() in Power Query that could behave differently overnight, and double check that you're not unintentionally using incremental refresh or filters. Look into your on-prem gateway's CPU/memory usage and logs during the scheduled window in case it's silently throttling or timing out and consider restarting the gateway if it’s been running long. On the SQL side, check for long running ETL jobs or table loads that might still be in progress when the Power BI refresh kicks off, potentially leading to partial data loads if that’s the case, reschedule the refresh for later or use a view that only returns completed data. Also, verify that your SQL server isn’t terminating idle or long running queries during unattended hours. As a workaround, try wrapping your SQL logic in a stored procedure for better control, or simulate an early morning refresh in Power BI Desktop via Task Scheduler to see if the issue is specific to the service.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out  we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi