Forum Discussion

Yggdrasill's avatar
Yggdrasill
Icon for Responsive Resident rankResponsive Resident
8 years ago

Prevent visuals going blank after scheduled refresh

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 ?

Tutorial Requests

2 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      Yggdrasill
      Icon for Responsive Resident rankResponsive Resident
      8 years ago

      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 !