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 par...
Tutorial Requests
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 !