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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Created table can't be opened in power query editor

Hi all

 

If I create a new table via UNION & SUMMARIZE from other tables, the newly created table can't be edited / opened in the power query editor. The option just doesn't show and the table also doesn't appear in the power edito. How so? How can I change it? If I just enter data for instance this isn't an issue.

 

Thanks!

3 ACCEPTED SOLUTIONS
keshavagrawal27
Resolver I
Resolver I

Hello @Anonymous,

The tables created outside Power query Are not accessible in power query 

View solution in original post

johnt75
Super User
Super User

If you create the table using DAX it will not show up in Power Query at all. There is no way to directly edit the underlying data.

View solution in original post

Thennarasu_R
Responsive Resident
Responsive Resident

Created a Calculated Table and Calculated Column using Dax in Desktop That fileds nor appear in Querry Editor .
We only only See in Desktop And manually cannot edit only edit with dax function Calculated table and Column.

Thanks,
Thennnarasu R

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Thanks to all for the quick answer!

Thennarasu_R
Responsive Resident
Responsive Resident

Created a Calculated Table and Calculated Column using Dax in Desktop That fileds nor appear in Querry Editor .
We only only See in Desktop And manually cannot edit only edit with dax function Calculated table and Column.

Thanks,
Thennnarasu R

johnt75
Super User
Super User

If you create the table using DAX it will not show up in Power Query at all. There is no way to directly edit the underlying data.

keshavagrawal27
Resolver I
Resolver I

Hello @Anonymous,

The tables created outside Power query Are not accessible in power query 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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