Hi Team,
I created a personal access token as suggested in Airtable documentation.(https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query)
While I'm connecting to PowerBI using the PAT, TableID, BaseID and M Query, it displays below error:
Expression error: we cannot convert the value null type to type Record.
Details:
Value=
Type=[Type]
However if I use the API keys, it works fine. Since API keys will deprecate in mere future, created a PAT. Can you please assist? Thank you!