After Append Table B to Table A , Am i allow to delete Table B ?

[admin11]

Hi All

I have Table A it have 10 row  & Table B have 10 row.

I Append Table B data to Table A.

Now Table A have 20 Row and Table still remain 10 row.

My Question is am i allow to delete the Table B ? Will there be any side effect later ?

Paul 

[amitchandak · Accepted solution]

@admin11 , I do not think you can delete table B. As it will still search for it

[parry2k · Accepted solution]

@admin11 yes, it will surely reduce the size, since table b is already appended to table a and table b is unchecked, not loaded in the memory, size will go down.

[admin11]

@parry2k 

Thank you very much for sharing .

Paul

[parry2k]

@admin11 make sure, Include in report refresh is checked.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[admin11]

@parry2k 

If my

Table A total file 20MB

Table B total file 20MB

After Append total file size 60 MB

If i un-tick enable load , total file size only 40Mb right ?

Paul

[parry2k]

@admin11 yes, it is just not loaded in the model but the rest of the transformation and data refresh still works.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@admin11 you cannot delete it but you can turn off the enable load so that it is not loaded the data model.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[admin11]

@parry2k 

If you Tick enable load to off for SALES_I table , will the data be still able to update in next refresh ? 

[amitchandak · Accepted solution]

@admin11 , I do not think you can delete table B. As it will still search for it

[admin11]

@amitchandak 

Thank you for sharing.