Forum Discussion
Dataset refresh failure SAP datasphere as a data source
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!
Hello Anonymous,
After adding gateway servers IP addresses under trusted IPs list in SAP DataSphere side. Dataset Refresh is working fine. Thanks for replying me.
4 Replies
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
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.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.Hello Anonymous,
After adding gateway servers IP addresses under trusted IPs list in SAP DataSphere side. Dataset Refresh is working fine. Thanks for replying me.
