Data Table - Append Option

[RENJITH_R_S]

Friends

Can you please help on this

my  requirement is

In a  shared folder an excel file say file A will place on week 1. I need to load it on PBI. on second week onwards this file A will replace by new file A with different values with same schema. I need to append all and remove duplicates also in PBI see the example

Week 1 Excel file

id

---

1

2

3

Week 1 PBI Table

id

--

1

2

3

Week 2 Excel file

id

---

3

4

5

6

Week 2 PBI Table

id

--

1

2

3

4

5

6

Week 3 Excel file

id

---

5

6

7

8

9

Week 3 PBI Table

id

--

1

2

3

4

5

6

7

8

9

Please help on this

[v-easonf-msft]

Hi, @RENJITH_R_S 
As  mentioned by @vanessafvg , you need to create a folder to store the copy of each updated excel file (week1 excel copy, week2 excel copy...), then you can use the 'folder' connector to access and combine these data.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg · Accepted solution]

if you want to pull data from a folder and you have some sort of naming that allows you to filter on those files  you want to pull tin you can do a combine binaries in power query which will always pull files from a specific folder  and join and append them.

so next week when the new file is there power bi will just grab everything in the folder and process in full and append all new files together.

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-combine-binaries#:~:text=To%20star....

https://www.youtube.com/watch?v=RAmSdxt863s