Scheduled Refresh

[cmelgar]

Hi,

I have Power BI desktop and have downloaded/setup the gateway to do scheduled Refresh of the data set for the Dashboard I publish. However, the refresh fails. I tried to add the connection to the gateway and I get this error.

"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)"

Please advise.

[v-ssriganesh]

Hi @cmelgar,

May I ask if you have resolved this issue? If so, please mark it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[cmelgar]

Hi, I have not fixed the issue yet. I am still having configuration issues it seems.

[v-ssriganesh · Accepted solution]

Hi @cmelgar,
Thanks for your update.

Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your issue or provide a solution that isn't immediately obvious. 

Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.

[v-ssriganesh]

Hi @cmelgar,

Could you please confirm if the issue has been resolved after raising a support case? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.

Thank you for your understanding and assistance.

[cmelgar]

No, not yet. Thank you for following up. 

[v-ssriganesh]

Hi @cmelgar,
Thank you for update.

If you continue to experience issues, please provide more details about your setup, such as the exact error message and any relevant configurations. This will help us better understand the problem and offer more targeted assistance.

[v-ssriganesh]

Hello @cmelgar,
Thank you for reaching out to the Microsoft Fabric Community forum.

After thoroughly reviewing the details you provided, here are some steps you can take to resolve this issue:

• Check that the connection string used in Power BI Desktop matches the one configured in the gateway. The server name should be in the format "Servername,portnumber".
• Make sure that the on-premises data gateway is properly set up and configured. The gateway acts as a bridge between the Power BI service and the on-premises data source.
• Review the gateway logs for any specific error messages or clues that might indicate what is causing the connection issue.

For your reference:
Solved: Cannot schedule refresh dataset from SQL Server be... - Microsoft Fabric Community
Solved: Refreshing data from SQL Server - Microsoft Fabric Community

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[lbendlin]

use a comma, not a colon, for the port divider

Not 

server.domain.net:1433

but 

server.domain.net,1433

(default ports can be omitted, only shown as an example)