Forum Discussion

kevinfoch1's avatar
kevinfoch1
Frequent Visitor
4 years ago

Gateway error sharepoint

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 DateTime value."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"7/25/2018 10:54 PM"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: Ops SIP Calendar.
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: bbdcc561-a748-4118-94a9-72135f546a9f
Request ID: 2967109b-f3c3-b2cb-aaa3-bb2a17dcd941
Time: 2022-03-04 01:00:00Z

 

i am pulling data from sharepoint. but forsome reason its failing. the gateway is connected succesfully,

 

its refreshing int he desktop .

 

but for some reason its not refreshing online.

 

any help will be appreciated

Need Help

3 Replies

  • arvindsingh802's avatar
    arvindsingh802
    Community Champion
    4 years ago

    Check your data and to confirm any bad data in your date table, that might be having some additional space or character, once cleaned it will be good.

  • kevinfoch1's avatar
    kevinfoch1
    Frequent Visitor
    4 years ago

    if there is bad data then i shouldnt refresh in the desktop versio right?

    its refreshing fine in desktop

    as soon as its on service its not working.

  • v-jinweili-msft's avatar
    v-jinweili-msft
    Microsoft Employee
    4 years ago

    Hi kevinfoch1 ,

     

    Based on the error information you provided, we recommend you to follow the following aspects to troubleshoot.
    We have found a similar thread for your reference.

     

    1.Check if there are any spaces or strange characters in the data and try to remove them if there are any.
    2.You can refer to the article above for the steps to convert data in Power Query.
    3.Try to republish to SharePoint and refresh.

     

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