cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jasonyeung87
Helper II
Helper II

Removing columns of reference tables

Hi,

 

I have a couple of tables that were created as a reference to another table. I deleted a few columns from the original table, but noticed the columns still exist in the reference tables. I was wondering how do I remove the columns from the reference tables? I tried to refresh the entities and data, but those columns remain. 

 

Sincerely,

 

Jason

 

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @jasonyeung87 

Did you build your reference table by your original table?

If you use options in Power Query editor like merge or append to build your reference table, the column will be removed automaticlly in your reference table when you remove columns in your original table.

If you use copy or duplicate option in Power Query editor to build your reference table, the column won't be removed automaticlly in your reference table when you remove columns in your original table.

Test:

1.png

If I remove column3 in orginal table, result is as below.

In Appned, column3 has been removed.

3.png

In Duplicate/Copy, column3 still exists. It needs to be removed by yourself manually.

2.png

If you remove the column first then build your reference table, you could achieve your goal as well.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

4 REPLIES 4
RicoZhou
Community Support
Community Support

Hi @jasonyeung87 

Did you build your reference table by your original table?

If you use options in Power Query editor like merge or append to build your reference table, the column will be removed automaticlly in your reference table when you remove columns in your original table.

If you use copy or duplicate option in Power Query editor to build your reference table, the column won't be removed automaticlly in your reference table when you remove columns in your original table.

Test:

1.png

If I remove column3 in orginal table, result is as below.

In Appned, column3 has been removed.

3.png

In Duplicate/Copy, column3 still exists. It needs to be removed by yourself manually.

2.png

If you remove the column first then build your reference table, you could achieve your goal as well.

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

Shishir22
Resolver II
Resolver II

Hello @jasonyeung87 ,

 

Can you please try "Refreh All" in Refresh preview in the transform data for all the tables and then try refresh on the visual page.

 

Refresh All in Refresh preview in the transofrm data :

Shishir22_0-1613765872825.png

 

 

Refresh on visual page:

Shishir22_1-1613765912817.png

 

If this fulfils your requirement please mark it as solution.

Thanks!

 

 

Hi @Shishir22 ,

 

I tried doing that, but it didn't remove the columns from the reference tables. I ended up reimporting the original table and then removed the columns before creating tables that reference it. It did improve the performance somewhat.

 

Sincerely,

 

Jason

 

Hello @jasonyeung87,

 

Can you please share how you have created reference column/tables with help of screenshots?

 

Thanks! 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors