Save a few minutes every time you want to query your database to check out some data by cutting Excel out of the equation.
email@example.com wrote this about 6 years ago and it was last updated about 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:
I 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
.sql files so I can backup in Git.