Forum Discussion
Issues with On-premise Gateway - Received error payload from gateway service with ID 328575
Hi v-saisrao-msft ,
Apologies for the delayed response.
The issue has now been resolved; however, we did not implement any of the suggested solutions from the support ticket or related discussions. None of the recommendations provided led directly to the resolution.
Based on our observations, the issue appears to have resolved itself over time. We suspect that updates to the On-Premises Data Gateway in newer versions may have addressed the underlying problem.
We appreciate everyone's time and effort in assisting with this matter
Best regards.
Community SupportHi Phoenix529,
Thank you for reaching out to the Microsoft Fabric Forum Community.
From your description, it appears that although you're On-Premises Data Gateway is online, the specific connections using the gateway are displaying as offline, even though data refreshes are successful.
- Go to Manage Gateways in Power BI Service, select SQL_SERVER, and ensure all data sources are mapped to the new service account with updated credentials. Incorrect mappings may cause connection issues even if the gateway appears online.
- If the issue continues, reinstall the On-Premises Data Gateway using the service account to ensure correct registration and permissions. After reinstalling, reconfigure the data sources and test the connection.
Please refer to the solved links for more details:
Solved: Received error payload from gateway - Microsoft Fabric Community
Solved: Received error payload from gateway service with I... - Microsoft Fabric Community
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi v-saisrao-msft ,
I tried updating the credentials in the connections and it gives me this error.
I have already re-installed the gateway once but that does not seem to solve the issue.
Tried it with all the available authentication modes as well (Except Service Principal)
I have also accessed SQL server using these service account credentials and it seemed to have worked fine.
Unsure what needs to be done.
- v-saisrao-msft
Hi Phoenix529,
Since you are encountering this issue repeatedly, please raise a support ticket so that one of the engineers can assist you.
Below is the link to raise the support ticket.
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you.
Hi v-saisrao-msft ,
The ticket has already been raised but by someone else on our behalf.
Fabric Support was asking us to reboot/restart our SQL Server (Which is not feasible). We have inhouse applications running on the 2012 version of SQL, which would be a huge pain to update thus, not feasible either.They are still looking into the ticket with no resolution yet, which is why I thought of trying the forum to see if someone else is facing similar issues as well.
PS: There are no refresh failures, just that when we refresh the connectors to that gateway, they show as offline with the above error.
It ideally should not be showing any error as it works. It seems to me that there could be some issue with the new versions of the On-Premise gateway or with the older version of SQL 2012 but I am just speculating here.
Thank you.
- v-saisrao-msft
Hi Phoenix529,
Thanks for the update. Since a support ticket is already raised, I recommend waiting for Microsoft Fabric Support to resolve the issue, as they can provide a targeted solution, especially considering the potential compatibility concerns with SQL Server 2012.
Once the issue is resolved, it would be great if you could share the outcome here, as it will help other community members.
Thank you.