Technical documentation - Connect Power BI Desktop to API

Owned by Filip Skröder, created
11 Oct 2023
1 min read

This documentation is a general concept of how to connect Power BI Desktop (PBI) to an external API.

 Set up

Set up PBI installation:

  1. Download PBI if missing the installation package. https://www.microsoft.com/en-us/download/details.aspx?id=58494

  2. Install the application.

  3. Run the application.

 Fetch data from Api to Power BI Dekstop

  1. Click Home to get the toolbar.

  2. Click the arrow under Get data.

  3. Choose Web from the drop down list.

  4. Check the advanced toggle. And fill in the required information for your api request.

    1. Press OK to fetch data.

Example of request to forms api.

URL parts(first row): az01doc02.dometic.internal/FormsApi/form/get?profile=powerbi

HTTP request header parameters

api-key

Fill in the api-key in the box to the right of api-key.

OK to fetch data