You can use Power BI to explore the Smart API.
Requirements
To use Power BI, you must:
-
Be able to access Smart Completions Smart APIs.
-
Authenticating using either the Smart Completions authentication server or Smart Cloud (which uses Okta as the IdP).
How to authorize
To be authorized to interact with the API, use the Get Data feature in Power BI.
-
Open Power BI and select Get Data.
-
Select Hexagon PPM SmartĀ® API and click Connect.
If you have a lot of data sources, you can search for Hexagon PPM Smart API.
-
In the Hexagon PPM Smart API dialog box, enter the base URL for the API.
-
When prompted, enter your Smart Completions credentials.
You can now explore the Smart API endpoints that you have access to, based on your role.
-
Select an endpoint (for example, Instances) to preview the number of records or transform data to populate data records in a grid view.