Prevent visuals going blank after scheduled refresh

[Yggdrasill]

Hi PBI community. Wasn't sure if this belongs in the service section or this one but here goes.

I have a large Power BI data model. The largest data source is from an azure SQL database. That particular database goes blank whenever a full refresh is scheduled where we collect data from multiple sources.

At the same time a scheduled refresh from the SQL database and to the service will grab empty tables. The result being empty visuals, graphs or matrixes. 

My question is: Is it possible to stop the scheduled refresh via gateway if it will read one or more empty table ?

[v-yulgu-msft]

Hi @Yggdrasill,

Per my knowledge, it is not possible to disable/enable scheduled refresh conditionally depend on empty tables from data source.

Regards,

Yuliana Gu

[Yggdrasill]

Well then.

What I did was that I created a tile that simply counts the rows in the largest fact table. If the outcome is 0 or blank I will be notified via email.

If anyone has a better solution, please share !