Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Original table name

Hello,

 

I'm wondering how I can determine the original name of a table in my model. I've since renamed the table, and am having trouble identifying it again in my data source. If I had the orginal name, I would be able to find it.

 

Thanks!

Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi， Anonymous 

    In interface of  "Transform Data",you can find your original table name .

    Ex.   My current table name is  "DimAccount1", original table name is "DimAccount" 


    Best Regards,
    Community Support Team _ Eason

4 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    Hi， Anonymous 

    In interface of  "Transform Data",you can find your original table name .

    Ex.   My current table name is  "DimAccount1", original table name is "DimAccount" 


    Best Regards,
    Community Support Team _ Eason

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Beautiful! This is it. Many thanks.

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Search for one of the column names you know is in that table in the Fields search bar.

     

    Regards,

    Pat

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Pat, I don't think this is what I'm looking for if I understand your response correctly.

       

      I have a table loaded into my model. I've renamed it long ago. I'm starting a new PBI file where I want to load in the same table under "Get Data", but am I having trouble recalling the actual name of the table from my data source (it has over 1k tables).  There is a search bar under Get Data > Navigator, but it does not search for field/column names, only table names. 

       

      Hope this makes it clearer. 

      Thank you!