Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Failed to fetch data from Marklogic using Rest API

Hi Experts,   I am trying to pull data from Marklogic database in Power Bi desktop using REST API, but it is failing with below error: "Web.content failed to get content, 500 internal server error...
  • TomMartens's avatar
    6 years ago

    Hey Anonymous ,

     

    maybe using the Timeout can be helpful:

    something = 
    Web.Contents(
    URL,
    [Timeout=#duration(0,0,5,0)]
    )

    The above snippet asks Power BI not to timeout before 5 minutes, you might consider to switch 5 to 10.

    Sometimes it's also helpful to turn off "Parallel loading of tables" in the options dialog:

    File --> Options and settings --> Options --> Current file --> Data loading

     

    Hopefully, this provides some new ideas to tackle your challenge.

     

    Regards,

    Tom