Forum Discussion
Scheduled Refresh
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.
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 LearnIf 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.
8 Replies
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)
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.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.
No, not yet. Thank you for following up.
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.
Hi, I have not fixed the issue yet. I am still having configuration issues it seems.
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 LearnIf 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.
