No matter what, when the Power BI on-premises gateways are not working as expected, data will not refresh, and direct query queries will not succeed. It's almost simple to create a monitoring solution using Microsoft Fabric
This is not only how I use a SQL Server instance with my new MacBook Pro setup, but this is also how to integrate a remote Azure SQL virtual machine into your Power BI tenant.