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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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