DATA GATEWAY MASHUP ERROR

[Sandeep_Viswa]

Hi Team,

When i am refreshing the data source manually on power bi service i am facing the below error , Can some one help me out on this please!

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":"We couldn't parse the input provided as a Date value."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"WE 12-02-2022"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: T_SC_Emp_Payout_Summary.

[v-xiaosun-msft · Accepted solution]

Hi @Sandeep_Viswa ,

According to your error message, it may be a dataformat error. You can check that whether there are some extra space at the front of your date column. Make sure your Date column correct. And then try to refresh again to see if the isuue remains.

Best Regards,
Community Support Team _ xiaosun

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