Forum Discussion

KiranPatil's avatar
KiranPatil
Frequent Visitor
8 years ago
Solved

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 t...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
KiranPatil
Frequent Visitor
8 years ago

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's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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's avatar
      KiranPatil
      Frequent Visitor
      8 years ago

      Ok thanks a lot