- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 06, 2023 10:41 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 26, 2024 01:43 PM
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!
Open Power BI and Navigate to 'Get Data':
- Open Power BI.
- Go to "Home" > "Get Data" > "More".
Choose the Web Connector:
- Under the "Other" category, select "Web".
- Click "Connect".
Use the Advanced Option:
- In the window that opens, switch to the "Advanced" tab.
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.
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.
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.
Load and Transform Data:
- Once the connection is successful, you can load and transform your data as needed in Power BI.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 04, 2024 01:25 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 04, 2024 06:19 AM
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.