Skip to main content
English (US) Español (España) Français Português do Brasil Português (Portugal)

How to connect Fracttal One with Power BI?

Updated

Fracttal One allows integrating maintenance data with Power BI through a secure connection, using the API and the OAuth 2.0 authentication flow. Below, we show you how to properly configure data extraction so that Power BI can access the specific information needed for analysis and report generation.

Note: Before configuring the credentials for Power BI, make sure you have created an appropriate permission group. If you have not created one yet, check How to add/create permission groups? to learn how to do it.

 

Create an OAuth client for the API

With the permission group already configured, now we will create the credentials that Power BI will use to authenticate.

  1. Access the Settings menu.

  2. In the left side menu, click on API Connections and then select the middle tab, called OAUTH CLIENTS.

  3. Click on (+) to add a new client.

  4. In the "New OAuth Client" window, fill in the following fields:

    • Authorization type: Select Client credentials. This is the ideal flow for machine-to-machine communication, as is the case with Power BI.

  • Name: Assign a clear name for the connection, such as Power BI Connection.
  • Description (Optional): Add more details about the purpose of the connection.

  • Permission group: select the group you created. This step links the credentials with the access permissions.

Click Save in the upper right corner.

After saving, the system will automatically generate and display the Key (Client ID) and the Secret (Client Secret).

  • Key: The public identifier of your application (in this case, Power BI).
  • Secret: The "password" of your application.

Write down or copy these two values. You will need them in the next step.

 

Direct connection

  1. Accessing Power BI Desktop > clicking on Get Data > Web

     

  2. A window will open requesting the "FROM WEB" information; we must enter the URL of the API query we are going to perform and click 'accept'.

     

  3. Then, go to "BASIC", in the 'username' field enter the Fracttal "API Key" data, in the password field enter the Fracttal "API Secret" data, select the API you want to query, and finally select "Connect".

     

  4. Once the previous window loads, it shows the details of the query performed.

     

NOTE: For more information about API connections, click here.

 

Related articles