Power BI Connector Error

1117 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.



1 Reply 1
4 - Data Explorer
4 - Data Explorer

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.