Forum Discussion
Newbie question
Hi - I was hoping for some help -
I put together my very first desktop power bi with sales, distributor and product data pertaining to commissions from our sales reps around the United States.
I am loving power bi and creating reports my company is loving for all of 2022 ----- BUT - I cannot get my 2023 csv files to load. If there is a date from 2021 or 2022 it will load - but skips over the 2023. I don't think I have any filters on - I have checked all I know how ---
any ideas? Please help!
Ok - so you can see the file it's referring to. Also you can see that it's taking only the first 18 columns from that file.
And one final thing you can see is that there is one filter set up and it filters the data to only rows where [Month] = 12.
Now I don't know what the logic behind that is, but that is what's set up. It might be just the final year's data... don't know.
15 Replies
This will require more details. How and from where are you loading the csv files?
OK you are right. I am adding it to an existing spreadsheet that is already being utilized in power bi. I use the transform data button, data source settings, and then making sure it is on correct sheet.
If I add data with a 2021 or 2022 date it will update correctly, but bypass any with 2023 date
I did that but problem persists. Could I have added a filter accidentally? I checked the data lookup file and all source files and can't find anything.
