Forum Discussion

Fools_Gold's avatar
Fools_Gold
Helper I
1 year ago
Solved

Connecting to a SQL Server Problems

Hello, I have a Power BI Desktop downloaded on a remote desktop. I have on this Power BI Desktop a report that is connected to a SQL Server. When I publish the report to Power BI Service it fails to...
Asking help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, Fools_Gold 

    Please follow the screenshot below to configure a SQL Server gateway connection:

    Then set up this gateway connection for the semantic model:

    Then set up a new scheduled refresh. Make sure that you're using the On-premises Data Gateway Standard Edition. You can see it on the following page:

     

     

     

    Best Regards

    Jianpeng Li

    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
1 year ago

Hi, Fools_Gold 

Please follow the screenshot below to configure a SQL Server gateway connection:

Then set up this gateway connection for the semantic model:

Then set up a new scheduled refresh. Make sure that you're using the On-premises Data Gateway Standard Edition. You can see it on the following page:

 

 

 

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.