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.

amaleranda's avatar
amaleranda
Post Patron
6 years ago

hi Pragati11 ,

 

Tanks for the reply. 

 

I do not seem to have that options in my preview feature. I am using May 2020 version. 

 

Thanks

amaleranda's avatar
amaleranda
Post Patron
6 years ago

Pragati11 ,

 

I found it and tick the box. Issue still pressist.

 

 

  • 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