Home Business Intelligence Fast Suggestions: Discover Energy BI Desktop Native Port Quantity with Mannequin Explorer

Fast Suggestions: Discover Energy BI Desktop Native Port Quantity with Mannequin Explorer

Fast Suggestions: Discover Energy BI Desktop Native Port Quantity with Mannequin Explorer


Quick Tips: Find Power BI Desktop Local Port Number with Model Explorer

In March 2018, I wrote a blogpost referred to as 4 Completely different Methods to Discover Your Energy BI Desktop Native Port Quantity. Final week, Zoe Doughlas from Microsoft left a remark reminding me of a fifth technique to get the port which inspired me to write down this fast tip. Because of Zoe!

Because the title suggests, the weblog was about discovering Energy BI Desktop’s native port quantity. For those who wouldn’t have any clue what I imply by native port quantity, I strongly counsel studying that weblog.

This weblog focuses on one more technique that wasn’t out there again then. Certainly, it’s a new function added to the October 2023 launch of Energy BI Desktop. This can be a Fast Tip so let’s leap straight to the subject and find out how we discover the port quantity (and extra) in Energy BI Desktop (Oct 2023 and later releases).

As talked about, this new function was added to Energy BI Desktop’s October 2023; due to this fact, we should set up that launch on our native machine. Certainly, the October 2023 launch was filled with many different options, together with the Mannequin Explorer (the subject of this weblog) and the power to outline calculation teams immediately in Energy BI Desktop. Many of those options are nonetheless in preview; therefore, they require enabling.

The next few steps clarify methods to allow Preview Options in Energy BI Desktop:

  1. Open Energy BI Desktop and click on Settings (the gear icon) from the appropriate pane
  2. On the Choices web page, from the GLOBAL part, click on the Preview options tab
  3. Allow the specified options; for this weblog, we want the Mannequin explorer and Calculation group authoring
  4. Click on OK

The next picture reveals the above steps:

Enabling Preview Features in Power BI Desktop
Enabling Preview Options in Energy BI Desktop

Relying on the chosen options, it’s possible you’ll must restart your Energy BI Desktop to permit them to allow.

Wanting on the above picture, a few of it’s possible you’ll ask “Soheil, are you utilizing an older model of Energy BI Desktop?” and I’m glad you requested. The reply as at all times is “It relies upon”. And, this time it is determined by the timing of scripting this weblog which is early December 2023, and the truth that Energy BI Desktop November 2023 was launched a few weeks in the past, due to this fact, Energy BI Desktop October 2023 is form of OLD! And, YES! I put in Energy BI Desktop Nov 2023 for the sake of scripting this blogpost.

By the best way, if, for any purpose, you need to set up an older model of Energy BI Desktop, you could find the set up bundle right here.

Once we open a Energy BI report file in Energy BI Desktop, the desktop assigns a random port quantity. The explanations are defined right here. Comply with these steps after opening the file in Energy BI Desktop:

  1. Click on the Mannequin view from the left pane
  2. From the Information pane, choose the Mannequin tab (that is the Mannequin Explorer exhibiting the breakdown of your mannequin)
  3. Choose Semantic mannequin
  4. On the Properties pane, the Server reveals localhost:PORT_NUMBER

The next picture reveals the above steps:

Getting Power BI Desktop Local Server Port in Model Explorer
Getting Energy BI Desktop Native Server Port in Mannequin Explorer

There you go! Now you can use this server info in third-party instruments equivalent to SQL Server Administration Studio (SSMS) to attach your Energy BI Desktop semantic mannequin as whether it is an on-premises occasion of SQL Server Evaluation Companies Tabular Fashions.



Please enter your comment!
Please enter your name here