change Table and Column Name

[chandra]

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

[alanhodgson]

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]

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 · Accepted solution]

@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!

[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