Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Unsupported Refresh on Web.Contents

I saw some postings on this similar error but I don't understand how to write the MQuery for api that I have set up in my reports.  Can someone help me with the appropriate MQuery to be able to do a ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I was able to import and also get the Gateway refresh to work now.  I had to split it up this way:

    = Json.Document(
    Web.Contents("https://name.com:port",
    [
    RelativePath="/api/viewContents/projects/v1/PowerBiProjects?projectId=-1"
    ]

    )
    )

lbendlin's avatar
lbendlin
Super User
6 years ago

That data source is not well formatted. Refer to the example provided by ibarrau 

 

It may also help not to conflate the web request and the JSON parser.

 

Try having the source as just the web contents.

 

Source = Web.Contents(URL,Parameters),
JS = Json.Document(Source),
viewContentsV1 = JS[viewContentsV1],
rows = viewContentsV1[rows],

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

His format would not work - my import fails. 

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    The format I have sent is the best practise. I might have some mistake somewhere. Try "-1" with double quotes in the parameter.

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I was able to import and also get the Gateway refresh to work now.  I had to split it up this way:

      = Json.Document(
      Web.Contents("https://name.com:port",
      [
      RelativePath="/api/viewContents/projects/v1/PowerBiProjects?projectId=-1"
      ]

      )
      )

      • lbendlin's avatar
        lbendlin
        Super User
        6 years ago

        Hard coding is not a good solution. You will want to follow ibarrau 's guidelines.