Append 4-5 tables

[KiranPatil]

Hi Guys ,

Newbiee to Power BI .

I want to Append multiple tables ( 4 -5 tables ) of same columns . Before that i have created Flag for each table ( calculated Field in each table ) . When i go to Edit query and check those tables , iam not able to see the Flag created ( calculated Field ) in Edit query please help

[Anonymous]

Hi

You have created calculated columns using DAX, which resides in your data model which will not appear in Power Query/ Query Editor. So, you wont see the created measures/ calculated columns in Query Editor.

Thanks

Raj

[KiranPatil]

okay Thanks ,

I want to know is there any way in which i want tables which are created in datamodel should be will avaiable in Power Query ?

Please help

Advance Thanks

[v-yulgu-msft · Accepted solution]

Hi @KiranPatil,

No. It's not possible to show any calculated table/column/measure generated by DAX in Query Editor mode. If you want to add a tag column for each table, please use Power Query (M code) to achieve that.

Regards,

Yuliana Gu

[KiranPatil]

Ok thanks a lot