topic Re: Connecting to a SQL Server Problems in Service

Connecting to a SQL Server Problems

Fools_Gold — Wed, 20 Nov 2024 22:39:34 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

arvindsingh802 — Thu, 21 Nov 2024 05:12:16 GMT

It could be possible the reuired ports are not open to access the SQL server form your remote desktop, where the gateway is installed or the remote server was offline when the refresh was scheduled
Do share the error message to help you better

Re: Connecting to a SQL Server Problems

Anonymous — Thu, 21 Nov 2024 05:24:34 GMT

Hi Fools_Gold ,

You can refer to this document to refresh the data in your local SQL Server database.

Tutorial: Connect to on-premises data in SQL Server - Power BI | Microsoft Learn

In addition, check for any errors in the gateway connection and data source credentials in the semantic model settings for this report.

Best Regards,
Dengliang Li

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

Re: Connecting to a SQL Server Problems

Fools_Gold — Fri, 22 Nov 2024 22:20:48 GMT

Thank you arvindsingh802 and Anonymous. I got it resolved.

Re: Connecting to a SQL Server Problems

arvindsingh802 — Mon, 25 Nov 2024 05:29:54 GMT

That's great, can you share the resolution to help others in community, also the suggestion shared by Anonymous or me helped, please mark that as solution.

Re: Connecting to a SQL Server Problems

Fools_Gold — Mon, 25 Nov 2024 14:58:45 GMT

Resolution: