No columns found

[Anonymous]

I am using Web.Contents and I have the below Invoked Custom Function. It says no columns found when I expand the Invoked Custom Function. What am I doing wrong. 

let a = (northing as number, easting as number) =>

let Source = Json.Document(Web.Contents( "http://www.bgs.ac.uk/data/webservices/CoordConvert_LL_BNG.cfc?method=BNGtoLatLng",

[ Query= [ easting=Text.From(easting), northing=Text.From(northing) ] ] ) )

in Source

in a

[Greg_Deckler]

@ImkeF @edhans @HotChilli @dm-p 

[ImkeF]

Hi @Anonymous ,
Did you try the query with hardcoded values instead? If that worked, you have to use a tool like Fiddler to see what query both of your versions actually send to the interweb and compare them.
If you cannot solve the problem by yourself, please post the code that both queries returned here in the post so that I can follow up.

If even the hardcoded version didn't work, you have to find another means that creates a valid query to get the string to compare against. A tool like Postman could help you with it.

[HotChilli]

I couldn't get it to fail.  What values are you passing to the function?

[Anonymous]

It worked with JDBC connection. Not sure why it does not work with ODBC connection in Power BI desktop

[Anonymous]

Was lucky as I had set up 2 connections ODBC and JDBC

Code 1 works fine in Power Bi desktop but cannot refresh in the app had error Web.Contents
let a = (easting1 as number, northing1 as number) =>
let
Source = Json.Document(Web.Contents("http://www.bgs.ac.uk/data/webservices/CoordConvert_LL_BNG.cfc?method=BNGtoLatLng&easting="&Text.From...""))
in
Source
in a

Second Code does not bring in the data with ODBC connection Works with JDBC No error but does not bring in the columns
let a = (northing as number, easting as number) =>
let
Source = Json.Document(Web.Contents(
"http://www.bgs.ac.uk/data/webservices/CoordConvert_LL_BNG.cfc?method=BNGtoLatLng",
[
Query=
[

easting=Text.From(easting),
northing=Text.From(northing)
]
]
)
)
in
Source
in a

[Anonymous]

I got it working I think it is something to do with the URL.

Thanks for the replies guys

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Glad you have resolved it. 😉 You could accept your answer as solution. Others who have the same questions will benefit from this thread. Thanks!!