I’m trying to connect my Airtable database to Power BI but running into authentication issues. I’ve attempted to set it up as a web data source and also tried working through the Power Query advanced editor, but neither approach works. When I get to the authentication step, the system refuses to accept my API key or developer token. I’ve double checked that my token is valid and has the right permissions in Airtable. Has anyone successfully established this connection before? I’m working on this for an internship project and really need to get this data pipeline working. Any suggestions on what I might be doing wrong or alternative methods to try would be greatly appreciated.
had same issue last month - try using the REST API connector instead of web source. also make sure ur using personal access token not the old api key, airtable changed that recently and it caught me off guard too.