Help

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

1597 2
cancel
Showing results for 
Search instead for 
Did you mean: 
karkumar
5 - Automation Enthusiast
5 - Automation Enthusiast

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 2
Kami_T
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Eli_Kent
7 - App Architect
7 - App Architect

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