Power BI Connector Error

[sr49ers2023]

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

[cpalmieri1985]

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:

   • For the URL parts, input the API endpoint: https://api.airtable.com/v0/[BaseID]/[TableName].
   • Replace [BaseID] and [TableName] with your actual base ID and table name.

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.

[mliu]

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

[cpalmieri1985]

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.