Schedule Refresh- data from SAP Hana Database and a folder (Photographs)

[shareezsaleem]

Hi Experts,

I have one dataset (SAP Hana) and a folder (photographs), but the gateway is not working for the folder.

Can you please look in to the below error and guide me how to move forward?

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_DataSourceAccessError","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Supply Chain Staff Photographs

Attached picture fyr.

[v-zhangti · Accepted solution]

Hi, @shareezsaleem 

The error message suggests that there is an issue with the connection between the On-premises data gateway and the folder data source. This could be due to a number of reasons such as incorrect configuration settings, network connectivity issues, or incorrect credentials. You can try the following steps to troubleshoot the issue:

1. Check the configuration settings of the On-premises data gateway and ensure that they are correct. Make sure that the data source is configured correctly and that the credentials are valid.

2. Check the network connectivity between the On-premises data gateway and the folder data source. Ensure that the network connection is stable and there are no network issues.

3. Check the firewall settings on the On-premises data gateway and ensure that the required ports are open.

4. Check the logs for the On-premises data gateway and the folder data source for any error messages or warnings that may provide more information on the issue.

5. Restart the On-premises data gateway and try to connect again.

Note that the error message indicates that the issue is related to the data source access error. You can refer to the Power BI documentation for more information on this error and how to troubleshoot it.

For reference:

Troubleshoot gateways - Power BI | Microsoft Learn

Troubleshoot Power BI gateway (personal mode) - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.