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

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote 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
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

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.