Skip to main content

Hi All

I am trying to connect to airtables through power bi and have the API setup with the key, base id and table id. however when i enter the details into Power Bi i get an "We couldn't authenticate with the credentials provided. Please try again." error. now sure why as i do have access to the airtable with the same power bi credentials.

Thanks

 

was facing the same issue. just solved it on my end. chat gpt provided a different method than what was described in their documentation. hope this helps!

  1. Open Power BI and Navigate to 'Get Data':

    • Open Power BI.
    • Go to "Home" > "Get Data" > "More".

  2. Choose the Web Connector:

    • Under the "Other" category, select "Web".
    • Click "Connect".

  3. Use the Advanced Option:

    • In the window that opens, switch to the "Advanced" tab.

  4. Enter the API URL:

  5. Add Headers for Authentication:

    • In the "HTTP request header parameters" section, add a new header.
    • Set the "Key" to Authorization and the "Value" to Bearer [Your Personal Access Token].
    • Ensure you replace [Your Personal Access Token] with your actual token.

  6. Confirm and Connect:

    • Click "OK" to confirm the settings.
    • Power BI will now attempt to connect to Airtable using the specified URL and header for authentication.

  7. Load and Transform Data:

    • Once the connection is successful, you can load and transform your data as needed in Power BI.

was facing the same issue. just solved it on my end. chat gpt provided a different method than what was described in their documentation. hope this helps!

  1. Open Power BI and Navigate to 'Get Data':

    • Open Power BI.
    • Go to "Home" > "Get Data" > "More".

  2. Choose the Web Connector:

    • Under the "Other" category, select "Web".
    • Click "Connect".

  3. Use the Advanced Option:

    • In the window that opens, switch to the "Advanced" tab.

  4. Enter the API URL:

  5. Add Headers for Authentication:

    • In the "HTTP request header parameters" section, add a new header.
    • Set the "Key" to Authorization and the "Value" to Bearer [Your Personal Access Token].
    • Ensure you replace [Your Personal Access Token] with your actual token.

  6. Confirm and Connect:

    • Click "OK" to confirm the settings.
    • Power BI will now attempt to connect to Airtable using the specified URL and header for authentication.

  7. Load and Transform Data:

    • Once the connection is successful, you can load and transform your data as needed in Power BI.

Hi there, 

I followed the method above and it worked, but I guess it will be great if above can be updated into the manual of Airtable.  As the method introduced was quite different against the original way in the https://support.airtable.com/docs/en/visualizing-airtable-records-in-microsoft-power-bi-power-query. 

Thank you

Hi there, 

I followed the method above and it worked, but I guess it will be great if above can be updated into the manual of Airtable.  As the method introduced was quite different against the original way in the https://support.airtable.com/docs/en/visualizing-airtable-records-in-microsoft-power-bi-power-query. 

Thank you


Hi @mliu ,

Agreed! The above method worked for me but it does end up disconnecting after about 30 days which requires you to re-authenticate. I finally threw up my hands a few weeks ago and started using Coupler (https://www.coupler.io/). It serves as a bridge between Airtable and Power BI. It's $32/month but for the amount of time saved, it was worth it for me.

Reply


Terms & Conditions