Interactive Dashboard - Power Apps

Hi,   Just a brief background: We're using SQL as our main data source and it's connected to our on-prem via the gateway. As there is a security concerns, using our SQL on-prem, I'm using just our ...