Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
shamim
Regular Visitor

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 

shamim_0-1671427700905.png

 

5 REPLIES 5
AndreiSfarc
Frequent Visitor

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 )

AndreiSfarc_0-1694685383799.pngAndreiSfarc_1-1694685388631.png

 

 

vicky_
Super User
Super User

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.

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

amitchandak
Super User
Super User

@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?

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

This is not a DAX calculated table.

 

shamim_0-1671431357196.png

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors