Forum Discussion
Incorrect Sums using folder to get data
I am using the december release. I will try updating it and let you know. At my company sometimes it can take days to get permissions to install software onto the computer.
-Michael
Anonymous,
I found a similar problem that has been resolved in this thread by checking "Ignore Privacy setting" in the Options, not sure if it helps you or not
Anonymous ,
Thank you for finding that for me. unfortunately that did not fix the issue. Still getting very high numbers 12x as large as the actuals
-Michael
I am Still trying to resolve, if anyone has an idea let me know. I can provide more info
bump
Bump. I still cannot figure out this issue.
After further analyzing I noticed that Power Bi doesnt seem to be recognizing hidden rows from my folder. So it is essentially including rows that shouldnt be included. Thoughts on how to fix this?
Anonymous,
Where do these hidden rows come frome?
Anonymous
Basically It's an expense report that gets reported monthly into a folder. The way they are reported "monthly" Is by updating the YTD expense report and hiding the rows for the previous months if that makes any sense. It appears that when these files are pulled into Power BI what I think is happening, is the rows that are hidden are shown and an incorrect sum results because I have a lot of repeat transactions when I shouldn't
-Michael
Does the file name have any sort of context, like Month Name or Month Number? If so, you could use that to filter out all the other data that does not fit in that month.
That's just a high level guess though, is it possible to get two sample files? Or just some random actual data but correct on the file is named? Just thinking out loud here....