Forum Discussion
Report not working on service
My report works fine on desktop, bit I'm getting the error below on service.
Unable to connect to the SQL Server data source 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) . Either the data source is inaccessible, a network connection could not be established, or the data source credentials are invalid. Please verify the data source configuration on the Dataset settings page and contact a data source administrator to troubleshoot this issue.
Thanks!
Hi. Is this an onpremise SQL Server? or cloud one? the error says there is an issue getting data. The PowerBi Service can't get the data. This can be because you have a cloud SQL Server with wrong credentials at service (you can edit them in the semantic model settings) or you need to use an onpremise data gateway (add the sql server source and credentials as configuration). There are many posts explaining how to set up the gateway for the first time in case of an on premise SQL Server.
I hope that helps,
Hi ROG,
Thank you for reaching out to Microsoft Fabric Community Forum.
The error suggests a connection issue between the Power BI Service and your SQL Server.
Ensure that the SQL Server credentials in the Power BI Service are correct, and verify that the On-Premises Data Gateway, if used, is properly installed and configured.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to give "Kudos"
Regards,
Vinay Pabbu
5 Replies
Hi. Is this an onpremise SQL Server? or cloud one? the error says there is an issue getting data. The PowerBi Service can't get the data. This can be because you have a cloud SQL Server with wrong credentials at service (you can edit them in the semantic model settings) or you need to use an onpremise data gateway (add the sql server source and credentials as configuration). There are many posts explaining how to set up the gateway for the first time in case of an on premise SQL Server.
I hope that helps,
Hi ROG,
Thank you for reaching out to Microsoft Fabric Community Forum.
The error suggests a connection issue between the Power BI Service and your SQL Server.
Ensure that the SQL Server credentials in the Power BI Service are correct, and verify that the On-Premises Data Gateway, if used, is properly installed and configured.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to give "Kudos"
Regards,
Vinay PabbuHi ROG,
we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Vinay Pabbu
Hi ROG,
May I ask if you have gotten this issue resolved?If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Regards,
Vinay Pabbu
Hi ROG,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Vinay Pabbu