Dataset refresh failure SAP datasphere as a data source

[Ynr225]

Hello All,

Using SAP DWC (.mez) custom connector as shown in below screenshot1, we are able to connect SAP Datasphere in Power BI desktop by taking SAP datasphere - Data (1.80) custom as a data source given below in screenshot2 and created a report in it. Later published it in Power service for set up automatic refreshes, we have created gateway connection successfully as shown in screenshot3

The gateway connection status is showing online but when manually refresh the dataset we are receiving below error.

Can anyone please help me to troubleshoot the dataset refresh issue? Thanks in advance!

[v-zhengdxu-msft]

Hi @Ynr225 

Could you tell me if your problem has been solved?

If it is, kindly Accept it as the solution. More people will benefit from it.

Or you are still confused about it, please provide me with more details about your problem.

Best Regards

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

[Ynr225 · Accepted solution]

Hello @v-zhengdxu-msft,

After adding gateway servers IP addresses under trusted IPs list in SAP DataSphere side. Dataset Refresh is working fine. Thanks for replying me.

[v-zhengdxu-msft]

Hi @Ynr225 

Maybe you can try uninstalling the gateway and reinstalling it,

Or you can try to get the data by this way:

Consuming data from SAP Datasphere into Power BI v... - SAP Community

Here are some links about this error for your reference:

DM_ErrorDetailNameCode_UnderlyingErrorMessage - Ti... - Microsoft Fabric Community

Solved: Power BI Data Source Error - Microsoft Fabric Community

Solved: The underlying connection was closed: An unexpecte... - Microsoft Fabric Community

web services - Explanation: The underlying connection was closed: The connection was closed unexpect...

c# - ..The underlying connection was closed: An unexpected error occurred on a receive - Stack Overf...

How to fix error "The underlying connection was closed: An unexpected error occurred on a send." whe...

Best Regards

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