Hexagon PPM Smart® API
Power BI is a popular business intelligence tool that allows users to analyze data and create visualizations to gain insights into their business operations. One of the key features of Power BI is its ability to connect to various data sources, including APIs. In this article, we will explore how to use Power Query M language to connect to the Hexagon PPM Smart(r) API data source from inside Power BI.
What is Power Query M Language?
Power Query M language is a data transformation language used in Power BI to fetch, clean, and reshape data from various sources. It is a functional programming language that allows users to perform complex data transformations with ease. The language is similar to other functional programming languages like F# and R.
Connecting to the Hexagon PPM Smart(r) API Data Source
Hexagon PPM Smart(r) API is a cloud-based API that provides access to data from Hexagon’s various enterprise software solutions. To connect to the Hexagon PPM Smart(r) API data source from inside Power BI, we need to follow the below steps:
1. Open Power BI desktop and click on “Get Data” button on the home tab.
2. Select “Web” as the data source and click on “Connect”.
3. Enter the Hexagon PPM Smart(r) API endpoint URL in the “URL” field. For example, “https://ppmsmartapi.hexagonppm.com/api/v1/”.
4. Select “Basic” as the authentication method.
5. Enter your Hexagon PPM Smart(r) API username and password.
6. Click on “OK” to connect to the Hexagon PPM Smart(r) API data source.
Retrieving Data from the Hexagon PPM Smart(r) API Data Source
Once we have established a connection to the Hexagon PPM Smart(r) API data source, we can retrieve data using Power Query M language. Here is an example code snippet that retrieves all the projects from the Hexagon PPM Smart(r) API data source:
let
url = “https://ppmsmartapi.hexagonppm.com/api/v1/projects”,
options = [
Headers = [
#”Authorization” = “Basic
]
],
source = Json.Document(Web.Contents(url, options)),
projects = source[projects]
in
projects
In the above code snippet, we first define the API endpoint URL and the authentication options. We then use the `Web.Contents()` function to retrieve the data from the API endpoint. Finally, we extract the projects data from the JSON response using the `Json.Document()` and `[]` operators.
Conclusion
In this article, we have explored how to connect to the Hexagon PPM Smart(r) API data source from inside Power BI using Power Query M language. We have also seen how to retrieve data from the API using a code snippet. With this knowledge, you can now easily connect to the Hexagon PPM Smart(r) API data source and perform data analysis and visualization in Power BI.
