Forum Discussion

amaleranda's avatar
amaleranda
Post Patron
6 years ago
Solved

error when try to apply changes after creating function

Hi Gurus,   I have created a table function as below (there are 6 functions) (Entname as text) as table =>   whne I try to apply change it gives me below error. Does anyone have any ideat how av...
Interesting Links
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi amaleranda ,

     

    Try to cancel the relationship between the table where entname is located and other tables, and disable the "enhanced dataset metadata" option. Then execute the custom function for entname in the query editor.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi amaleranda ,

 

I asked you to DISABLE it not enable 😛

 

Thanks,

Pragati

amaleranda's avatar
amaleranda
Post Patron
6 years ago

Pragati11 , Silly me 🙂 . I manged to disable it but still getting the error. 

I copied the Powerqury below. 

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi amaleranda ,

     

    Didn't understand your power query screesnhot. It's highlighting a BLANK space.

     

    Thanks,

    Pragati

    • amaleranda's avatar
      amaleranda
      Post Patron
      6 years ago

      Pragati11 , 

       

      I wanted to higlited #convert to tabel step.

       

      The read scrach is to hide the actual URL as for privacy. Thanks

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi amaleranda ,

         

        It seems like while converting your list to table there are errors due to NULL values.

        Is it possible to share scrresnhot around the data that you are trying to convert to Table.

         

        Thanks,

        Pragati