Forum Discussion
Query contains unsupported function. Function name: Web.Contents
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),
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
5 Replies
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
JimmyHello 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-contentsHello Anonymous
so you were able to fix it?
BR
Jimmy
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/FeatureServer/15/query?where=1%3D1&outFields=*&returnGeometry=false&f=json&token=" & token_)),
