Creating an API token allows user admins to take their data and manipulate it outside of PI. This could be for presenting project reports in Power BI, sending project data to executives or many other uses. The most valuable use of an API token is that it provides live data in the form you present it, refresh the link to PI and all of the edits or entries made in PI will udpate through the token with current data.
Get Project Insight Data into Power BI using REST
Get your Project Data Directly to Excel
Generate the REST Api token
- You must be an administrator to create the token from the API (REST) Add-On configuration page from the Add-Ons Home
- Note the REST API base URL on the following page as we will refer to it later.
- Click Create REST Api Token.
- Select the User Context for the data retrieval and click Create Token.
Make Sure Your Token is "Web App Enabled
When you create your token in PI, be sure that you check this "Yes" so that this procedure will work:
After creating the token, that long string of letters and numbers will be what you enter into whatever platform you're linking with PI, like Power BI.
Please sign in to leave a comment.