Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Source is missing from applied steps, want to modfy my sql statement

Hi Team,

 

Todaya found that we had custome sql that we want to modify but suddently edit SQL using source step is no more avaialbe in my PBI report. No wheel icon next to source.

 

please suggest workaroud or solution.

 

Regards,

Manveer Nakoti

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thank you Mahyar,

     

    Found that it is after recent upgrade and there is a parameter [EnableFolding=true] is added by default.

     

    Removing this will enable edit source.

     

    Thanks,

    Manveer Nakoti

2 Replies

  • MahyarTF's avatar
    MahyarTF
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi,

    Use the Advnced Editor and see the source and the query if you wrote that :

    Thanks for your Kudos and please mark it as solution if it helps

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thank you Mahyar,

     

    Found that it is after recent upgrade and there is a parameter [EnableFolding=true] is added by default.

     

    Removing this will enable edit source.

     

    Thanks,

    Manveer Nakoti