Jeffrey Weir on 06 Mar 2020 11:21:05
Is there any reason why #PowerQuery couldn't warn you if you've misspelled [Some_Colum] like it does if you mistype #"Some Stepp"?
When refactoring in #PowerBI and #Excel I sometimes replace source queries, then spend ages hunting down field names that don't match.
- Comments (1)
Comments (1)
RE: Warn me when my M/PowerQuery code references fields that don't exist.
Sure, PowerQuery will {subtly) 'alerts' me to errors after refreshing. But I don't want to have to push refresh 10 times in order to be 'alerts'ed to 10 errors. I want to know NOW!
Related Twitter thread: https://twitter.com/InsightsMachine/status/1235768632958951424