Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • keshavagrawal27's avatar
    keshavagrawal27
    3 years ago

    Hello Anonymous,

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

  • johnt75's avatar
    johnt75
    3 years ago

    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.

  • Thennarasu_R's avatar
    Thennarasu_R
    3 years ago

    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

keshavagrawal27's avatar
keshavagrawal27
Icon for Resolver I rankResolver I
3 years ago

Hello Anonymous,

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