Installation Options
Below is a matrix of the supported features for the different types of installs you can choose with DAX Studio.
The "All Users" vs "Current User" is the first option you see when you run the installer. The portable version is a separate download.
Wherever possible we recommend using the default All Users install option as it gives the richest user experience. It is also the safer option as the executables are installed under the Program Files folder by default where it is much harder for them to be affected by viruses or malware.
| All Users | Current User | Portable | |
|---|---|---|---|
| Requires admin rights to install | Yes | No | No |
| Requires admin rights to run | No | No | No |
| Available for all users on the current machine | Yes | No | No |
| Excel Add-in available (1) | Yes | Yes | No |
| Power BI External Tools integration | Yes | No | No |
| Can be run from a USB drive or shared folder (2) | No | No | Yes |
(1) Installing the Excel Add-in by double-clicking on the .vsto file is not supported. It will not register the add-in correctly with Excel and the add-in will not function correctly. You must use the installer if you want to use the Excel Add-in.
(2) The current user will require full read/write access to this folder. You should never copy the portable version to a folder that requires admin rights (like Program Files) as this will prevent the program from running (as it assumes it has read/write access to local folder).
To swap between the All Users and Current User options you have to do a full uninstall, then re-install with the other option.