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 same rows, same columns and same data and same data types.

 

I started the report with the imported table and created all of the measures using the imported table and realised later that i need to use the Created table built inside power BI for better flexibility when years transition.

 

So I want to replace the imported table with another table(Created table) that was created inside Power BI using DAX.

 

Since I created the table inside Power BI.. the newly created table does not show up in the query editor for me to simply replace the data sources.

 

I have tried renaming and deleting the table names but it did not work.

 

Is there a fix for this?

 

Imported Table: Please see the formula bar has no formulae

Created Table: Please see the formula bar has formulae

 

Thanks a lot in advance!

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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

     

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Yes! This Works.

       

      Sorry! I had mentioned in the question that.. I tried the solution and it did not work..

      But when I watched closely.. There was a small "space" missing in one of the column names of the created table that was there in the imported table.

       

      After correcting that.. This works

      Thanks for the solution.. 🙂