Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

2582 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