excel sheet get full now unable to update data in fact table

[anupampandey]

Hello Team members,

I am stuck in one situation from where I can't update my fact table. The problem is all the rows in excel sheet from which I was loading data is full. Now I don't know how to update the fact table in power bi desktop.

Please suggest me how to update the table with current data in same.

Thanks & Regards,

Anupam

[anupampandey · Accepted solution]

Hi,

I have loaded a one more and append it with existing fact table with a little step added to query under advance editor:

let
#"Appended Query" = Table.Combine({#"Changed Type", SALES_03MAY17_ONWARDS}),
#"Removed Duplicates" = Table.Distinct(#"Appended Query", {"BILL_TXNDTLID", "Tran_DT"})
in
#"Removed Duplicates"

Now I just wanted to refresh the fact only with the table which I am appending not the entire one.

Could anyone help me on this please?

Thanks,

Anupam