DAXDebugOutput icon indicating copy to clipboard operation
DAXDebugOutput copied to clipboard

Add External Tool Configuration for Power BI

Open nfroeschl opened this issue 3 years ago • 1 comments

It would be cool if someone adds this external tool configuration to the installer.

{ "version": "1.0", "name": "Dax Debug Output", "description": "This is a free UI tool that subscribes to Analysis Services Trace Events, parses the JSON output of DAX Evaluation Log events, and displays the information in user friendly table format.", "path": "C:\Program Files\DAX Debug Output\DAXDebugOutput.exe", "arguments": "", "iconData": "image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAIAAADYYG7QAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAyrSURBVFhHnVkJXFTVGh9mgdnZBmRfRAhF4KH5Woh8IgmKqPkscUelCO2ppZLSK3taZpa5pmHPXNFcM7JyCVzKBVeUVdllX2cGBmYf+s+c+4aBGRbf/3d/er/vnnvu/3znO98yWHV1ddGeBeLWFmCYfwAl9w21Wt3U2Ojm7k7JgwOd+n9wkEjEP505zecLKLlfsFis8rKSB/fuUvLg8AyEOjpkWzZt5AsELq6ulGogDB8RdOr4sfzcR5Q8GGDLBoPOjo41K1ckzHqjQyajVIPDjydPvDEl9mlFBSUPhEERknd2fpK6ZriPx80//6BUgwZWMmv6VFzNTY2Uql8MitCxI4eGCNgfrVmt0+ko1bPgcuYlH2eH5clvY2GUqm9Y9iF8WCxupQQaraqyksvlzZg5y8rKilI9C8Ijxv5j/PjMi+ebm5spleET1F1PWCbU3t5WmJ9HCTSaVqtlMplsDoeSnxE4bi6ubgwGw7geWKKyvFyj0RDRFJYJ1VRVlZeWUgIIaTRYkE6rpWQTQF1fV/e4qBDjsQxKawZZezudTgcnSqbR8h49tDjeMqGC/LzW1hZKoNGwFKzJ3Mj37955/93kaROjpkZHTYmOnDktbveOra0t3ftCgBc75Z2gA05EA1OVFD9uqK8noiksE0I0U6tUlABCWoOFehLCeV4QPyP94P7S4uKW5ibY6c6tm+vWfrD0rcXVVVXUIAOw450dnTAPnd7tghhvuglGWCCEg/oo5wElGKC3EK2HhR4+uL8uNQWTUrIJfr/w2xcbPlEplZQMC2m1cnkng95tIdhbKpEUFXS7qREWCNXW1mDRDCaTkg0+1GvLThxLr6utpQQz/PpzhumSYGCFXI5jYWVCSKGQwzF6WR2wQKihvk4qEcvaZZRssBDehOWJaG7CXmhrk+Y+ekgJhiwrl8tNfQizqVTq4sePzf3aAqFAZKDgkPPnMow2wIxYE0BEbJ+RXF9QKhTUHdajViuVCljISAjuXFZazOVyzQObBUKOIqc5CxY+eVx06vhRouFwOPBxcSsVKhEk+y8/rG1s/EwGKJUqxGiwMRI6eugA4tD8RYlCoS3RdIMsvRcaGxrGvjD67yHDSVIsKiyIHhs+JXo89GTA5d8v+g5xFHFZFq+pMVEI9GQksGvbFqSO7Vs2w64QC/Jyg4Z6xU2IRDFDBpiiz1y295udmPqrzz8lIgw2afzYNe8vV6lUEOFVWzd/7u4gMOVBrjHBgdk3rpO3gF8yfgoL9NuzYxt5Ebu/YkmSi5CTceY0GdALfRKCA4WPChk1fFhZSQnRFD95jELiyIHviYjlotYZ99IY5F1CZZibc1LCvNyHOWQAkHP/3sTIVw/v3wcvJpqrlzO9ne3jX5/SVxljwYcIUIXFz5v/tLISqZ5o4Dcbv/r61vU/EaDhszADuCLBGROC0M7Ww9MLZxCHHGJtTU3arh1JS/41N2ERcV6UeHt2bId1E99J5vJ4hpfMQBGzhKqnT+FGwcO8797OplSGvVv2zltYItzCuE2mF/Tz3px+8bdf4TRwNeo1A44fPeLMt1k0Nx7roVRm6I8QAH+EhccE+f9n7eqcu9ni5qadW7/ycRH1IuHCt3YRWDvxKBE3vs52KcuWdBoKIJikorRkf9puOADoXv/jKpncIgboOjDjg+zr4nM7rOXNIicnT0+vrBv3Tt6ruFaqP0QYANcY5sRPneDPs2Z8d6PyUlET3crKSWD9UXSAyJYvDoixDxiVnXU+nFGhkTZltYsCXpk0b+EiFCRkfnMMQAjO2CFu4l34jN5aqVBq1LouAYcl6VCt+jH/zKM6FDhqbVf8aLdv40NpDPrea+VrMwrgLiy6FTRTw9w2nS85U8WYEzE82VfGFHlLxq20d/c1D4am6NOpCUAIHqpWa3Ra3YYLxbHfZh+7U23Ht178srfQhoWlIH+PdBWinoCthg/hc1h6B5erdScf1GpU2kh/ey5dEzNiiDWT0SoKonHtBgzxAxAyZkTYsaK1M7tCfOh2lVyh8bbn2HNZ2C8wGOkqaJerG6WKoSKes8AGJmfQrW6Wt+ZUS0PchMG8TnpNXhdbqPIIQ8Q3rdEswjIhqVSCqPPntSvpBw/g6KLMgGcwrGgshpVcrcU26UW6FVK1iG89zIlXVC/LrhQPEdgMdeTquvRma+lQZ+TWs1mMlZF+vo7cWzXyS7dzUVii8YWPU5+xhO4awwiki/eWvpOfl9smlSCe+Xm7vzHDn8YlI3vsPyyEj4HH5eKW8pbOuFDXIFdB5hN9xQhO5wsb3w739hHxNDp6joybvjettXGDg4ODrx8SXWBQSEhM7GQej0+mMqK3hbDHe3Zuu3YlC+UPXti6O233vgOeXt74Np6ae+MIFwGLxXjSKCusb6dpu4LdhExDWYjiEBRvVYhBrbhJ5vvypCM/nPpo/adu7h5XL2chdixNXHjiaDqZxBS9CWVevIDQjIS/5/sDew+mx8+Z6+rmri89DWex14HEt8EAhipp6oCHSeXqwCF8Ww5LT76Lxrdhutuy4X22NnQhi+bh6Tlr3oJDx0+dOHtu9vwEvI50iZxPpjKiB6GmxsZtX25ClpmXsCjytWh4NPbbNC5g7UYBegGbiZMlVWhqpIpmmaq+Telpx3G3Y8OcSOsv+NiHedhq1TpXoc0ITgfSKs4sUs2L4a8gBY2NjCopfrJv755ecacHoX1pe+5k30J1lvBWEtGggsEsGo2W+A5ehTuTezivmy3b057DZtLXxQRsnzESR0zIZj3nzMcjawZ9WogLnPr0wzpJp5pZebu+/IkxAsF1kpa+i3R2/Mjh2zdvECVBNyFkzf3fpSGGLln+nruHB1GitMMpq6woJ3Nh67BH2AuZSoMrwJlvx2FpdV2BLoJQd1sMwVEMdhUgIfk78SL9RbVSxa5r5Q+qpez22lNbPszKzCTTAhFjx8XGTUWzhc4J5RulNRJCrfT15k1oqaInYdjrRIlmKDlx4cF936GFAKHEl7z3zf4bsgRO/NXilpYOFcIMw5px4kHthG9uRu26sfn3ErwV5AozMSaOcHa24/xR2pLf0FGmtWPaMP1oDSuTFx85uB97h2Esa+vE5KVw1kvnfzuXcdbwQT0oQsVFRbdv3YANFyUlc7hcaJCQv/h0/fWrV0LDRrl6eMN/wv0cp4e6YoNO3qveeqUUFbJ+d9Ta+1WSp2J5jURxr0oi7VDBhwKc+FGBTnKF+pf8Bg8vn5GxC7Qsuwh/J6FOtnrFsm93bSd+Ezb6+TdnzwE/lG/dPQyeAegT/hkbgwoQG0c0sBmKr0Bv9+vXrtTlXC2/cvrw+mXTgl1eHergKrCxZzOdedZRAaLpIS4BIq4Dh4XLw5YdF+Q8Ocg5wImHG1yetuwvN37W2FBffTer4c75retTHTmsGZMnwuTkK4i9+OhIPy9UyUTTXX6gE3Wz4xkLQngPitFXRofW1dW2tbU1Nzffv3//xVGhdmwmvo0aw5HLwr2tDSXqNRwWRKIhNzHjXq2tqVYoFFKpVCaTIdg+5+WG2tz4u8wP6YfxoukPPd1OHTlhQtjzYwoL8omId9D/4pSiWQGEQmFISEjKmlShgG+IfPoQgDiEZEJEvcaQW4gG/w5xEqWkfogwhoPC4/GQyDhsDkIJnEGro1IsOmA3d/d5CxcbD2A3IXQkc+YnVD+tJF096CDPgxCLyUJGxKT4N+716QmJb5Px/QMfXrZq9bioCbhH7DA09nQoEWOVSiVJZ1hzYV7ezDnz/QOeM7ykRzchAEcMbi8Wi3Eva29XKBUwEGYhTwHcr1iVEjtlKiX3ASwXhyMxaQklG4EHKKFUKvTmkJCzsU5YgTwk6EHIwVEUFT2R/BCDJhdvcrkcrI48JbB3cPzsy63jJ8RQshlgjMVJyWs//sSGzaZU/4O+U6TTVWoVIi3Eyoqy6NjJ3r6+5ClBD0LAyxERtrZ2uJFIkOp1iBaYgjwyAmFz2+60mbPnmhqPwN7e4YN/f/zxho0Wf8vWbxyDgXWSUIRKa1KcmbGJb5uCOPy5n87iQIb4+5h2faZAyjvw370IDRiGXgJNGZoNlAnG82IOTIVhI3w9K8rKIGIrzAdbIESAs4AziaYTPTWKNUprhqbGhsuZl9CGoic0HmaLwCTjw1/wcBTikMtk7ZTWDH0SIkAb+ubUyejCEJYo1f8FtHjTYl6LGBP289kfsV+U1hIG/uMLQnbarp1Y/arUDwf5V45eQFWzbm0K8tLylSme3shC/WFQfw3CTl/JvKRUqqKiY/ppqSwC5fmxQwdRKE6MmzKYdwdFiABhg8PlkDM4SGDygrxcBPuhfsMoVf+g0f4CmMghylD4qFkAAAAASUVORK5CYII=" }

nfroeschl avatar Dec 05 '22 10:12 nfroeschl

Agreed. It should be installed to file and path C:\Program Files (x86)\Common Files\Microsoft Shared\Power BI Desktop\External Tools\DAX-Debug.pbitool.json

I've also tweaked the json.

  1. The \ characters in the path need to be escaped as \\
  2. I changed the image to have a transparent background.
  3. In a perfect world, the server and database should be passed as arguments (eg. DAXDebugOutput.exe --server="server" --database="database" so you don't have to press "Connect" in DAX Debug. I've stubbed that in here, but DAX Debug would also need to be changed to accept the command line arguments.
{
  "version": "1.0",
  "name": "DAX Debug Output",
  "description": "This is a free UI tool that subscribes to Analysis Services Trace Events, parses the JSON output of DAX Evaluation Log events, and displays the information in user friendly table format.",
  "path": "C:\\Program Files\\DAX Debug Output\\DAXDebugOutput.exe",
  "arguments": "--server=\"%server%\" --database=\"%database%\"",
  "iconData": "data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADAAAAAwCAYAAABXAvmHAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAAYdEVYdFNvZnR3YXJlAFBhaW50Lk5FVCB2My4zNqnn4iUAAAgXSURBVGhD7Vl5bNRVHkeB3vc5ve/S+5629G4pvduBcrQC5aiUQikDFAq0pRQKiLquAoqJYjQar3VjYjRu1qjZ7P5B9shm/9iYEP1DEzWuu5tdddd1VeTj+zx+M3bm92bamU7JbuIneZnfu7/f973e+86yH/H/jJPHjkD7dBuTRw8veg23cGLsIHb0b/LI5pt6Om4vEzOTx5GdHOexTe/q7QGLVl16RAV4Y/r4UY9umBQVioP79tweJpKjwzy+EdUxNzVx6Rm4MDuD9Lgoj290/LAZBRkpS8/A2VNTSI2J8PhG+4cGUbQqbekZoAGnGMKdbkRdrijIwarEGKkW7Y218xI2uLUfpTmZnmVA5aPp+2lwWlUHEhzht1JZ+td3O5zHvvL8bF3/+MFR95nqam7QTab/T4oMUS6al5akJHxuoapow23Q07oGlUV5ur49OwfcZ0Dl64+a9yMxIljXTmmpCLYvjtSvpa4KNWVFur7tfRuxe2CLe0zEBPvh3MxJm8mH9+9FfFigbkFKS0WwqmhTbFBXXoL6ilJdHwOcqn1BaK6pRHVpoc3k0T13Iy40QLcgDVVFrKpoU2xAo19TXaHrY3tbQ417DBCR/l42k6lC9m3EgeHdSmLtS2yIv5KY/PRk8MC0qhXRgT7uE09QfPbegfra09KkWzhZRGgV0XMLjVUbbgOVZ8tNTUD32kbleJfAjbVPKzqa6sDoqVWtoHrZE20pxrwsJTGqAHZoZBiLPn0LqkoKUJyVrlvM0TW4cbURvPBZCE+LjYQjd+goyNFVO4sbLoOEnD89rVtQ5ddJFD2YhYGS7AzMTk/qxu0d3KEkkISrHMWiQDtgoNKqNjDvHZKnRT22EK0q7N+2qXdewugkeLXQqp4DxVqWk4HTE+M2iydFhysJNgR4wRDoJbzWD238TokMxrh5RElgiVBVZ1eVRePVsU68sa8Sf5zuwqePj+CFXRXYUGCQrtVCZJjvCpQnhuCV3Ua8OVKJzUUxCPVZgXDflciK8sdzA8X45WgNXrx8XhI6O27G2xMmvDFShWPbPKj3Knz37CjwcA++eqADX9zfLr//eW8b7q5IQKggnAwEe6/AcFUicLkbuGLCY30Fkqlw0UepkDG2X+jOgbEoHxdH+/D1g5248bRaKh7FV0/tw3cXuzC5NgO1qWF4fnsJ8EgPrh2uQVKIrySSp/3whjzJHMtvzFWIC/KWfWRua2kcvn2oC78bq0F9STauP2oWzPbgb7+4cnsYuCE23yKI8LrzDrRlReI/Qhofz65FUWyQlEJsoDd+NbpaSujTcy34SPQVxwVJKYQJNUoN88UfjtRKKY7WJuPdk024+di2pSf+7MQYPriwDjcvdmOgLA7+K+9EfVoYPr+vHZ+cbUFpfLA84YKYQHx4phm/H6vFq0NGedq0kxAhGYuKTbdkAJe68f7MGtl/bWZ+7+Qy1ne0yFeVIchXBCYfVOWl4/pMO26KjW8xsBwNdgwEei2HKS8a3widfmZbMc60r5Iqdqo1w8oAVcyYECyZpIp9e8mEK2MDqDaWyHQNA+fWjetxeuqE+0zxmsDNMuKjsfOuzdaFvnxyGDeEDZCBAAcMTDSnS8JOilPuL46VJ/3zXaVyPRbaAn/ZRmN+Z8r2frSxux0J4UFyDCO61uwa6PN5+lrVCosNOJIAT1catiCaxFcmheAz4aX+fKIeaeF+0pWyJIf64tqhaimdj2dblEQyQJKBisJc15jg/ZvcMwOhNVkxlwFKYK4NlAhDTQzxwZ/G6/CZaKOXShdEX59slEzUibFkkKrUJ5ijEXMtqqS2vA6bTZ2SlgUn0pj34QRHr6B/Xx2SbtQigcb0cOltyAC9EE/87/e04r8/7cRbIoi9PlyOf1xok4Y/tDpRGnCUCHov7LglpZ/tLJX9/7rqOCvHJyxVWas6R2aCQRqtVrXBzNEDQl/XWo2Y+m6uS5H196abkB7hh+3GeHmqX/6kQ7pPFgY62sTl3lwEeS9HdXKodK90vZTS2/tXS090/6D6dstLHw91YPMG50zwesyBqqxzT2uz1FuqB4POrw9U4SVxen8RhOARE57oL5Qx4AFTjjTMp7YUISc6QF4dLEZNQqNEJD7XQc9kwotCCqF+Xnh8r2Dwyjq8PFiGgjR1etHiDbWqGjRcVcahb12XNDxTUzU+uTQgGDBJT8STpm6/JLxJriFA3odeGyqXKnZABKgAISFKqWVVhBx3faoRNSlh+K2IwAx+lGJ+9q1k1o2rO/DXe9qkRAzB+mcnbYCHy7eG1qRHb2er8h7OSVlJsTbtz5wxY12+AXViwxgReWmc1O3mzAj0iqCVKdSJUZclPtgH3blR6BIlM9JffrMkiHZtOSseOjMhD2tDV5uuj7TNmwDmQ0T7tIJPQfvsBFFRXCg9Conk6dC/s05DtbTJdvHNNku75bu1Qf0ao7qo3txca15v1LmmHlPjYzaD+LhWpTwIqpyFUFeKM6/C/Zg40KoSE0cOgZkLreoczIZpnxLMRqvSjMT0iXElgc7KfI91vvwaKstsxpjampVPWiXGRvfZDKTuOfsfiwyrCHVU5vtjjyfN+5BWleD1Qvt0HfQu9lKxBz2Viti5hdcCVSrGHoWZqQ5TMG6Bmy8kwTqye5dUD3vCWVz5V4dZDDKhVRcPqtCCDUiAbpdzKDnmhBaSiZgLzslJifccAwSzZ25niV0AvR2z357+F1SCN0OPZsvsQE9Tayxe2kO69+xpnJo45vFNeGGz934/4n8fy5Z9D0tgEzzk+MsUAAAAAElFTkSuQmCC"
}

somedaygone avatar Dec 26 '22 17:12 somedaygone