Skip to main content

Power BI

New

Provide connector for SSMS as an External Tool

Vote (1) Share
Michael Rudzinski's profile image

Michael Rudzinski on 11 Aug 2020 16:56:50

The External Tools feature is great, but why no SSMS connector out of the box? Probably because SSMS needs a command line switch to login to SSAS instead of the Database Engine. Hoping the Power BI team can exert some influence on the SSMS team to get this done!

ssms.pbitool.json:
{
"version": "1.0",
"name": "SSMS",
"description": "Microsoft SQL Server Management Studio",
"path": "C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 18\\Common7\\IDE\\SSMS.exe",
"arguments": "-S %server% -d %database%", <<<<<<<<<< NEEDS SWITCH FOR SSAS LOGIN
"iconData": "image/png;base64,iVBORw0KGgoAAAANSUhEUgAAACQAAAAkCAYAAADhAJiYAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAAAAYdEVYdFNvZnR3YXJlAFBhaW50Lk5FVCB2My4zNqnn4iUAAAXtSURBVFhH7VhrTFNnGMY5t2WZWZZd1Lkl++cPd0mW+WMmSzaXKCALIDhFzTJBHXN/pps44hRUdODibU7FzftlcvGKM1NuolwrBQoUFCiXtiDUtvR+zuk5bZ+951AuFaStc/GPT/LkHM75+r0Pz/t85fsIeYrHCY+Lg5uzws2aiGZ4eAbeVw8F47TDxJjQz/SPovicFVi/cwzBQ4Ndtl441aVgGk7BLtsHW3k6bKVpxG2wV+0GU/sn2JYrEAx34aHi3o9K4AUOecoL2FKQipT8TcQUn2ta4Vbc6rgZmCCxgEOeCfOVFTCfXwxTbixMOTHEBSNIP+eKXAjTxWWw3dwMZ1cJ3E6bVITjHdh7aye+OB6B+cfCRzH6ZBSy67PBu/nxRbnMXbAWrkd/NhXNjpZoPBuF/ix/jIY5Lx5s61WpgFNgcFSWiWVZSxF3Jg5LzsZJ19hTMQg7HIqoE5HIUmT5FyTcq4ZZ/M29Ysw5A9dAaS9LGyrgpNzZyDEbR/ReSzpKEH40DFEnI5EdiCC3qRbWa19SS4aLBORQdiS1dy6YmsRxC8i18uAc8rD14FsTwFQuhY2EWS7HwHxuuH3DjCL3RBFhNOZT2K9/AK7iNbhUEeML6pYH55AoSFCvhNC1EnxbApzKr8HIv4KjchnspUtgvxFBxd+DvXAGmJJ3wJZNBSebDL7mWfB1EyCowh+/Qy7NKl+SwEEKbfMg1E0kPgNBQQIkhgzR1R42boG6nlosOBmNxWcW4XzDufHFiBhySBTgFcSTW4PPBNU8yYmH0Z9DRocRBa0FKG4rQqexMzBBI91xa4fvJbaH+jjyIP05FDQeTdBw6/4XQUPt8bbNb8uU0+C8Owu8YpLflgWN4BwiV5qmg+/bBYdFDlYVC1dH5BN0SPkWON1+lKu6kVnWDZ1BCeb+kVGCGN4NlZ5Fm56BU3AHJzgwhwac4fr2ory9D7P3KDAzo5buDXByfT4Fey1ObL2uwWe/NyItXwMr6wpe0PgOhZIzb5OYgyi+24OP99Tj1Q1V2F1CxQzFEHq3+BTcUaTGS+srEHm4GZp+LjgxIjyMH4fUy8HrfoPObMaiE3fwzNoKzEyvRa1GD6s62SdDJkZAaGYDJv5QjrmZSmoZCws5lFOnR4vO/wZPgodthqD5bgyHSExPEpyWYlR33sPuG12Ysb0GE9aU4eXkKmzLV8NorIWj94CPoLkHG2hMKSb9OOBSUl4nPvy1DtVqa4CCXBa4jGcgaNfApU0c4dC34A2n0Ws2IY6ceXF9JSaTkPizrfhkXwPeTLmNjCINdBbLUKE+qxMxx0QXyzGBnHxuXQVe2SBDzNE7uEfZ8g7zD4+bgeBQ0Nb0FGUiHUJ3MglcS/dbwdnqcbWpD+/vqMG7FOT6HivkGhu1pAlTN8mQXqiFlXNBb+eRdLkTb2yU4aOddZi9tx6zdimwKlsFRY/vdjdgeNwsbebv06ZeBcGuAGu5DdbRDpbnca3ZiNNyHRh+YNXIqAVzDjRKTm2+psGGq114/WcZ5pFQUXCnkUOHgaXNveBfjJlOEsWqAvzdfAnVWtmjqSeIhT8/oMTz1JrJP1UhijKjvOcIfr5WfSsSL3wj7VG2FQ1vQYOFzsYjMUclraoXkirx/YV2mJkgv3dEtNxvQUJuvLSTS6Vji/dxUBAzs44yM4VyNGe/kjLTgCmUn1+8mfIOCwz/VZCBxKTla6XMhB5SooFCK+sayNS0lGpafd3BOSUKis9djrAjoUilg5z3cUCQnLnUKa2wWFriTb3DmanR2qRQT9lYhe3BODXSoeR/kiHu6obIGGGi0HuH+oCjP5S7SnokZ8LImeYRYgZxWy0GvRHTU6vxR0UvxM94Xz0cIx0KPxImHeYGufB0LFZfXI12Y/uYE/1Vo5eCPNKZByE6lZDVhrxGo38xIlr0LVh5bgUijs0fzePzJbEqg2rMyZyCB0a7/++WPisPp8sTmKAeSw8OVWUi40bGKO4oyZDe6Wy6wCZ7XBCPulbOOibtD/xn4ymeDEJC/gXPT2rPHiekLgAAAABJRU5ErkJggg=="
}