PowerBI file grows too large after adding a column

[Anonymous]

Hello All,

i have a small PowerBI file, about 5MB pulling data from few excel sheets.

I tried to remove some of the unwanted Rows in the file.

so I added a Index column, and use M to add another column to label the unwanted row.

try if [alarm class] = #"Added Index" {[Index] - 1} [alarm class]
then "delete"
else "keep"
otherwise null

at last i use the filter function to filter out the unwanted rows.

when i hit "Close and Apply", the file start loading data from the first excel sheet, but the size of the file just keep growing.. 9GB and counting... immediately i notice i probaly done something wrong, so i had to close the file. 

Can someone help me on this topic?

i think i probably done something wrong in the M portion, but in the preview, was showing eaxactly how i wanted. (preview attached)

i added the file in the link, before i added the M portion. because i couldn't save the file, it grew too large.

https://drive.google.com/drive/folders/1uGwRe2irg58XoAEBtucQVpZwDfRAvmCb?usp=sharing

[mhossain]

@Anonymous 

I don't see the attachement as you mentioned, please share.

[Anonymous]

@mhossain Sorry, i just updated.

[mhossain]

@Anonymous 

Can you upload the csv file too?

[Anonymous]

@mhossain i just uploaded the csv under the same link, in the folder labeled csv