Integrate Tabular Editor (Free Version) in Power BI as External Tools in 2 Minutes

You can easily integrate Tabular Editor in Power BI under the External Tools menu by following the simple steps as –

Download the Tabular editor from this blog’s menu => Kloudspro => Downloads => Power BI => Tabular Editor 2.16.5. Note that if you download through Google then you may come across Tabular Editor 3.0 which is a commercial and paid version.

Create a json file and paste the following text as its content

{
	"version": "1.0",
    "name": "Tabular Editor",
	"description": "Launch Tabular Editor to quickly and easily make batch changes to your semantic model.",
	"path": "C:\\Program Files (x86)\\Tabular Editor\\TabularEditor.exe",
	"arguments": "\"%server%\" \"%database%\"",
	"iconData": "image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAQAAAAEACAYAAABccqhmAAAACXBIWXMAAA7EAAAOxAGVKw4bAAANqUlEQVR4XuzdP24aQRxH8R8rGxe+BTdI0rhwchAOgaD3HbDkjgNwFpokN+AKSQpb4o/YeGhIEXstih0083nSCmSLwsV+31uK8aBt23gPoH1lu93G4XCIj9A0TQyHwxi8EhcNmngHYL/ft5vN5sM3fyINRfpM+mxcNDi3AMD6akABgPXVgAIA66sBBQDWVwMKAKxfQA0oALC+GlAAYH01oADA+mpAAYD11YACAOurAQUA1lcDCgCsrwYUAFhfDSgAsH6PNQADwPop99vdbhd9Fd16vY7JZJKu9L6vuon0N6a/NRHwCBDB+q9X9Hk/LJfL4/Uv4/H4ePVFehK4urpK1yBgADzr92P9x8fHN40/Go1iOp2m1xK/GzAAYP0OKqoBAwDWT1RYAwYArK8GDABYXw0YALC+GjAAYH01YADA+mXUgAEA66sBAwDWVwMGAKyvBgwAWF8NGACwvhowAGB9NWAAwPpqwACA9dWAAQDrqwFHgjmbr0/r93o81+3tbTw8PMRsNkvv+zyGLNWNswgNgLP5ct0Ud3d38fT0FJ8/fYmv99/S+/SzTGPnLEKPAJ71e7N+Mn668f/Hj5/fYz6fx/Pzs+8GSi0AsP4bpN+pgVoKAKx/Qg0UXQBg/W7UQPEFANbvRg0UUQBg/fNRA8UUAFj/fNRAlQXA+qx/Qg1cfAGA9XOgBvLTBFg/A2ogMwqA9TOiBrKiAFg/P2ogNwqA9fOjBhRABlj/klADCqB367O+GlADDeuzfmE1oAYUAOsXgBo4BwXA+sWhBrpRAKxfLmpAAXTA+lWhBhIKgPWhBhQA69eGGlAArA81UHEBsH4CaqCCAmD9LqAGii4A1u8GaqCwAmD984Ea6Gbw8vLSRlFgu9nF8Ob6+HoCv//8isViEavVqrr/aGwAYBDUgAGAQVADdQ4AjIEaMAAwBGrAAMAQqIGKBwCGQA1UPAAwAmqgygGAIVADvgOAEVADTXwcIIY318crC84bUABQA2ogfwEAGUpADSgAKAE1oACgBNSAAoASUAM5B+Ave2cPmlkRRuExRCVY7G6TFKtFLNQmhdpsYLVJCpWQlAHRVRKSLrJBVwkJ6yqBoBaGiAoGglrYqEXCh1okjQqxUSFpVotNoRZJoxYS/AHlKV6Eq8Evzs+de+ccuKTbm7vkPee8Z96ZGRsbcz5YWVlxQ0NDrg7s7++7hYUF1yawftzf389P/l95WkwCmhvodDpqAf6GgDXkDxCrCLlB0MvLy25nZwd1UjsQEWfPnHPPXnnOLS0tcbKTS4RmE8DR0ZGrCxRECYAQsKeTk5NudXUV55MHCSgbEAGgWHWBQigN29vbOAOe2r9fbkAEgDqJAOrLP3AEOKG4LkBu4KQsRgRweHhIIdbSeuA+SgeOYGpqCiKORALC7u4uTlcEcBIIqFJjc3PTCc6yEIJC3EDw7aYl4/sfvnPPX7vq1tfXs82bejJRIVxAUvXnnf+A3ABDJhBCqEsrinUBH3/yUbc5iwgAWC+aAKzVnvwuLSOSDUACyVoBqb4IgCyAtesU7UYX/a5IgFwgFUlK9UUA1pdToFHVDfXvCsoFzAkkcQFSfREAYGAFIsjI2qodSAWpvggAwKQhMwFchUfxiwTIZ1K4AKm+CKCaSFO8Pmk/y1v+u7S0OpA2N5HqiwAsGKR4p6enaQso6K4LH2aem5tT4BcGoUgUFyDVzwi9rgGACChoHra52lZXtr0aUHgYmSfK1JVCQUiVI6tLVX1WqVrnJHsb2JPylDTIY6QH4UF8/zXjb2POPMFbgZGREci3lOlAVB/iS2f3RQACu8eGh4fZTkqxnWY3GcVZdUW0Qcyjh1AvVJBDXHynA6sHh0j1RQACBT86OsrPUEQCifBg3SECshQfNbMWK9TNNVJ9hYACRb+xscHecYo1KsGg3mtra17v2draUsLvCzkAAbs+MzOTWk15H2SDwqF0KPppswB+bxyGRw5QtOrjzjjQk3cW6ADU41NAqDHFWCcB4Qb4Q0x5kIvlAMWqPsSPE3v4oUdKcwCCqS+JfiaAAGgJmPjr2g0QKrIicGpI9Sn8QjMA9fowP8WfIzHZEe1xHYBUv9AMQMVPEp97awIJ4AS6mbOgeCAMjxxAql+AAxDo9xs0QQdRQVgxD1UlB5Dql+EApPwTExOuYTDCwgnEOtLdBoKk+nIAsv2ZkgAqFvJSF6l+OQ5AaT/Wv+FgxYJt2WzIOsEB6J6+quprElDr/HYjTBu+pXEu5ptvr3MOBMUv1ZcDqGVdnaW+Nk0s8k1sjGmC5affl+rLAdRXLIR+bQPfNDAwkLXlf+bK0xR/i1VfDsD2xpvKEu7kdCBItL6fwI3pO77v4ODAgcXFRXf7+TuqyXrU8WWsdVJI9UUAKM/4+DiperWvtpTadrtZsbDtlSUsiCFl6h98tp+Cx3rzswrCOZT5iUtPOgPLapHIwM4ngIRyUX0ICcJPuXnLSFcEkKDwYdvTzpzjDFArmJqz7JKFQbwvECCubn53iI7vq7oBI4PQRMA31n5U+O9//MY38//TUtVXBoCysVON4vdO4+fn52Mn8nZGYcibebomLpbocAPvvPu2M1SIIOR3QsxWGHWoPgRE8be015cDoGCD7jSDRAYHB2PeDQBhhbrD4P8qm7U9hFP/5gZCOQHaMTugVaovB5Cw+P13u8VQLTt6K4TyeysbBIcbeOPN12M5AbIOa9FS9votV30RAH07xR91BWF2dtYFBgd4hrqLL+gJvo9feoyhmNAkYISHq4qu+p99/intEMFjsoNaXrj2ojkoEUDL1s8hGNQ6dDoe8eINf1J5+ZWXqiTAdlxfleSR6isDCGb9U74r5PXX3oVgR3fHAv82boBA9O677gmyHdeWZH0AEanXlwOgp0w5OovV452h2grfQog9Ylt1AxSZrwvgm6X6cgBJ1s9jpfak5iEIIEQLQQCYZGgJdcX94IJ4by744MP3IcLSVF8OwK68SgzeGaJ4QzgXFKhyHl90N4DS8vg5AX/7z2EdzPBT/AWqvggAG9bkd/vek2eFQOpM+lw5bz++G6D49vb2Uhc/bQiqz5Il7kcJvwigqHdbEFe3G6D4yAaSXXlN8aP6vFOqLwKAmfN9d3rU5QbIQ1BjXEGswodgpPoiACHXbIA9BeQCHAvOjsqenp4Qhd9m1dcqQKfTafK5fbm3EeYGUl5VzRQhZw8wNcnglE/IR6+Pu1DCr2XALM+7a5IbgGySHW9t25HBAxcf7PaMASt8S/hxE9qvLwIQmuoGIAEUnCnCs2fOVc8YqBZ+21RfBCDIDdj5BBQZA1Q3995SHeNtu+orBBS0UoCiQwRfff0lKu+AQev6HhABCA2bIiTRt63GhSX8agEEZQM2QEQxFnjnnhyAIDcACr5zTwQgKBtQry8CEOQGpPoiAEFuQKovAhDkBqT6IgBBbkCqLwIQ5Aak+iIAQW5Aqi8CEOQG8lJ9obevr+8mVyOOj4//dDlBU4Sa5pMDEOQGpPoiAEHZgHp9EYAgN1Cg6osABLkBT5jq/9Xe3eMqFYVhFN6H8BMqdQrMQG0YC3MggTnQqAWGkgEwCgZAoxYMRC1uaEiO92tsSNSE69nA96yE3I5wY867lhvNLvkwAAAMAAADAMAAADAAAAwA4qKNFwYwAEYAMABGADAARgAwAEYAMABGADAAcYllnfcwAjAA9R/+/X5friTe44FGAAbAw28EYACY3wjAADC/EYABYH4jAAPA/EYABoD5jcD14MfP7waggvmNQHXw9duXMp/PDUAF8xuBqrD+x08fymq1iktYDEAF81cdAbD+4XAot0Kf+bsbgWCxWJR8sP52u40H3yFgBfMrAbB+nQJgfiXA+r4G9PArAdZXAB5+JcD6CuClbZrys4P1Z7NZtgIAWH8ymUQ5xs+aAwCw/nq9jn/Q06X14+UMAGB9AwCwvgEAWN8AAKxvAADWNwAA6/+BpmmyDQDA+kGv1yvD4TDdAACs3+/Hq3EGkBCwfvNMwjMAgPWTHgICrO9bAID1Mw0AwPpJBwBg/YQDALB+sgEAWN+9AADrZxkAgPXdCwCwfsoBAFjfADDf61dvSjJY3wAgrBA30CyXy/Lu7fuSCNZ3MQjato3sjbvm4875MKL79f+T9TebTQxAp9YfjUb/lvwKAJHBx+PxIWuA9f+OAsCD1gDrZykAqAHWdzko1ADrZykAqAHWdz041ADrJywAqAHWT1oAUAOsn7AAoAZYP2kBQA2wfsICgBpg/aQFADXA+skKAGqA9e96AKAGptNpuZKwvv+vf6cDADVQ8z0uYX0DALC+AQBY37cAiFPuMF8anPArAFw+CLvdLl5Zrc/6CkAK168B1lcAUAOsrwCgBlhfAUANsL4CgBpgfQUANcD6CgBqgPUVANQA69cvAKgB1lcAUAOsrwCgBlhfAUANsL4CgBpgfQUANcD6CgBqgPUVANQA6ysAqAHWr4oBwGAwCAPWu2jjciC6sn787pH8TVAyYgAQ5gsDhgkr1MCdWx9N27alJqfT6YoPgPF4/Nt+5/O5fX6VCn+mTvgTFgDUAOsbANyYJWMEmg7OBvxd3wBADbC+AYAaYH0DADXA+gYAaoD1DQDUAOsbAKiB27a+AYAaYH0DADXA+gYAaoD1DQDUAOsbAKgB1jcAUAOsbwCgBh7J+vgFYCSecJNnBkIAAAAASUVORK5CYII="
}

Change the path in above json file with the exact path of tabular editor .exe file that you downloaded in first step.

Save the json file that you created in previous step at the following location with the name “tabulareditor.pbitool.json“. If you don’t find “External Tools” folder then you need to create the folder on your own and save the json file there.

C:\Program Files (x86)\Common Files\Microsoft Shared\Power BI Desktop\External Tools

If your Power BI desktop is already opened, close it and open it again. You will see Tabular Editor appearing there under External Tools as shown below –

The benefit of integrating tabular editor within Power BI is that you don’t have to search/identify the local power bi workspace server and tabular editor is opened with already connected to the model.

That’s it!

Many thanks for reading!

Leave a Reply