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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors