Notifications
Clear all
Power Query
6
Posts
2
Users
0
Reactions
142
Views
Topic starter
I have a file that is not updating in my Power Query. I have removed the file and added this file again and only this one column will not appear which is the Day of Week Column. I have a total of 21 files.
I did check to see if the cells are formatted as the same type as this looks to be correct. What could be the problem? How can I share? I will attach the actual file that I am having a problem with.
Posted : 14/10/2020 12:51 pm
Hi Leslie,
Please attach your query too.
Phil
Posted : 14/10/2020 6:03 pm
Topic starter
This has the file included does not show the DOW of week column for the month of OCT.
Posted : 15/10/2020 9:40 am
Hi Leslie,
In that sample file, the header name had a trailing space so it was actually 'DOW ' not just DOW. Remove that trailing space and it works fine.
Regards
Phil
Posted : 15/10/2020 10:45 pm
Topic starter
Thanks so much! That was it!
Posted : 16/10/2020 11:27 am
No worries 🙂
Posted : 16/10/2020 6:24 pm
