Forum Discussion
Responsive ResidentReport not working on service
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
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