Forum Discussion

Qzzz's avatar
Qzzz
New Member
2 years ago
Solved

SQL Server Conection on app.powerbi.com

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 b...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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's avatar
    Qzzz
    New Member
    2 years ago

    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.