Forum Discussion

NSBS's avatar
NSBS
Icon for Helper I rankHelper I
4 years ago

Power BI Service Refresh Failed

Hi All,

 

Kindly help to advise what is the issue behind my error message below when refreshing the dataset in PBI service

Data source error{"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":"File contains corrupted data."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: Reference Folder

Thank you.

Need Help

1 Reply

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi NSBS ,

     

    May I know what’s your data source and the connection mode used in the report? Are you using the latest version of Gateway?

    According to the error code, it says the file contains corrupted data and it is very likely that this issue is caused by something related to data format. Could you please check in your data source to see whether there is any newly added data may have format issue?

    In addition, please try to refresh this dataset by on-demand refresh to see whether refresh can be performed successfully. If it fails as well, please download it to a pbix file and refresh and check whether there is any warning or error in Power Query Editor(Transform Data)?

     

    Best Regards,

    Community Support Team _ Caiyun