Page Comparison

Panel

panelIconId	2757
panelIcon	:exclamation:
panelIconText	❗
bgColor	#EAE6FF

Before using the Blank Query Connection and creating an access token, ensure your ServiceNow [admin] sets up and tests the configuration on the corresponding instances. Without this configuration, you won’t be able to create the access token.

How to set up and test configuration?

By default, the OData feed is used for connecting to Microsoft Power BI. However, to meet a wider variety of user needs, the Blank Query Connection method has also been added.

This feature is especially helpful for companies using Single Sign On (SSO), as this login method often operates without the need for a password. The Blank Query Connection enables authorization without requiring a local ServiceNow password.

Info
How to Connect to Power BI if ServiceNow Uses MFA/2FA/SSO?

Info

There are also a few features that are not available when using the Blank Query Connection:

The templates can’t be used with the Blank Query connection. They are built on OData, and the Blank Query can’t replace the OData connection.
There might be potential limitations for the scheduled refresh. Connection configuration issues are present when publishing the dashboard and scheduling a refresh.

Info
This connection method is available in version 1.6.2 of Power BI Connector. If you don’t see the Blank Query Connection method, please ensure that you have version 1.6.2 or higher.

To use the Blank Query Connection method, it’s required to generate an access token. Therefore, before exporting data, ensure that you have created a token.

Info
Please follow the steps provided below to easily start using the Blank Query Connection method.

Table of Contents

minLevel	1
maxLevel	6
outline	false
type	list
printable	false

How to Create Access Token

The following users CAN’T create the token:

Users with the ServiceNow [admin] role due to security perspective
Users who don’t have email
WSAO (Web Service Access only) users

In the Filter navigator field, start entering Power BI, and then select Authorization (Under the Power BI Connector for ServiceNow section).

Select New.

Select Generate Token.

Select Submit.

Info

By default, an access token is set to a one-year validity period. If you’d like to change the validity period, please contact your ServiceNow admin.

How to change the token validity period?

Your access token will be automatically copied as a part of a template when selecting Copy Blank Query Template. The template is generated for each user separately, taking into account the data of the user who copies it. It means that each user has to create their access token independently.

Each user is allowed to generate only one access token. While users can update their existing token, attempting to generate an additional token will result in an error.