Help ResultsX
   Main Help Page    /    Flights

Microsoft Power BI


Feature availability


Many customers utilize AirData's API to integrate with dashboard tools like Microsoft Power BI. Although we don't offer a native integration with Power BI, we can guide you through the initial setup process.
  1. Request Your API Key: Email us at support@airdata.com to obtain your API key. Please keep this key confidential and do not share it outside your organization for security reasons. Access to our API is included with the Enterprise plan.

  2. Base64 Conversion: Power BI requires the API key to be in Base64 format. You can use various online tools to convert your API key.
    Our team uses the free "Basic Auth Header Generator" at https://www.debugbear.com/basic-auth-header-generator

    When converting your API key to Base64, paste your entire key, including the prefix "ad_", into the Username field and leave the Password field empty.



  3. Adding Data in Power BI:
    1. Go to "Add Data" from the Web and select "Advanced".
    2. In the URL field, enter: ⁠https://api.airdata.com/flights?detail_level=comprehensive
    3. For more parameters and options, visit our API documentation.
    4. In the "HTTP request header parameters (optional)" field, manually type "Authorization".
    5. Enter ⁠{base64_key} as your authorization value.

  4. Additional Integration Steps: You might need to implement a gateway or write custom integration code for seamless reporting in Power BI. Due to the lack of direct integration, we cannot support or troubleshoot Power BI-specific issues. However, we're happy to assist with any AirData API-specific questions or if you encounter missing calls.



FAQ

1. Power BI is asking me for a Password along with a Username. What do I put in the Password field?

Most users will not need to add a Password. If Power BI is not allowing you to proceed with the API connection, please try selecting the "Skip test connection" box. This should allow Power BI to connect to the API successfully.

After the connection is established, Power BI will fill in the Password field automatically.

Comment Section Sort by:
Search ResultsX