Forum Discussion
Report not working on service
- 1 year ago
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,
- Anonymous1 year ago
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
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