Forum Discussion

shamim's avatar
shamim
Regular Visitor
3 years ago

Tables not having edit query option

Hi All,

 

I'm facing challenge to solve a problem. I've got an pbix file which I need to modify and update for new requirements. The challenge I'm facing: There is a table (manually entered data) which doesn't have any 'Edit Query' option. This particular table is not appearing in the Query editor when I go there using Transform Data. Here is the screen shot. any idea why it's not coming up in the Query editor?

 

Even there is no option to 'Edit Query' menu 

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    shamim , This does not seem like a DAX calculated table. For that we do not have that option.

    Is it a table from direct query of the power bi dataset?

    • shamim's avatar
      shamim
      Regular Visitor
      3 years ago

      This is not a DAX calculated table.

       

       

  • vicky_'s avatar
    vicky_
    Super User
    3 years ago

    Is it possible that this table was created using a table manipulation function (something like a SUMMARIZE)? If so, then you won't be able to edit the original query - you can only edit the parameters of the function.

    • shamim's avatar
      shamim
      Regular Visitor
      3 years ago

      As I have mentioned earlier this table seems created using 'Enter data' option. This is not DAX calculated table.

  • AndreiSfarc's avatar
    AndreiSfarc
    Frequent Visitor
    2 years ago

    Hello,
    The table was creating using Tabular Editor ( external tool ). It might be used for giving the format of some measures when put in the legend of a chart ( my case )