SQL Server Conection on app.powerbi.com

Hi, Qzzz 

I am glad to help you.

What connection are you using to connect to SQL Server, Import? or DirectQuery? 

There are two types of On-premises data gateway.

After looking at your pictures, I see that you are actually using a personal gateway, not a standard gateway as you mentioned in the other picture for online status? 

Standard gateway: 

Perhaps you could try logging into the personal gateway, then checking again that the personal gateway is online, and then testing again to see if it refreshes properly. 

Here are some official documentations, hope they help: 

What is an on-premises data gateway? | Microsoft Learn 

Use a personal gateway in Power BI - Power BI | Microsoft Learn 

Manage a SQL Server data source - Power BI | Microsoft Learn 

I hope this option above will help you. If you still have problems, please contact us with your feedback and the steps you took. Please remember to hide your personal information! We will do our best to solve your problem! 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.