Failed to fetch data from Marklogic using Rest API

[Anonymous]

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"

I am trying same URL in browser and it is successfully returning result in 7 minutes. 
Can anyone please advise what I am missing here?

[TomMartens · Accepted solution]

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

[Anonymous]

Hi Tom,

I turned off the Parallel query processing and it worked like a charm. Thank you so much for your help 🙂