Skip to main content

Unable to retrieve data from Airtable to PowerBI using Personal Access Token


Forum|alt.badge.img+4

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!

2 replies

Forum|alt.badge.img+5
  • Participating Frequently
  • 6 replies
  • September 8, 2023

Have you been able to find a work around for this issue?


Forum|alt.badge.img+13
  • Inspiring
  • 40 replies
  • October 18, 2023

having the same issue, though followed the guide found in this url


Reply