Report not working on service

[ROG]

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..... 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!

[ibarrau · Accepted solution]

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,

[Anonymous]

Hi @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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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

[ibarrau · Accepted solution]

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,