Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello everyone,
I've set up a PowerbI report based on data I receive monthly. I've created a Sharepoint folder which is where the data set is located.
I receive a monthly YTD file, which includes data from january 1st until the end of the month of the month I receive a new file.
My goal is to upload the new YTD file to the same Sharepoint folder, so that the report includes the latest month of data.
However, when I upload the new file, my values seem to double in PowerBI.
This is before:
This is after:
It just seems to add the values in the new file, with the ones in the previous file, but I only want it to add the values of the latest month.
Any help would be greatly appreciated
@Bobbys , if each file contains a YTD, then you need a replacement for the current year file in the folder. Is that happening or you have two YTD files for same year
I have two YTD files for the same year. Is there a way to fix this? I wished that it would understand that the data from the previous file is identical and therefore not duplicate
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!