Power BI Connector
On this page
Introduction
The SolarWinds Service Desk (SWSD) Power BI Connector lets you incrementally import incidents and different asset records from SWSD to Microsoft Power BI. The import provides raw data on the topics most relevant to your organization. You can then review and analyze the data by viewing it in a variety of formats, such as tables, graphs, and charts.
SolarWinds owns the connector and is a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or want to request a change to it, provide feedback at the bottom of the page.
Connect to SolarWinds Service Desk
On August 4, 2024, SolarWinds updated the Power BI connector.
Important information:
SolarWinds expanded the Power BI connector to pull data based on the updated_at
column instead of created_at
.
Customers can now follow new records in SolarWinds Service Desk and their progress.
Customer effects: Every refresh you perform will pull all records changes, including new records or records where their data was changed during the date range you set. This may change your reports in Power BI Desktop and the Power BI Service.
Instructions for new Power BI users
Instructions for the currently published version of the SolarWinds Service Desk (SWSD) Power BI Connector are available on the Microsoft website.
Instructions for customers who used the BETA SWSD Power BI Connector
-
In Power BI Desktop, select Get Data from Home. Select SolarWinds Service Desk, and then select Connect.
-
Sign in with the JSON Web Token you generated as described in the Prerequisites, and then click Connect to verify your access to SWSD.
If you have an ESM account, the JSON token you use for the connector must be generated by a Service Provider Administrator. -
In the Navigator dialog box, select the table you want to import, and then click Load.
After completion of the steps above, you can see your chosen models load under Data view. The records you just imported were updated or created in SWSD during last month.
Additional steps for previous users of the BETA connector
If you previously used the BETA SWSD Power BI Connector to create reports, and you already have the model name Incidents and reports based on it, and you wish to connect those reports with the new out-of-the-box version, follow these steps:
-
Go to the Incidents model, and right-click Edit query. A Power Query Editor opens.
-
Select the Incidents query and open Advanced Editor.
You see the following lines:
Source = SolarWindsServiceDesk.Contents(),
Incidents1 = Source{[Name="Incidents"]}[Data]
-
Replace those lines with the following lines:
Source = SolarWindsServiceDesk.ContentsV110(null, null),
#"All Objects" = Source{[Name="All Objects"]}[Data],
Incidents1 = #"All Objects"{[Name="Incidents"]}[Data]
-
Click Done.
-
Click Close & Apply.
The reports display data from the past month instead of the last two years. Going forward, those reports are connected to the new SWSD Power BI Connector.
Incremental Refresh setting
Incremental Refresh saves download time after your initial download is performed. To set up incremental refresh, follow these steps:
-
On the Home menu bar, click Transform Data. A Power Query Editor opens.
-
Open Manage Parameters > Create parameters.
-
Create two new DateTime parameters named
RangeEnd
andRangeStart
.The new parameters set the filtering range of the pulled data, based on the
updated_at
column. This reduces download time and filters your data based on the range you set.Set enough time between the parameters to allow you to pull sufficient records for your reports, but not too large. Select a range that won't cause you to wait a long time for every refresh. See Microsoft's instructions: create-parameters.Example with one month between the
RangeEnd
andRangeStart
parameters: -
For each query you wish to set with Incremental refresh, open Advanced Editor. The following line displays:
Source = SolarWindsServiceDesk.ContentsV110(null, null),
-
Replace the line with the following:
Source = SolarWindsServiceDesk.ContentsV110(RangeStart, RangeEnd),
-
Click Done.
-
Click Close & Apply.
-
Go to Data view.
-
For each model you’ve downloaded, define the policy for Incremental refresh and real-time data as described below.
-
Set the option for archiving data to meet your reporting needs. Enter a number in the first field and use the dropdown to select a time frame.
-
Incrementally refresh data starting 1 Days before the refresh date. See define-policy for instructions.
-
Publishing reports
All customers publishing to the Power BI Service need to perform the steps below. This applies to both first-time publishers and those who have published in the past.
-
Publish the report to Power BI Service Workspace, based on the out-of-the-box connector.
-
Establish settings for each published semantic model in the Power BI Service.
-
For each semantic model, open the Data Source Credentials section and edit the credentials with the key and token you used when you established the connection with the connector in Desktop Power BI.
Your reports in Power BI Desktop and Power BI Service are now connected to and using the latest version of SolarWinds Service Desk Connector.
You can refresh each semantic model for the first time. The refresh downloads the archived data you defined in the incremental refresh policy (records from a maximum of 2 years ago).
SolarWinds suggests setting the first large download with a scheduled refresh. Optionally, you can run it manually by clicking Refresh the semantic model.
For instructions on configuring a scheduled refresh see scheduled-refresh.
After the first refresh, future refreshes go much more quickly and download only the new records from SWSD.
Limitations and issues
Users should be aware of the following limitations and issues associated with accessing SolarWinds Service Desk:
-
There is no limit on the number of users who can pull data, but if they are not using Incremental Refresh and try to import data from a range larger than one year, each user can refresh only once every 24 hours.
-
The fields that are imported are limited. For additional fields please submit a feature request in THWACK. For feedback or support please reach SolarWinds support.
Credential error in the Navigator
If a credential error occurs in the Navigator, clear your recent data source settings.
-
In Power BI Desktop, select File > Data source settings.
-
Select the SWSD data source, and then select Clear permissions.
-
Establish the connection to the Navigator again.