PBI dataset refresh fails on Power BI service

[Ynr0225]

HI All, 

The Power BI report is refreshed as per the schduled time but yesterday it was failed and when i checked today the dataset is refreshing as expected. When it was failed we received the below error. May i know why this refresh failed on service. 

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"<pi>We're sorry, an error occurred during evaluation.</pi>"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: HgRecord.

Thanks in advance!

[Sahir_Maharaj]

5. If the issue persists, you can try recreating the report or the data source connection.

Let me know if this works for you.

[Sahir_Maharaj]

4. Check the data source logs to see if there were any issues during the refresh.

[Sahir_Maharaj]

3. Try to refresh the data in Power BI Desktop and see if the issue persists.

[Sahir_Maharaj]

2. Check if the data source is available and accessible from the location of the Power BI Service.

[Sahir_Maharaj]

You can try the following steps to troubleshoot the issue:

1. Verify that the data source is accessible and the credentials used to connect to it are valid.

[Sahir_Maharaj]

This error message usually indicates a problem with data access or data connection.

-2147467259 is a generic error code, which could mean a number of things.

It could be a temporary issue with the data source, such as a network connectivity issue, or a more permanent problem with the data source or the credentials used to connect to it. It could also be a problem with the report, such as a calculated column or measure that is causing an error.