The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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
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':
Choose the Web Connector:
Use the Advanced Option:
Enter the API URL:
Add Headers for Authentication:
Confirm and Connect:
Load and Transform Data:
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
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.