/
Technical documentation - Connect Power BI Desktop to API

Technical documentation - Connect Power BI Desktop to API

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

Related content

Technical instruction - Usage Log API
Technical instruction - Usage Log API
More like this
Technical documentation - Signifikant REST API authentication
Technical documentation - Signifikant REST API authentication
More like this
Technical documentation - AssetManager to create connection to external data
Technical documentation - AssetManager to create connection to external data
More like this
Technical documentation - Server APIs
Technical documentation - Server APIs
More like this