cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chandra
Frequent Visitor

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

 

 

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

View solution in original post

4 REPLIES 4
alanhodgson
Solution Supplier
Solution Supplier

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

 

 

 

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

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

 

 

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!