Connecting to a SQL Server Problems

[Fools_Gold]

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

[Fools_Gold]

Thank you @arvindsingh802 and @Anonymous. I got it resolved.

[arvindsingh802]

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.

[Fools_Gold · Accepted solution]

Resolution:

[Anonymous]

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.

[arvindsingh802]

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