Why am I unable to see DAX studio or the External tool ribbon

[monojchakrab]

I have download the latest versions of both Power BI and DAX sudio, but still am unable to see the "External tools" ribbon and Dax studio within it...

I have seen some posts on this community, but that is not solving the problem.

Is there any solution avaliable for this?

sidebar :

Dax studio version : 2.17.3

Power BI : 2.107.683.0 64-bit (July, 2022)

Thanking in anticipation

[Greg_Deckler · Accepted solution]

@monojchakrab External tools will not appear until you install an external tool. It is possible that something failed when you installed DAX Studio and it was not able to copy the JSON file. You could do it manually like by copying this JSON to a file called daxstudio.pbitool.json in the following directory:

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

{

  "version": "1.0",

  "name": "DAX Studio",

  "description": "Use DAX Studio for DAX authoring, diagnosis, performance tuning and analysis.",

  "path": "C:\\Program Files\\DAX Studio\\DaxStudio.exe",

  "arguments": "/server=\"%server%\" /database=\"%database%\"",

  "iconData": "image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAEEAAABBCAYAAACO98lFAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAADKxJREFUeNrsW2tsFNcVvrM7u/b6wa5tjDGG2BADhVbikYRHg4Kb8KOVGoVWVJXaEhypLSIl6vZH2pQ0ZUmrRFFEsSNUSqImpmn/FErtRiA1VcvSEBpeYR3AEPNaE/zAL9bv1+5Mz5mdu3vn7p3dWduYVPWVxrM7ntf57nfO+c6ZWUlVVfL/PmxkekyDMA3CNAjTIBiGfC9OumjBgyuLS+Y+bLfb1xFJynM6nQ/hdmdGRvGVxV8dLi8vX3B064bWzwsI0nhS5NJFi/Mlm+2RwqKir9ls9gftdts8u12eBUZ77LLsYvdtb2slne3tse/K93eTyNCAOi/Xue3EC9/e/7kGYcnCRRtmzS5eAEY9qc0izKYkSS6H0+lh97txtZEMDw2RXLebDPb3k0gkYjiPJz+fhLq74xd85hUSySshkZ4ukj/YXnf+1a0b7zsI67786FyHM2OfLMtLbDZblsPhKIRZjrnJnZYW0tXZYTioYGZhwrbsnBxtPQBAsKOwaDbpuNMWD0KbfkrUL64jyvAAifR2E2dn053y8oUr7qd7yMCDma3Nt7/uycs33CxrhJWBxiMb+DE2Nmrc0NNObBmZRLLZiWS3kzGHs6jh5q1bj/363e/8+xebD47HiMe/8gSyswKW5fqajgAsVf869s9gUhDampu1HQYH+glQnYyNjiY3IsnIzHSRvp4ewzaHwxldw7nBpYgtPEiG7A7goI3YbBJQQyaK7JCDdzv/vGrH/ndPv7L16TSN9+qLW7RPKgBodgjjB/RlpwAEagQ7hoeHSKbLpcUCOiAoakYhGxAMBA+Ptct2zX3wGLzG4K1GYpckjQnEkQHHRBkhATB3ejM2L3l+37r55QsfTeUeAADOeK2Z8cg5WCotB8bysvmqKIjx29BwNDZ3hpuoqkIURY0CAkbjegZsb2tpNgTHhFjhyiHyy0ein+HaeB4SCRMVQFOGIE70hYjU2TRUMsO1+YMXv/cXEwDQuHdS2PYNYEFtOjqhCZZSZALeNFLXDjMUUSLE7fZonykDRoEpaCgb8KgLIEB8dkC2ZOlAaGOICZzICNRrwAI1eJHIIwPE0XaDjIa6XF2D3ZA1EkEAANDvq1LYdcAqADEQ3J68bhAypWgEDpYN6B5oCG+cKFZQsNiBx/GxQvnbXpIDsaGvvZmo1wPx7TrzCLBGdjjMglFNEhegE+q1EE+QTX6MGRoIPaG7n8BqBfoun+KoG/Db2Vixes0abb1sxXLNRbq7usjhQ4dMAZNOHiauWbOIOjhIMoFR1KVwP2QeAh8JR5aasGBZCvs2gmGhFACU6WxCtlRSdwgmS33a7AiCo//DExAHZiT879RHH5GjR45o7oHGoTsgaDRY4rHhsbAWE3iXYuJHschAC24QsOABNKBuAUC2y0w+1WKAaIgyRFZWFri0lLC9ra2NBG8GNQAwfqBBeF4+4NKUmcSlSschGUIW3MDHsWmdzB6MNMTASKlPIzu6A7KBnU1FUUjjlU/JQ488rO2z7Qc/1BggyjAiEPFaKNBE7kcHZK2ya4io9VEJRtaYsUFPqzu5zbNt0cDoacB4gEbn5OZqeZ26AM4m1gRoGFKXrgcHBkhzc7Ol4EiFWEo1mTjK0mQCUtwPxnpNhFWN4JgVGhPOBc63A+oxmczXBaKBGaO1Na5nSubOJWYulUqIUf2B8QPEIymGcw1B0AR3w4jrT4fuOhB79FmvZIJkjZmLsf2EevQVDFpWBho2PDwc+04DpBn13ZANkA3UpZAxUKwZ1CSCT2OF7iaZ3KkCabDiKQz4AEatXk+YxZh+mUdZpP9FMhnH7c8+i/N2/nzNnXA/Xjrj8VChJsQKEeu4WLF8AiBQVmxJsc9VFgSk3XqRn2JcwGyAlKVqUktrTFCbUzJH269bN4qvSJ0ChmCsEKlM5h48XDEUgpntSSGW0h0Bme8J5OTkGrIAXctQCN2FmRxgZpP1/0WLF2uzqIBBBpmcqvJMLsSWi24aJ2uSAGjCTCIzAJzVZrevl/T39go7RLw7ICMuNzSQJUuXxmKCSCanI8Si0l2lLjWZM24mwePdZrih23hT4bExbXasCCb09b6++CwiGGapj2UNnh9ZhzEBK1JcIxi4RhY5nRkaiOhSkLW+NMG0aTbqgQU+Q3YAURLANGkmk4WGwaxfbWwkq1avMmQIZAJbjUY7zU7iKikhQ8AmdJuommwTiiuuIr3N5HrvOJVkQq8BJqLSrOWuBR3RrPPb0Egb3Cgqx5gDr1xJboDAi0TCCdUol/qSiiuMK3qsqIbJ0bLWE49vwCDpm6jxAG5tVna2t67uryEzEAI0Q7ACBqnscDpIfsFMYpdljRVjupK8eOFC7OAR0A1IYaQ1b6wVmWzoQWRnt7FG5xUUVIGAcqM2URngUwU+vTj0gy0BsMn/3nt1oaQPXwoKC51IwVygtVbO6gKGGqHFji5zI1avXUNq3n7btF+ZjhCTZcd2yoKntzxTkZmZuQWZlAUxa3RkRHOnMfisGAN4k14iB8Df/eN6AtXV0fE+rNaKWucJHSJ9nDlzRnhikUwWZY1weIzk5RdAPlBj3SwYR898fDbWVZJluQrdDhcUXXhubAsiWJFwGI5RkB2oeCtqaw+HvnDwlgeWSotBNMi7QzCdDpFZc4UPrsmq0dGRYc0wRjniBb5Lv2zd9iMfuOAymw4CNm2wL4kgoLuqIL3xGPhe+ac//iHE9AusaonjQhDMZLKIzmjM6VOnYxmidP4C0t/XR1ygMKmxtEWHiygTYP3AlsPUDZ778U/KgAU7lehMR0HA5iwDhBpt2Ppq3vm9JqmBARvTFVNCEHDWab+RpisEBVtfbE2AaxcH1uyiWeTUzRvCp1QIokgmMxqiDgCoZdyghrqByrBAA0Jf4M/xt978XZUOgFm5bB0EbGCsXb021uuz6dkBbx4DEPYQurs6DSfog30aGi6RxyrWG7SCaDCpT+RShucEP/v5i14AYb0IBDUOAriB4dlCqiasJSZgiqun7Sf0fzYGZGXnCGOFAxQemyGwtwApjpSWlZLDBw9pHadk/UpdiPmoG7y0cxe6gU+JgOE2CoIKDFB0V4gtvjeqfxPUWVChl89kwiDQktphUvWJUt8VqB/o+OamTYb/Xb7UEAOBVZO4piMjM/Pq2Y/PVRncIKK4FUnRDDeAQGMCUY/vfv21CblBMhACZiW1WYeoo6MzsVMBNcW1a1fJKORyFE80jiCdWf2BbgCgPEm/vPra65WyHdxAooFQdwMlCoASdwfWDXwTkdNpMQEDIAY8GjipmrwbCpG39r9Jrl+/ocUMrCwj4Yj2HJL3f62TZMw6vvqLFz7FD7v3vOEBAKqMADCxIO4Ku3718k7qBuV6yX1cUGiVcp0zUXuuXsgEWs6yOZ1qh6yc7NjjOGog7rNv796EE4nkM9eDrIc4EHcDu70mIkluCUURxwJFjQFR/8uXdsTk9JVvPXCNGB/HEx0cH9dZ9sK+fktMAPVmHx0dIRiUkPaivM4bls5jfU6IxSi997f7N4IoekpiswHSn/mss8BLJnkkvL2GchWNDN3t1lJksr4AL5Ot9iD0fsUuLN91AGKBDdUjBEatUJPpAqpQ/1y944Xn/ZMNgpysiBHJZJGkTpb6+GoUlWR4bKzp4uUGX7L8jmDQtc6AJmCEj6G7P01leAyOsSSbY/8wzRAcE6iaZHuT7GN9vhpF93J7PF7WDZLld3zUpz/u825/7tmQDoB3EvuMpkwwZAhaAEXFkkpK5j1ABjAO6O10VIL9/X0J8UN7NpH4WL/6XOB8Le8GqYqc7c9urdUBKJuE5kpqEIDaLTibGRkZGs3ZdphZh4grgsxkchNngBWZy792UzXJLXcxCDCjjTTF8bObTodI8EZbrEJM5Qas0cCCIFMh0mN2pTiugnOZA0T8CkLQzB0C6aY+0+cK8eB6AADw6wCUWXSDegCAZw7VB0ldQtcJLAg1lnUCGxPG80Yb1l2z58ypD4cjn2C3R1EiHxQVFzd/+J+TveOo9ryCx2qTPoQg0PY7BjU+9SEzILq3znDPGIFRB2LmEixnIF62nDh5oj3VBYEFViP7AWCBn0zBMNUJCxYuug5MaIHZDEJZfAzydANI1otg6MB4L6a7gZXI3kNSvHyll87JBt9fXG6iE0KmILz/j7+X3wPQfVbdAFiQ6l2EY2lee49Z+p3qH31UWNgHNUHNVN7UVINgpeb3TvE93ZtfviRLeST5e4jVwIJkL2Lsugf3FJxqEFDtmb2T3JQqaKbSBv8T7qD7erUJQzZaCIb3ZEj342fCeqqk9UCAFkf3a0jTv5We/l3kNAjTIEyDYBz/FWAANDKEPFNGInQAAAAASUVORK5CYII="

}

[Anonymous]

I was having issues with this, I found that it was because when I did the installation I was selecting "Install for me only". If you use "Install for all users (recommended)" you should be able to see the JSON created automatically (in folder C:\Program Files (x86)\Common Files\Microsoft Shared\Power BI Desktop\External Tools).

If you look at the JSON file, Power BI should be installed in path: "C:\\Program Files\\DAX Studio\\DaxStudio.exe" (Folder: C:\Program Files\DAX Studio). Using “Install for me only” will install it in the path "C:\Users\UserName\AppData\Local\Programs\DAX Studio" and because of that, it is not going to work.

If you already installed it using "Install for me only" my recommendation is that you uninstall and reinstall it using the recommended option.

[otiliagaino]

Excellent!!! So simple! few words and everything is sorted out! 

I uninstalled the DAX Studio.

Installed again, choosing that option - Install for all users (recommended)

open Power BI again and the External Tools was there!!! 

Thanks a lot for sharing!!! I really appreciate it!!!

[Greg_Deckler · Accepted solution]

@monojchakrab External tools will not appear until you install an external tool. It is possible that something failed when you installed DAX Studio and it was not able to copy the JSON file. You could do it manually like by copying this JSON to a file called daxstudio.pbitool.json in the following directory:

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

{

  "version": "1.0",

  "name": "DAX Studio",

  "description": "Use DAX Studio for DAX authoring, diagnosis, performance tuning and analysis.",

  "path": "C:\\Program Files\\DAX Studio\\DaxStudio.exe",

  "arguments": "/server=\"%server%\" /database=\"%database%\"",

  "iconData": "image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAEEAAABBCAYAAACO98lFAAAACXBIWXMAAAsTAAALEwEAmpwYAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAADKxJREFUeNrsW2tsFNcVvrM7u/b6wa5tjDGG2BADhVbikYRHg4Kb8KOVGoVWVJXaEhypLSIl6vZH2pQ0ZUmrRFFEsSNUSqImpmn/FErtRiA1VcvSEBpeYR3AEPNaE/zAL9bv1+5Mz5mdu3vn7p3dWduYVPWVxrM7ntf57nfO+c6ZWUlVVfL/PmxkekyDMA3CNAjTIBiGfC9OumjBgyuLS+Y+bLfb1xFJynM6nQ/hdmdGRvGVxV8dLi8vX3B064bWzwsI0nhS5NJFi/Mlm+2RwqKir9ls9gftdts8u12eBUZ77LLsYvdtb2slne3tse/K93eTyNCAOi/Xue3EC9/e/7kGYcnCRRtmzS5eAEY9qc0izKYkSS6H0+lh97txtZEMDw2RXLebDPb3k0gkYjiPJz+fhLq74xd85hUSySshkZ4ukj/YXnf+1a0b7zsI67786FyHM2OfLMtLbDZblsPhKIRZjrnJnZYW0tXZYTioYGZhwrbsnBxtPQBAsKOwaDbpuNMWD0KbfkrUL64jyvAAifR2E2dn053y8oUr7qd7yMCDma3Nt7/uycs33CxrhJWBxiMb+DE2Nmrc0NNObBmZRLLZiWS3kzGHs6jh5q1bj/363e/8+xebD47HiMe/8gSyswKW5fqajgAsVf869s9gUhDampu1HQYH+glQnYyNjiY3IsnIzHSRvp4ewzaHwxldw7nBpYgtPEiG7A7goI3YbBJQQyaK7JCDdzv/vGrH/ndPv7L16TSN9+qLW7RPKgBodgjjB/RlpwAEagQ7hoeHSKbLpcUCOiAoakYhGxAMBA+Ptct2zX3wGLzG4K1GYpckjQnEkQHHRBkhATB3ejM2L3l+37r55QsfTeUeAADOeK2Z8cg5WCotB8bysvmqKIjx29BwNDZ3hpuoqkIURY0CAkbjegZsb2tpNgTHhFjhyiHyy0ein+HaeB4SCRMVQFOGIE70hYjU2TRUMsO1+YMXv/cXEwDQuHdS2PYNYEFtOjqhCZZSZALeNFLXDjMUUSLE7fZonykDRoEpaCgb8KgLIEB8dkC2ZOlAaGOICZzICNRrwAI1eJHIIwPE0XaDjIa6XF2D3ZA1EkEAANDvq1LYdcAqADEQ3J68bhAypWgEDpYN6B5oCG+cKFZQsNiBx/GxQvnbXpIDsaGvvZmo1wPx7TrzCLBGdjjMglFNEhegE+q1EE+QTX6MGRoIPaG7n8BqBfoun+KoG/Db2Vixes0abb1sxXLNRbq7usjhQ4dMAZNOHiauWbOIOjhIMoFR1KVwP2QeAh8JR5aasGBZCvs2gmGhFACU6WxCtlRSdwgmS33a7AiCo//DExAHZiT879RHH5GjR45o7oHGoTsgaDRY4rHhsbAWE3iXYuJHschAC24QsOABNKBuAUC2y0w+1WKAaIgyRFZWFri0lLC9ra2NBG8GNQAwfqBBeF4+4NKUmcSlSschGUIW3MDHsWmdzB6MNMTASKlPIzu6A7KBnU1FUUjjlU/JQ488rO2z7Qc/1BggyjAiEPFaKNBE7kcHZK2ya4io9VEJRtaYsUFPqzu5zbNt0cDoacB4gEbn5OZqeZ26AM4m1gRoGFKXrgcHBkhzc7Ol4EiFWEo1mTjK0mQCUtwPxnpNhFWN4JgVGhPOBc63A+oxmczXBaKBGaO1Na5nSubOJWYulUqIUf2B8QPEIymGcw1B0AR3w4jrT4fuOhB79FmvZIJkjZmLsf2EevQVDFpWBho2PDwc+04DpBn13ZANkA3UpZAxUKwZ1CSCT2OF7iaZ3KkCabDiKQz4AEatXk+YxZh+mUdZpP9FMhnH7c8+i/N2/nzNnXA/Xjrj8VChJsQKEeu4WLF8AiBQVmxJsc9VFgSk3XqRn2JcwGyAlKVqUktrTFCbUzJH269bN4qvSJ0ChmCsEKlM5h48XDEUgpntSSGW0h0Bme8J5OTkGrIAXctQCN2FmRxgZpP1/0WLF2uzqIBBBpmcqvJMLsSWi24aJ2uSAGjCTCIzAJzVZrevl/T39go7RLw7ICMuNzSQJUuXxmKCSCanI8Si0l2lLjWZM24mwePdZrih23hT4bExbXasCCb09b6++CwiGGapj2UNnh9ZhzEBK1JcIxi4RhY5nRkaiOhSkLW+NMG0aTbqgQU+Q3YAURLANGkmk4WGwaxfbWwkq1avMmQIZAJbjUY7zU7iKikhQ8AmdJuommwTiiuuIr3N5HrvOJVkQq8BJqLSrOWuBR3RrPPb0Egb3Cgqx5gDr1xJboDAi0TCCdUol/qSiiuMK3qsqIbJ0bLWE49vwCDpm6jxAG5tVna2t67uryEzEAI0Q7ACBqnscDpIfsFMYpdljRVjupK8eOFC7OAR0A1IYaQ1b6wVmWzoQWRnt7FG5xUUVIGAcqM2URngUwU+vTj0gy0BsMn/3nt1oaQPXwoKC51IwVygtVbO6gKGGqHFji5zI1avXUNq3n7btF+ZjhCTZcd2yoKntzxTkZmZuQWZlAUxa3RkRHOnMfisGAN4k14iB8Df/eN6AtXV0fE+rNaKWucJHSJ9nDlzRnhikUwWZY1weIzk5RdAPlBj3SwYR898fDbWVZJluQrdDhcUXXhubAsiWJFwGI5RkB2oeCtqaw+HvnDwlgeWSotBNMi7QzCdDpFZc4UPrsmq0dGRYc0wRjniBb5Lv2zd9iMfuOAymw4CNm2wL4kgoLuqIL3xGPhe+ac//iHE9AusaonjQhDMZLKIzmjM6VOnYxmidP4C0t/XR1ygMKmxtEWHiygTYP3AlsPUDZ778U/KgAU7lehMR0HA5iwDhBpt2Ppq3vm9JqmBARvTFVNCEHDWab+RpisEBVtfbE2AaxcH1uyiWeTUzRvCp1QIokgmMxqiDgCoZdyghrqByrBAA0Jf4M/xt978XZUOgFm5bB0EbGCsXb021uuz6dkBbx4DEPYQurs6DSfog30aGi6RxyrWG7SCaDCpT+RShucEP/v5i14AYb0IBDUOAriB4dlCqiasJSZgiqun7Sf0fzYGZGXnCGOFAxQemyGwtwApjpSWlZLDBw9pHadk/UpdiPmoG7y0cxe6gU+JgOE2CoIKDFB0V4gtvjeqfxPUWVChl89kwiDQktphUvWJUt8VqB/o+OamTYb/Xb7UEAOBVZO4piMjM/Pq2Y/PVRncIKK4FUnRDDeAQGMCUY/vfv21CblBMhACZiW1WYeoo6MzsVMBNcW1a1fJKORyFE80jiCdWf2BbgCgPEm/vPra65WyHdxAooFQdwMlCoASdwfWDXwTkdNpMQEDIAY8GjipmrwbCpG39r9Jrl+/ocUMrCwj4Yj2HJL3f62TZMw6vvqLFz7FD7v3vOEBAKqMADCxIO4Ku3718k7qBuV6yX1cUGiVcp0zUXuuXsgEWs6yOZ1qh6yc7NjjOGog7rNv796EE4nkM9eDrIc4EHcDu70mIkluCUURxwJFjQFR/8uXdsTk9JVvPXCNGB/HEx0cH9dZ9sK+fktMAPVmHx0dIRiUkPaivM4bls5jfU6IxSi997f7N4IoekpiswHSn/mss8BLJnkkvL2GchWNDN3t1lJksr4AL5Ot9iD0fsUuLN91AGKBDdUjBEatUJPpAqpQ/1y944Xn/ZMNgpysiBHJZJGkTpb6+GoUlWR4bKzp4uUGX7L8jmDQtc6AJmCEj6G7P01leAyOsSSbY/8wzRAcE6iaZHuT7GN9vhpF93J7PF7WDZLld3zUpz/u825/7tmQDoB3EvuMpkwwZAhaAEXFkkpK5j1ABjAO6O10VIL9/X0J8UN7NpH4WL/6XOB8Le8GqYqc7c9urdUBKJuE5kpqEIDaLTibGRkZGs3ZdphZh4grgsxkchNngBWZy792UzXJLXcxCDCjjTTF8bObTodI8EZbrEJM5Qas0cCCIFMh0mN2pTiugnOZA0T8CkLQzB0C6aY+0+cK8eB6AADw6wCUWXSDegCAZw7VB0ldQtcJLAg1lnUCGxPG80Yb1l2z58ypD4cjn2C3R1EiHxQVFzd/+J+TveOo9ryCx2qTPoQg0PY7BjU+9SEzILq3znDPGIFRB2LmEixnIF62nDh5oj3VBYEFViP7AWCBn0zBMNUJCxYuug5MaIHZDEJZfAzydANI1otg6MB4L6a7gZXI3kNSvHyll87JBt9fXG6iE0KmILz/j7+X3wPQfVbdAFiQ6l2EY2lee49Z+p3qH31UWNgHNUHNVN7UVINgpeb3TvE93ZtfviRLeST5e4jVwIJkL2Lsugf3FJxqEFDtmb2T3JQqaKbSBv8T7qD7erUJQzZaCIb3ZEj342fCeqqk9UCAFkf3a0jTv5We/l3kNAjTIEyDYBz/FWAANDKEPFNGInQAAAAASUVORK5CYII="

}

[monojchakrab · Accepted solution]

Thanks @Greg_Deckler.

Somehow, when I restarted the machine, it popped up automatically, without having to manually save the Dax studio JSON.

Appreciate