Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I have a problem with Power Query, I absolutely don't understand:
We get data from SAP which we store in a folder by month - below you see the import text for the single files - only query name and filename changed, the query was done once and then duplicated.
Then they were appended by year and finally the 3 years were appended - in the totals queries there is only the one line of code you can see below, I only shortened the months statement a bit in the middle.
My problem: in Power BI we realized that the numbers for November, 2021 were duplicated - just for November, 2021!
I had all queries' rows counted, the numbers were perfect for all month and for all single-year queries, in the query Totals 2020 - 2022 the miscalculation all of a sudden appears. There I have double the amount of rows for November, 2021, and the entire query statement is shown above. I can't understand that logic! I finally solved the issue by removing duplicates from the entire table, but I would consider that only as a workaround.
Solved! Go to Solution.
Hello - I recommend you take a closer look through the individual query results. If they really are correct individually then the appended/summed result would be correct also.
If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.
Proud to be a Microsoft Fabric Super User
Hi, thank you for your reply - problem was the Excel files generated from SAP - in 2 files the filter was set to the wrong year - that caused the problem 😞
Hello - I recommend you take a closer look through the individual query results. If they really are correct individually then the appended/summed result would be correct also.
If this post helps to answer your questions, please consider marking it as a solution so others can find it more quickly when faced with a similar challenge.
Proud to be a Microsoft Fabric Super User
Hi, thank you for your reply - problem was the Excel files generated from SAP - in 2 files the filter was set to the wrong year - that caused the problem 😞
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.