Forum Discussion

chandra's avatar
chandra
Frequent Visitor
9 years ago
Solved

change Table and Column Name

Hi All, I am importing my tables from Oralce Database. I want to know if I will get errors during data refresh in each of these situations....   1) Changing the table name 2) Changing the column ...
Need Help
  • alanhodgson's avatar
    alanhodgson
    9 years ago

    chandra,

     

    You should be fine to change column/table names. Keep in mind they will stay changed when you refresh the data.

     

    Deleting the columns will have no impact if you are not using them in the visuals or as filters.

     

    Have a good day!

alanhodgson's avatar
alanhodgson
Solution Supplier
9 years ago

Hey chandra,

 

How is your data refreshed, imported into PBI or through DirectQuery to the database?

 

I tested importing data from a query and this is what I found:

 

1. No error when imported. Change stays when refreshed.

2. No error when imported. Name stays when refreshed.

3. Deleting a column will give you an error on all the visuals using that column. Refresh doesn't bring it back, so never imported during refresh.

 

Hope this helps,

 

Alan

 

  • chandra's avatar
    chandra
    Frequent Visitor
    9 years ago

    Hi alanhodgson

    Thanks for your reponse. 

     

    I am importing the tables into PBI. (Not as direct query).

     

    In that case will there be an impact if I change column or table names or even deleting a column. 

     

    (I am not using the data from deleted columns in my visuals....they are useless data so I am deleting them)

     

    Thanks,

    Chandra

     

     

     

  • chandra's avatar
    chandra
    Frequent Visitor
    9 years ago

    Hi alanhodgson

    Thanks for your reponse. 

     

    I am importing the tables into PBI. (Not as direct query).

     

    In that case will there be an impact if I change column or table names or even deleting a column. 

     

    (I am not using the data from deleted columns in my visuals....they are useless data so I am deleting them)

     

    Thanks,

    Chandra

     

     

     

    • alanhodgson's avatar
      alanhodgson
      Solution Supplier
      9 years ago

      chandra,

       

      You should be fine to change column/table names. Keep in mind they will stay changed when you refresh the data.

       

      Deleting the columns will have no impact if you are not using them in the visuals or as filters.

       

      Have a good day!