Query contains unsupported function. Function name: Web.Contents

[Anonymous]

Hello everyone

I'm trying to adapt my url to make the query based on this topic and this other link, but that doesn't make the update work.

How can I do the url partitioning in the correct way?

token_ = #"Column1 Expandido"{0}[Token],

//Url
url = "https://services3.arcgis.com/xxxxxxxyyyyzzzz/arcgis/rest/services/service_abr54aahsh789sdsg/FeatureServer/15/query?where=1%3D1&outFields=*&returnGeometry=false&f=json&token=" & token_,
    
Source_fs = Json.Document(Web.Contents(url)),
       
//Query
features = Source_fs[features],
#"Converted to Table" = Table.FromList(features, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

[Anonymous]

Hello @Jimmy801 

The problem was that the data was updated on the PBI desktop, but not on the PBI Service, it was an error on the Web.Contents.

I managed to solve it like this

 Source_fs = Json.Document(Web.Contents("https://services3.arcgis.com/xxxxxxxyyyyzzzz/arcgis/rest/services/service_abr54aahsh789sdsg/FeatureS..." & token_)),

[Jimmy801]

Hello @Anonymous 

what error you get?

From your code you take the first row of a specific column to append it to the web-address and then read it. There is nothing wrong about it. What you mean by partioning? Your address is hardcoded and extended by an text what should give you a valid address I suppose. So nothing wrong in the tecnique.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Anonymous · Accepted solution]

Hello @Jimmy801 

That was the mistake. "Query contains function not supported. Function name: Web.Contents",

Partitioning would be to split the query into parts so that this error would disappear. 
See this article; https://docs.microsoft.com/pt-br/powerquery-m/web-contents

[Jimmy801]

Hello @Anonymous 

so you were able to fix it?

BR

Jimmy

[Anonymous]

Yes