Forum Discussion

jbruewer's avatar
jbruewer
Helper I
5 years ago

dataset refresh failed on server

Currently i've to develop a dataset that cascades data from different REST APIs. All APIs are provided by the same solution. On my local Power BI Desktop solution, the refresh is working like a charm...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi jbruewer ,

As Ken Puls's blog mentioned, you cannot combine an external data source with another query in power query. You can try to follow the blog's suggestion to re-bulid your query.

In addition, you can also refer this blog and comments under it:

Web.Contents(), M Functions And Dataset Refresh Errors In Power BI 

 

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

  • jbruewer's avatar
    jbruewer
    Helper I
    5 years ago

    Thanks v-yingjl,

     

    for your contribution 👍. I've already tried this approach and recognized that i've been limited by the syntax check fo the Query:

    #"getTasks output" = Table.AddColumn(letSource, "result", each Json.Document(Web.Contents("https://restapiService.com", [RelativePath="/index.php?/api/v2/get_TaskOutput/" & [TaskID], Headers=[#"Content-Type"="application/json"]]))),

     

    as you see the URL looks like:

    "https://restapiService.com/index.php?/api/v2/get_TaskOutput/1234"

    I have a standard REST API call without a Query option like "q=1234" or "q=/api/v2/get_TaskOutput/" & [id]".

    The query parser request this syntax an i am not able to change it according the proposed pattern.

     

    I am still looking forward to get some hints or new ideas to solve this issue.

    All help is appriciated!

    //joerg