Use Visual Studio Code to Auto-format JSON

My last few articles have focused on using Visual Studio Code to build a series of scripts to help manage Analysis Services data models. As part of this work, I’ve found Visual Studio Code to be extremely helpful in other ways too, such as a very powerful text editor with many features you may find Continue reading Use Visual Studio Code to Auto-format JSON

Disable auto-format of JSON in SSMS

If you ever work with TMSL based scripts (basically big chunks of text in JSON format) in SQL Server Management Studio (SSMS), you may find that SSMS sometimes auto formats your JSON after you paste some script into the Text Editor. This can be mildly frustrating, but also potentially dangerous if elements are stripped without Continue reading Disable auto-format of JSON in SSMS

Use Visual Studio Code to create Power BI External Tool

For this article, I want to share a way for you to create your own Power BI “Helper Tool” and register it as an external tool in Power BI. This article carries on from some of my recent articles on how you can use Visual Studio Code to help automate specific tasks by taking advantage Continue reading Use Visual Studio Code to create Power BI External Tool

Using Visual Studio Code to query Power BI

In this article, I’m going to show how you can use Visual Studio Code to run queries against a Power BI model. Usually, this is the kind of task you would use the excellent DAX Studio for, but sometimes you have a requirement that doesn’t quite fit DAX Studio. Using VSCode provides a quick and Continue reading Using Visual Studio Code to query Power BI