Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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:
If I remove column3 in orginal table, result is as below.
In Appned, column3 has been removed.
In Duplicate/Copy, column3 still exists. It needs to be removed by yourself manually.
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.
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:
If I remove column3 in orginal table, result is as below.
In Appned, column3 has been removed.
In Duplicate/Copy, column3 still exists. It needs to be removed by yourself manually.
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.
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 :
Refresh on visual page:
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |