Forum Discussion
Convert Table created using DAX formula into a query
Hello,
I created a customized table using a dax formula, however when i open the powerquery editor the query isn't there.
I would like to know if it's possible to convert the table created into a query that can be edited through powerquery editor.
Thank you
Hi Anonymous ,
Calculated tables created with DAX (in the data view) are not visible in the Query Editor (Power Query).
You may load tables via Power Query, and then, once loaded, add calculated columns or create further tables referring to those tables with DAX, but not the other way around.
Your only option really is to create your "union" table in Power Query, using functions like Table.Distinct and Table.Combine, then you will be able to edit it further in the Query Editor.
Refer to ：
https://community.powerbi.com/t5/Desktop/Tables-not-showing-up-in-query-editor/td-p/1210933
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous , You have to create the same in power query. You can not get Dax table in power query
Hi Anonymous ,
Calculated tables created with DAX (in the data view) are not visible in the Query Editor (Power Query).
You may load tables via Power Query, and then, once loaded, add calculated columns or create further tables referring to those tables with DAX, but not the other way around.
Your only option really is to create your "union" table in Power Query, using functions like Table.Distinct and Table.Combine, then you will be able to edit it further in the Query Editor.
Refer to ：
https://community.powerbi.com/t5/Desktop/Tables-not-showing-up-in-query-editor/td-p/1210933
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Can you expand this solution of yours further? "Your only option really is to create your 'join' table in Power Query, using functions like Table.Distinct and Table.Combine, then you can edit it further in the Query Editor."
