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
KiranPatil
Frequent Visitor

Append 4-5 tables

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

1 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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

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

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ok thanks a lot

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.

Top Solution Authors