Forum Discussion
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 name
3) Deleting a columns itself. (Also in case of column deletion, will that column be deleted after each refresh or it will never be imported during refresh)
Thanks
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!
4 Replies
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
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
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
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!
