Unsupported Refresh on Web.Contents

[Anonymous]

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 refresh in services to reports that are getting called from this format below:

Json.Document(Web.Contents("https://name.name.com:1111/api/viewContents/projects/v1/PowerBiAllProjects?projectId=-1"))

[ibarrau]

Hi, We might help you more if you show us the error and specify the api authentication. Here is the good practise for this:

Web.Contents(
 "https://name.name.com:1111/api", 
 [
  RelativePath="viewContents/projects/v1/PowerBiAllProjects", 
  Query=[projectId=-1]
 ]
)

 I hope this works.

Regards,

[Anonymous]

That would not connect following your example.  My error is this:

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

• Data source for IssuesProjectsJoined

Discover Data Sources

Query contains unsupported function. Function name: Web.Contents

Here is the data source for this from advanced editor:

Source = Json.Document(Web.Contents("https://name:port/api" & "/viewContents/projects/v1/PowerBiProjects?" & "projectId=-1")),
viewContentsV1 = Source[viewContentsV1],
rows = viewContentsV1[rows],

[lbendlin]

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]

His format would not work - my import fails. 

[ibarrau]

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 · Accepted solution]

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]

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