SQL Server Conection on app.powerbi.com

[Qzzz]

I have created a power BI reports with data source from sql server in it and uploaded it to my workspace. I want to refresh the semantik model to get the data updated by clicking the refresh button but it shows me wrong 

So i take a look at the data souce setting it shows the sql connection is offline, how can i set it correctly ? My Sql Server is using windows authentication, but obviously i can not save the setting with the window authentication option

Local Gateway is online

[Anonymous · Accepted solution]

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.

[Qzzz]

Hi @Anonymous ,

thanks for your reply!  After changing to personal gateway, the connection is online now !

One more question: Can i set my sql connection to a standard gateway if i am using a standard gateway ?It seems like it does not allow me to change it, the data source was generated automatically after i upload my power BI file.

[GilbertQ]

Hi @Qzzz 

Can you make sure that you have got the same details in the Gateway as in your SQL Server source?

[Qzzz]

Hi @GilbertQ ,

thanks for your reply. I found that i am not using the same gateway mode.