Duplicate value for csv group files

[Anonymous]

my database is a combination of csv files coming from a sharedrive folder. When new csv files loaded into the folder, somehow the values of each csv files presented on the pbi dashboard were doubled than it supposingly are. not sure which step went wrong, could I seek assitance on this ?

All the power query steps:

Details power query steps when I click into Other Queries [1] R026 Daily by item transaction

[v-jingzhang]

Hi @Anonymous 

You have two groups of Transform File from R026 Daily by item transaction, why do you need these two groups based on the same folder? Usually we only need one group to transform a sample file. 

In steps of Other Queries [1] R026 Daily by item transaction, it seems two functions from the earlier two groups are invoked. I don't know how you have transformed the two sample files but this may be the cause of bringing duplicated data into the combined query. You can click the "Expanded Table Column2" step to check whether duplicated data appear on this step. 

Usually we only need one group of transforming sample file and only one custom function is invoked in the combined query. Once new files are added to the same folder, you just need to click "Refresh Preview" to see new data in Power Query Editor, or click "Refresh" in Power BI Desktop to refresh data from the folder. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.