Forum Discussion
DATA GATEWAY MASHUP ERROR
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.
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.