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 ,

 

Please disable "enhanced dataset metadata" option in Power BI.

You can navigate there as follows: File --> Options & Settings --> Options --> Preview Features --> Stored Dataset using Enhanced Metadata Format

 

Then try again your query chnages.

 

Hope this helps.

 

Thanks,

Pragati

 

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.