How to take calculated New Columns or New Table made in the Data view into Query Editor?

[Anonymous]

Hi,

I have made a lot of New Columns and New Tables in the Data view.... however, they dont show up in the Query Editor... I really need them there. How can I get them there?

[Greg_Deckler]

If you post some of your formulas, we can perhaps help you recreate them in Power Query code.

[Anonymous]

Thanks! I have really a lot of tables and columns so I think it will take too long to describe each of them well. I will just re-do them in Query ... 

[AnkitBI · Accepted solution]

Hi @Anonymous 

Calculated Tables and Columns are not available inside PQ as they are created inside Modelling (Power Pivot) part using DAX.

Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.