Forum Discussion

T_Campelo's avatar
T_Campelo
Frequent Visitor
8 years ago
Solved

Data view & Edit Data not aligned

Hi all,

 

first, thank you in advance for your help.

I have edited my database directly in the "Data" area, without entering the "edit queries" function. Now, I would like to copy/paste the database but, when I enter the "edit queries" area the columns I created don't appear.

Is there a way to refresh the edit query view (I tried using the function "refresh preview")

 

thank you,

Tiago

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Tiago,

     

    I'm afraid you have to recreate all the DAX functions in the Query Editor if you want to use them in the Query Editor.

     

    Best Regards,

    Dale

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI T_Campelo

     

    You have done the changes in data model using DAX which you wont see in Power Query ( Query Editor) as DAX formulas are calculated dynamically and they dont store the data.

     

    Thanks

    Raj

    • T_Campelo's avatar
      T_Campelo
      Frequent Visitor
      8 years ago

      Hi Anonymous,

       

      thank you very much for your answer.

      Is there any way that I can avoid redoing all the columns and measurements in Edit Query mode?

       

      thank you

      Tiago

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Tiago,

         

        I'm afraid you have to recreate all the DAX functions in the Query Editor if you want to use them in the Query Editor.

         

        Best Regards,

        Dale