Skip to content

Dashboard Data Source

To keep the BI Pixie Dashboard refreshing in Power BI, you need to give Power BI permission to read your engagement data. You grant that permission with a SAS Token, generated for you in the BI Pixie Portal's Dashboard Data Source card. You copy the Token when you first install the dashboard, and again whenever the Token is rotated.

The Dashboard Data Source card appears in two places. Everyone can copy the Token on the Account page. Admins can also copy it from the Licenses page, where each license's expanded card holds its full connection parameters.

What each Dashboard Data Source card holds

On the Licenses page (Enterprise per-license setup)

When you expand the license you are setting up on the Licenses page, you see two values on its card, under a description that reads Here are the parameters and SAS Token you need to refresh the semantic model of your BI Pixie Dashboard.

  • Data Lake URL with a Copy URL button.
  • SAS Token with Show/Hide and a Copy Token button.
Licenses page with the Primary License card expanded, showing the Dashboard Data Source section with Data Lake URL and SAS Token rows; the Copy Token button is highlighted

You use the Data Lake URL and SAS Token from a license's card when you first connect the dashboard for that license. The full install walkthrough is on Set up the BI Pixie Dashboard.

On the Account page

On the Account page, you see only the SAS Token, under a description that reads Use this SAS Token to refresh the semantic model of your BI Pixie Dashboard. You use this Token in two cases:

  • First-time install on the Free, Standard, and Pro plans, or as a member on any plan. When you install from the BI Pixie Portal, Power BI fills in the Data Lake URL for you, so you only paste the Token. A member sees the Token for the license they are assigned to.
  • Re-credentialing after a rotate. The URL has not changed, so you only need the new Token. You paste the new Token into the Edit credentials dialog for the BI Pixie semantic model in Power BI.

On the Enterprise plan, the Token on the Account page belongs to your default license. To install the dashboard for any other license, you copy the values from that license's expanded card on the Licenses page.

Account page with the Dashboard Data Source card showing the masked SAS Token, Show toggle, Expires and Last rotated dates, and Rotate SAS button; the Copy Token button is highlighted

Rotating the SAS

You rotate the SAS when someone with access leaves, or as part of a periodic security review. Only admins can rotate the SAS.

Rotating creates a new Token. It does not revoke the previous Token, which keeps working until its own expiry date. If you suspect a Token has leaked, BI Pixie support can revoke it immediately when you contact them.

  1. Select Rotate SAS. A confirmation card appears with this warning: Rotating creates a new SAS Token but does not revoke the current one. The current SAS Token keeps working until its expiry date, so your BI Pixie Dashboard continues to refresh until then. To keep the dashboard refreshing after that date, the semantic model behind it needs the new SAS Token in its data source credentials in Power BI. To revoke a SAS Token immediately, contact support.
  2. Select Confirm Rotate.
  3. Select Copy Token and paste the new Token into your Power BI semantic model's Edit credentials dialog.

If you are not an admin, the Rotate SAS button is disabled with the tooltip Only admins can rotate the SAS URL. If your subscription is past-due or frozen, the tooltip reads Renew your subscription to rotate the SAS URL.

Expiration

Each SAS Token is valid for one year from the moment it is generated. On the card, you see both an Expires date and a Last rotated date, so you always know when the next rotation is due. Rotating before expiration is non-disruptive: the previous Token keeps working until its expiration time, which gives you a window to update Power BI.

Related Resources