This connector method exposed the PAT in cleartext. If I share the Excel spreadsheet, the user can discover my PAT and query other company tables. They would need to know different table and base IDs. If my computer storage gets compromised, the hacker will get access to this PAT. Is there a better way to authenticate than using a PAT as a parameter?
I do see a method in data source settings of query editor (PowerBI or Excel) called Web API but Airtable has deprecated its use.
https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query