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 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"))

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"
    ]

    )
    )

7 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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'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],