Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

In Power BI Desktop, 'Edit query' option is missing for one table.

I'm trying to locate the data source for one of the PBIX files from a previous developer by right-clicking the table and selecting 'Edit query.' However, I am unable to find the 'Edit query' option for one of the tables. Has anyone encountered this issue before?

Need Help
Tips and Tricks

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    Anonymous , Have you created this table in DAX using script

     

    like date table using calendar

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi amitchandak: Thanks for your reply. I believe this entity was not created using DAX script, otherwise I should have DAX formula showing when clicking the entity name. The issue I'm facing is I just can't locate the source of this entity even from the Power Query Edit model. 

  • BiUSR's avatar
    BiUSR
    New Member
    2 years ago

    Hi Anonymous  were you able to fix the issue?. What was the soultion?

    Thanks