I had this same issue, reconfigured it as per this article (https://support.airtable.com/hc/en-us/articles/4403440453015-Sending-Airtable-data-to-Microsoft-Power-BI-Power-Query) and it then magically worked using anonymous authentication. Weird that ...