Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Replacing an Existing Table from an external data source with a table created inside Power BI.

Hello All,   I have created two tables ... Imported table - It was created based on an external data source) Created Table - It was created inside Power BI using DAX.   Both the tables have the...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    It is by design that the calculated table will not show in query editor Since calculated table is using dax but the quey editor is using m-query. Please make sure all the columns' name in calculated table is the same as the imported table. Then you can delete the imported table and rename the calculated table to the imported table. Then all the measure that using column from the imported table will not be impacted.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , If you want save measures the way is move measures to a different table and delete that old table and rename the new table.

 

But this risky, keep a backup of file.

 

Another way is, rename the swap the name of tables in a new file and then use ALM toolkit to merge. This can allow yoy merge measures you want

https://www.youtube.com/watch?v=lio62VRkOnc