Data source error, without actual error message

[Anonymous]

I get this error:

I am the gateway administrator myself... How can I troubleshoot this?

The error makes no sense, I see nothing wrong in the gateway!!!

All the details:

How can I troubleshoot this? Is there any log anywhere with more details?

[v-saisrao-msft]

Hi @Anonymous,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @Anonymous,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @Anonymous,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-saisrao-msft]

Hi @Anonymous 

Thank you for reaching out to the Microsoft Forum community.

The response provided by @rajendraongole1  was indeed correct. Here are troubleshoot steps which could rectify your issue:

• Please ensure the gateway is operational and accessible. Restart the Windows service for the gateway to update its status.
• Please ensure that your firewall is not blocking the necessary ports for the gateway. You can run a network ports test to verify connectivity. Additionally, check if any proxy settings might be causing issues

Additionally, could you please provide more details about the issue? This will assist in identifying and resolving the error more effectively.

Please refer to the documentation below for further details:

Troubleshoot gateways - Power BI | Microsoft Learn

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. 

[rajendraongole1 · Accepted solution]

Hi @Anonymous  - To collect logs

Go to Settings > Admin Portal > Audit logs.
Review logs for gateway errors or access-related issues.

and gateway logs you can collecct below path:

C:\Users\<GatewayServiceAccount>\AppData\Local\Microsoft\On-premises data gateway\Gateway*.log

could you provide additional details about the data source type (e.g., SQL Server, Excel, etc.) and whether the issue occurs with other data sources