Power BI dashboard refreshes partially

[RashidSaba]

Hi,

I have an import mode setup Power Bi dashbaord. SQL tables and excels on import mode. Tables maintain daily acticity data of empoyees across globe. Now, on service the dashbaord refresh in short span of time and loads partial data (scheduled refresh). Only way to find this is go to refresh history ,check the time and do a manual refresh...again. Any way to resolve this?
I understand - data not laoding from SQL might be an issue but it was working fine till October, 2024
How do I resolve this, how do I load all the data in the dashboard.

Appreciate any help

[v-kpoloju-msft]

Hi @RashidSaba,

Thank you for reaching out to the Microsoft Fabric Community Forum.

We sincerely apologize for the inconvenience. After reviewing the issue of Power BI dashboard refreshes being partial, here are a few steps that may help resolve the issue.

• Please determine if partial loads are occurring at specific times or for tables. Additionally, check for warnings or errors related to timeouts, resource limits, or query failures.
• Verify if the queries are taking longer than expected. Utilize SQL Profiler or Extended Events to monitor execution. Ensure that files stored on SharePoint or OneDrive are fully synced before refreshing.
• To improve performance in Power BI, increase the Command Timeout for large queries. Enable Batch Processing in SQL queries to prevent incomplete loads. For large tables, consider using Incremental Refresh to reduce refresh time strain.
• When using a gateway, please ensure it has sufficient cpu or memory resources. To prevent overlapping refreshes, stagger refresh schedules if multiple datasets are being refreshed simultaneously. For those using Premium capacity, kindly review the background refresh limitations.
• If a manual refresh loads all the data correctly, the issue could be related to the duration limits of the scheduled refresh or the prioritization of data load.

Also, please go through the below provided following links for more information:
Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn
Data refresh in Power BI - Power BI | Microsoft Learn
Troubleshoot refresh scenarios - Power BI | Microsoft  Learn

If this post helps, please give us Kudos and consider accepting it as a solution to help other members find it more quickly.

Thank you.

[v-kpoloju-msft]

Hi @RashidSaba,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-kpoloju-msft]

Hi @RashidSaba,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-kpoloju-msft]

Hi @RashidSaba,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[R1k91 · Accepted solution]

Is it SQL Server your source? Are you able to open a Profiler or an XE session to catch the events on the SQL side?

you could check the queries that are pushed to the source if they're correct and executed successfully.

has your semantic model incremental refresh enabled?