About two years in the past I wrote a weblog submit on how to hook up with a Energy BI Desktop mannequin from completely different instruments like SSMS, Excel and SQL Server Profiler. A giant chunk of that weblog submit was about other ways of discovering Energy BI Desktop native port. Having the port quantity is essential if you wish to hook up with a Energy BI Desktop mannequin from any type of instruments for various functions like monitoring in SQL Server Profiler or analysing the mannequin in Excel. I’m requested a number of occasions right here and there about completely different scen individuals want to seek out Energy BI Desktop native port quantity, so I made a decision to dedicate a submit to Energy BI Desktop native port quantity.
While you run Energy BI Desktop, it runs a neighborhood occasion of SSAS Tabular mannequin within the background and it assigns a random port quantity to that native occasion. Subsequently, if you wish to hook up with the mannequin to analyse it in Excel that you must know that port quantity. There are a number of methods to attain that port quantity which this submit will cowl most of them.
As you might know, Energy BI Desktop is now out there as a Home windows App that may be put in from Home windows Retailer. Normally, the primary distinction between the App and the downloaded version from Micrsosoft web site is that you’re going to get notification every time a more recent model is on the market to obtain. Then it’s a must to manually obtain and set up the newer model in your machine, however, the App will probably be up to date robotically. However there are another variations which might be out of scope of this text. There is only one distinction which is related to this text which is that Energy BI Desktop creates its short-term folders in a unique location than the Energy BI Desktop App does.
The strategies described on this submit works for each downloaded version and the Retailer version.
· Utilizing DAX Studio
· Tabular Editor
· Energy BI Desktop Non permanent Location
· Command Line (CMD)
The explanation that I clarify completely different strategies is that not all strategies are doable in all environments. Chances are you’ll work at a buyer web site that doesn’t help you set up new software program like DAX Studio on their machines. However you all the time have entry on Energy BI Desktop short-term information.
This technique is the simplest option to discover the Energy BI Desktop native port.
· To start with you want obtain and set up DAX Studio in the event you don’t have already got it
· Open DAX Studio
· It instantly detects all opened Energy BI Desktop information that you may choose from the drop-down listing
· Choose a desired Energy BI Desktop file then click on “Join”
· You possibly can see the native port quantity within the button proper of the DAX Studio window
This technique is even simpler than DAX Studio.
· You’ll want to obtain and both set up or run the Tabular Editor (you possibly can obtain a transportable model)
· Open Tabular Editor
· Click on “Open a Tabular Mannequin from an present database”
· You possibly can see the port quantity related to every of Energy BI Desktop cases within the “Native cases” drop-down listing
Everytime you open Energy BI Desktop, it creates some short-term folders and information. The short-term location is completely different for Energy BI Desktop obtain version and the Retailer version.
Energy BI Desktop Native Port in Obtain Version
· Use Run menu and navigate to the next path:
%LocalAppDatapercentMicrosoftPower BI DesktopAnalysisServicesWorkspaces
· When you’ve got an open occasion of Energy BI Desktop then you definately’ll discover short-term a folder like beneath
· Navigate to “Information” subfolder
· Open “msmdsrv.port.txt” file which accommodates the Energy BI Desktop native port quantity
Energy BI Desktop Native Folder the Retailer Version:
· Use Run menu and navigate to the next path:
%userprofilepercentMicrosoftPower BI Desktop Retailer AppAnalysisServicesWorkspaces
· The remainder is similar as Energy BI Desktop obtain version so you could find the “msmdsrv.port.txt” file within the sub-folders
Discovering Energy BI Desktop native port utilizing Home windows Command Immediate (CMD)
- Run Home windows Command Immediate as Administrator
- Copy, paste and run the next command:
TASKLIST /FI “imagename eq msmdsrv.exe” /FI “sessionname eq
console”
- It is best to see one thing like this
- What we want is the PID
- Now run the next command and put the PID quantity you bought from earlier command between citation marks
netstat /ano | findstr “13944”
- The outcomes needs to be one thing just like the screenshot beneath which reveals energetic connections, their native deal with which is native IP deal with adopted by the port quantity. And that is what we’re on the lookout for.
Word: The column names for the end result desk respectively from left to proper are:
Lively Connection, Native Tackle, Overseas Tackle, State, PID
As I discussed, Lively Connection is the one we’re involved in in order that the quantity coming after colon is the port quantity.
