Saturday, June 11, 2022
HomeBusiness IntelligenceFast Ideas: Registering SQL Server Profiler as an Exterior Device in Energy...

Fast Ideas: Registering SQL Server Profiler as an Exterior Device in Energy BI Desktop


Registering SQL Server Profiler as an External Tool

It has been a very long time that I exploit SQL Server Profiler to diagnose my knowledge fashions within the Energy BI Desktop. I wrote a weblog submit in June 2016 about connecting to the underlying Energy BI Desktop mannequin from totally different instruments, together with SQL Server Administration Studio (SSMS), Excel and SQL Server Profiler. On this fast submit, I share a pbitool.json file that you should utilize to register the SQL Server Profiler as an exterior instrument. Learn extra about tips on how to register an exterior instrument right here. That is fairly helpful as this manner to make use of SQL Server Profiler to diagnose Energy BI Desktop with no need to search out the diagnostic port. As an exterior instrument, the SQL Server Profiler mechanically connects to the information mannequin through the diagnostic port. You may obtain the sqlserverprofiler.pbitool.json file from right here. After you obtain the file you possibly can open it in a textual content editor to see or modify the JSON code. If you’re utilizing SSMS 18, then you don’t even want to switch the file. When you use a special model, the one factor you need to change is the “path”.

The contents of the sqlserverprofiler.pbitool.json file
The contents of the sqlserverprofiler.pbitool.json file

Simply copy the sqlserverprofiler.pbitool.json file to the next location:

  • For 64-bit surroundings use: %commonprogramfiles(x86)%Microsoft SharedPower BI DesktopExternal Instruments
  • For 32-bit surroundings use: %commonprogramfilespercentMicrosoft SharedPower BI DesktopExternal Instruments

Now you can open Energy BI Desktop and you will notice SQL Server Profiler seems within the Exterior Instruments tab.

Registering SQL Server Profiler as External Tool in Power BI Desktop
SQL Server Profiler Registered as an Exterior Device

After you click on the SQL Server Profiler from the Exterior Instruments tab, it mechanically connects to your knowledge mannequin through the diagnostic port as proven within the following picture:

SQL Server Profiler opened from the External Tools tab from Power BI Desktop
SQL Server Profiler opened from the Exterior Instruments tab from Energy BI Desktop

I hope you take pleasure in this fast tip. As at all times, I might like to learn about your ideas.

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments