Forum Discussion
No columns found
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!!
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.
I couldn't get it to fail. What values are you passing to the function?
It worked with JDBC connection. Not sure why it does not work with ODBC connection in Power BI desktop
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(easting1)&"&northing="&Text.From(northing1)&""))
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
