This is a continuation of the presidential election live dashboard. This project also uses DirectQuery mode to connect to an Azure SQL database. Because it is live TV reporting, I created a Powerapp which feeds incoming election results to the database and that in turn populates the dashboard via refresh set at every 30 seconds.