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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
aameen1515
Helper I
Helper I

Tables not showing up in query editor

Hi All

 

I am fairly new to power bi.

 

I created some tables & did created a lot of calculated columns using DAX, but now those tables are not showing up in query editor for me to be abel to transform the data.

Can somebody guide step by step please...

 

Looking for help

 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

Hi @aameen1515 ,

 

Tables or columns created by DAX will not appear in Query Editor.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

4 REPLIES 4
hkice
Advocate II
Advocate II

This is ridiculous !!   Can someone tell me why it is so !!!

v-jayw-msft
Community Support
Community Support

Hi @aameen1515 ,

 

Tables or columns created by DAX will not appear in Query Editor.

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Is there an explanation of why tables created by DAX will not appear in Query Editor?  "Just because" isn't helpful.  

amitchandak
Super User
Super User

@aameen1515 , Any table created using dax will not appear Edit Query mode. Create tables there if you need tables there.

 

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

https://www.poweredsolutions.co/2019/07/30/grouping-rows-with-power-bi-power-query/

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.