Skip to main content

PowerBI

img

Introduction​

Integrating the Conviso Platform and PowerBI offers a powerful solution for optimizing your time and enhancing your data analysis capabilities.

With this integration, you can quickly generate customized reports and extract data for consumption on BI platforms, enabling you to make informed decisions based on real-time information.

Usage​

There are two ways to integrate the Conviso Platform and Power BI: through the Conviso Platform or directly in Power BI using our API.

Integrating directly into PowerBI Desktop​

Follow these steps to integrate Conviso Platform with Power BI Desktop:

Step 1 - In the main "Home”, access the "Get data" (1) icon and then select the "Blank query" (2) option:

img

Step 2 - On the sidebar to your left, you will see the created query:

img

Step 3 - Right click on “Query1” (3) and select "Advanced editor" (4):

img

Step 4 - In the Advanced editor, paste the following code for a query:

let
   Source = Web.Contents(
 "https://convisoappsec.com/graphql",
 [
   Headers=[
     #"Method"="POST",
     #"Content-Type"="application/json",
     #"x-api-key"=" < YOUR CONVISO_API_KEY"
   ],
   Content=Text.ToBinary("{""query"": ""query{ company(id: < YOUR COMPANY ID > ) { estimatedLinesConsumed }}""}")
 ]
   ),
   #"JSON" = Json.Document(Source),
    data = JSON[data],
    company = data[company]
in
   company

In the code above, we are using a query that retrieves the total lines of code for a specific company.

Please make sure to replace the following details with your own:

CONVISO_API_KEY: Generate your x-api-key by following the instructions provided here.

COMPANY_ID: Obtain your company id by navigating to the "Companies" section under "Settings" in the Conviso Platform.

YOUR QUERY: Configure the desired query in the Content line. You can find a detailed description of all available queries at this link.

Once you have pasted the code, the data will be loaded within seconds.

Finally, click on "Done". You will see the information displayed, and from there, you are free to configure Power BI according to your preferences.

Integrating using Conviso Platform configuration​

Follow these steps to integrate Conviso Platform with Power BI Desktop:

Access the Integrations (1) menu in the Conviso Platform. Navigate to the Business Intelligence (2) section in the right panel. Click on the "Integrate" (3) button.

img

There are four types of endpoints available to generate a JSON file and feed the BI tool:

  • Deploys: Returns a JSON with all company deployments.
  • Projects: Returns all projects linked to the user's scope.
  • Assets: Returns all company assets.
  • Users: Returns a JSON with all company users.

img

To create a connector with your BI tool, you will need the following information:

Conviso Platform URL: Use the URL "https://app.convisoappsec.com/".

Endpoint: Select one of the four available endpoints mentioned above.

x-API-key: Generate your API Key by following the instructions provided here.

PowerBI Setup​

Follow these steps to set up PowerBI Desktop:

Step 1 - Open PowerBI Desktop and click on the “Get Data”(1) button, then select “Web”(2):

img

Step 2 - In the Web floating window, choose the ”Advanced” option:

img

Step 3 - Fill out the form with the correct data and save it to connect:

  • In the URL Parts (1) field, paste the URL: https://app.convisoappsec.com/api/v2/projects
  • In the HTTP Request Header Parameters, choose “Accept”(2) for the first field and click on the Add Header button (3).
  • In the new field (4), type x-API-key and paste your API Key in the blank field to the right.

Click “OK” to save:

img

And click “Connect” (5):

img

After storing the configuration, you can connect the Conviso Platform to PowerBI. This allows you to create dashboards of projects tailored to your specific needs.

img

Using Pagination​ in PowerBI​

Pagination in PowerBI allows you to retrieve data from the Conviso Platform in smaller, manageable chunks or pages, rather than loading all the data at once.

This is particularly useful when dealing with large datasets or when there are API limitations on how much data can be retrieved in a single request.

To implement pagination in PowerBI, follow these steps:

Step 1 - Add the URL part with the parameter ?page=1 to your URL when adding the Power Query in “Get Data”. This indicates that you want to retrieve the data for the first page.

img

Step 2 - Click "Advanced Editor" in the header menu “Home”:

img

Step 3 - Edit the first and second lines of code by creating a function that takes the page number as a parameter.

This function allows you to specify the page number while fetching data dynamically.

img

Here's an example of how the code should look:

img

We change the initial part by incrementing (page as text) =>(1) and editing the page part "?page="&page&"" (2).

Step 4 - With the function in place, you can now perform pagination by invoking the function with different page numbers, allowing you to retrieve and analyze data from subsequent pages:

img

Implementing pagination ensures you can efficiently handle and process large volumes of data from the Conviso Platform within PowerBI, enabling you to create comprehensive reports and visualizations based on the complete dataset.

Paginating Multiple Pages to a Table​ in PowerBI​

Paginating multiple pages to a table in PowerBI allows you to retrieve and consolidate data from various pages of the Conviso Platform API into a single table. T

his is particularly useful when the data you need spans multiple pages and you want to combine it for comprehensive analysis and reporting within PowerBI.

To paginate multiple pages to a table​ in PowerBI, follow these steps:

Step 1 - After following the previous steps for "Using pagination", select the "Enter Data" (1) option to see the “Create Table” (2) window:

img

Step 2 - Configure the opened table as shown below. Note that it is set to capture 10 pages using the page variable, you can decide as many pages as you like:

img

Step 3 - After confirmation, the table will appear below. Change the "type" (3) to "Text"(4) as shown in the following steps:

img

Then a confirmation window will appear, click "Replace current" to confirm.

Step 4- In "Options" (5) configure an "Invoke Custom Function" (6) for the table:

img

Step 5 - Then configure the fields as described below:

img

Example in this image:

  • New column name: projects?page=1
  • Function query: projects?page=1
  • page: page

Step 6 - Another table will appear, allowing you to choose the specific attributes or columns you want to retrieve from the API. Click on the table settings (7), select the desired attributes (8), and confirm (9):

img

Done! With this, you can perform pagination of the 10 pages (as configured) of the API in a table:

img

You can seamlessly retrieve and consolidate data from the Conviso Platform API within PowerBI by paginating multiple pages to a table.

This simplifies data analysis, enhances reporting capabilities, and lets you gain valuable insights from a complete dataset.

Support​

If you have any questions or need help using our product, please don't hesitate to contact our support team.

Resources​

By exploring our content, you'll find resources to help you understand the importance of security applications data:

The importance of a platform for managing an AppSec program: We invite you to learn why an AppSec management platform is essential for companies that want to keep their applications safe and secure.

Discover Conviso Platform!