Data view & Edit Data not aligned

[T_Campelo]

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

[Anonymous]

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]

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 · Accepted solution]

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