cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Power Query refresh bring in null values

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?

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Power Query refresh bring in null values

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

Highlighted
New Member

Re: Power Query refresh bring in null values

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

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021