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.