Button depends on data set connection ?

[suvechha]

Hi there,

How to show the button as green when the dataset connected to the power bi is fine and refresh on scheduled event but show red when the data connection is not working ?

sample model attached.

https://1drv.ms/u/s!AhqwbtIVEKQ2bTEWC2x1Dug50Fs?e=P1cVNz

[v-deddai1-msft]

Hi @suvechha ,

I would suggest you to show last refresh time in your report:  https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[Greg_Deckler]

@suvechha - Is this Direct Query or Import mode?

[amitchandak]

@suvechha , you can create a card or MultiKPI and use conditional formatting to color background.

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values