Forum Discussion

Anonymous's avatar
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...
Need Help
  • v-xuding-msft's avatar
    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!!

     

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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's avatar
      HotChilli
      Icon for Community Champion rankCommunity Champion
      5 years ago

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

      • Anonymous's avatar
        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