Skip to main content

Power BI

Needs Votes

Warn me when my M/PowerQuery code references fields that don't exist.

Vote (4) Share
Jeffrey Weir's profile image

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)
Jeffrey Weir's profile image Profile Picture

jeffrey Weir on 06 Jul 2020 00:09:31

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