Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.
me@jaykilleen.com wrote this over 6 years ago and it was last updated over 6 years ago.
I've been bypassing Power Query in Excel lately by going directly to our databases using SQL. This is really easy (compared to what I have been trying to do in the past) by using the Visual Studio Code Extension called mssql. Also checkout this Microsoft guide on how to use this vscode mssql extension.
Now instead of:
You can:
.sql
queryI also use this Project Manager extension by alefragnani to quickly switch to my MSBI Data Catalog in VS Code. This is where I store all my .m
, .pq
and .sql
files so I can backup in Git.