Forum Discussion
Helper IDashboards are blank when data is being refreshed
Hello, when a data pipelines is running to pull in new data from an on-prem SQL Server instance, our dashboards are completely blank until the data pipeline is done running. Any way to get around this or, at minumum, display a message on the dashboard that the data is being refreshed?
Here is what the pipeline looks like:
Hi christianunr ,
Thanks for reaching out to the Microsoft fabric community forum.
blopez11 ,
Thanks for your prompt response
christianunr Thanks for details explanation
Dashboards are momentarily losing access to the underlying model during refresh, which is why you're seeing a blank state. This behavior is particularly common when the refresh involves truncating and rewriting data in a Lakehouse table or Power BI dataset.Below are workarounds to fix the issueWhen your dashboards go blank during data refresh, one easy fix is to show a message like Data is refreshing using a separate table and DAX, so users know what’s happening. You could also try incremental refresh it only brings in new or changed data, so your dashboards stay mostly working. Another idea is to load new data into a temporary table first, check it, and only then replace the main table, which reduces the time your dashboard is unavailable. Lastly, if you want it super stable, set up your dataset to read from a view that only shows finished data that way, dashboards never read data while it’s still loading
For reference
Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn
Understand and optimize dataflows refresh - Power BI | Microsoft Learn
Using a staging database - Parallel Data Warehouse | Microsoft Learn
Best practices for designing and developing complex dataflows - Power Query | Microsoft Learn
Data sources for the Power BI service - Power BI | Microsoft Learn
Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Solved: Make Slicer a Variable to add to Power Automate - Microsoft Fabric Community
Solved: Incremental refreshing when table doesnt have a da... - Microsoft Fabric Community
If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.
We appreciate your engagement and thank you for being an active part of the community.
Best regards,
LakshmiNarayana.
3 Replies
blopez11Super User
That is interesting. Does the semantic model that sources your report use DirectQuery to the dataflow?
- christianunr
The source for the semantic model is a Lakehouse in Fabric. So the dasbhboard has a direct connection to the semantic model that way.
- v-lgarikapat
Community Support
Hi christianunr ,
Thanks for reaching out to the Microsoft fabric community forum.
blopez11 ,
Thanks for your prompt response
christianunr Thanks for details explanation
Dashboards are momentarily losing access to the underlying model during refresh, which is why you're seeing a blank state. This behavior is particularly common when the refresh involves truncating and rewriting data in a Lakehouse table or Power BI dataset.Below are workarounds to fix the issueWhen your dashboards go blank during data refresh, one easy fix is to show a message like Data is refreshing using a separate table and DAX, so users know what’s happening. You could also try incremental refresh it only brings in new or changed data, so your dashboards stay mostly working. Another idea is to load new data into a temporary table first, check it, and only then replace the main table, which reduces the time your dashboard is unavailable. Lastly, if you want it super stable, set up your dataset to read from a view that only shows finished data that way, dashboards never read data while it’s still loading
For reference
Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn
Understand and optimize dataflows refresh - Power BI | Microsoft Learn
Using a staging database - Parallel Data Warehouse | Microsoft Learn
Best practices for designing and developing complex dataflows - Power Query | Microsoft Learn
Data sources for the Power BI service - Power BI | Microsoft Learn
Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Solved: Make Slicer a Variable to add to Power Automate - Microsoft Fabric Community
Solved: Incremental refreshing when table doesnt have a da... - Microsoft Fabric Community
If this post helped resolve your issue, please consider the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.
We appreciate your engagement and thank you for being an active part of the community.
Best regards,
LakshmiNarayana.