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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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