Skip to main content
Microsoft Idea

Power BI

Needs Votes

Provide connector for SSMS as an External Tool

Vote (2) 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=="
}