Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

No columns found

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, east...

v-xuding-msft
5 years ago
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!!

Community Champion

5 years ago

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

Anonymous

Not applicable

5 years ago

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

Anonymous
Not applicable
5 years ago
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
- Anonymous
  Not applicable
  5 years ago
  I got it working I think it is something to do with the URL.
  
  Thanks for the replies guys
  - v-xuding-msft
    Community Support
    5 years ago
    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!!

Related content