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 to Edit query and check those tables , iam not able to see the Flag created ( calculated Field ) in Edit query please help

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

4 Replies

  • 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
        Icon for Microsoft Employee rankMicrosoft 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