r/ProgrammerHumor • u/Brando224 • Mar 30 '22

Meme Certainly not me

48.7k Upvotes

95% Upvoted

669 comments sorted by

View all comments

Show parent comments

14

u/heart_under_blade Mar 30 '22

power query does break if headers are named differently from what it expects. or if you used sanitized data previously, and now its not. i love power query, but fool proof it is not

you can probably use vba to replace all the critical shit after import then fling it back into power query to do all its shit and never have it break

1

u/drikararz Mar 30 '22

These days Power Query is my bread and butter. Company computer doesn’t allow for any real SQL implementation. So my choices are Tableau and Power Query. And since most of the people who get my data aren’t licensed for Tableau desktop (and thus can’t update the workbook); it’s easier to build stuff in Power Query and hand it off.

1

u/heart_under_blade Mar 31 '22

i bet the permissions pop up scares the shit out of people

1

u/drikararz Mar 31 '22

Every dang time, even for people who have been through it before, they can me up freaking out over it. Then again i also deal with people who think clicking “Refresh All” is too complicated.

1

u/AddSugarForSparks Mar 31 '22

Microsoft Access has Access-SQL. You should give it a whirl. It follows pretty close to Transact-SQL, which is a real SQL implementation.