topic Re: Connecting to a SQL Server Problems in Report Server

Connecting to a SQL Server Problems

Fools_Gold — Wed, 20 Nov 2024 22:19:48 GMT

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 refresh. I downloaded the free Power BI Gateway on the remote desktop and connected it to the service, but it has failed to connect to the SQL Server. I need this data updated on the service daily from the SQL Server at 6am. I cannot seem to get it working. Please advise.

Thank you,

Fools_Gold

Re: Connecting to a SQL Server Problems

Anonymous — Thu, 21 Nov 2024 05:20:32 GMT

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.