Power Query refresh bring in null values

[KMAccounting]

I created a spreadsheet that would pull data from a folder using power query. I have been using this for the past four months however when I have saved Aprils .csv in the folder and selected refresh I noticed no data for April. So I went to power query and filtered on April’s data and noticed that when it pulled into the query most of the columns were “null”. I pulled the original spreadsheet from folder and all the data is showing. I cannot figure out why when I refresh that just April’s file is showing null values. I basically run the report from a portal download the report and then save the csv into the folder. Can anyone assist me with why one file in my folder would pull in “null” values?

[v-juanli-msft]

Hi @KMAccounting 

Do you connect to folder with power bi desktop, then upload a new file to the folder,

when refreshing from power bi desktop, the new data doesn't show in the file?

Best Regards
Maggie

[KMAccounting]

No, I use Power Pivot however in Power Query the data in only some columns is null but not all.  When I create a new spreadsheet and load just April's Data all columns is showing the correct data.  When I try to load all files in one folder April's data shows as null.  I hope this explains it