Forum Discussion
Solved
Airtable - Certain Columns Pulled in as Lists, Cannot Get the Data
Hello Power BI Community, I need your help please to address an issue when importing data from Airtable where columns based on an array (data pulled from other tabs within Airtable) only show up as ...
Now I got it: As they are dropdown fields and just allow you to select existing/defined items, the returned values will be their keys. So you have to merge them with the respective tables to lookup their values from those tables.
Hi ROKRI ,
I cannot see your data from your link due to security.
If I understand your scenario correctly that you have problems when you expend List in the filed?
If it is convenient, could you share the screenshots about the result when you expend the list?
In addition, may be ImkeF will help you who is good at M query.
Best Regards,
Cherry
Sorry, but don't understand the problem yet.
What do you see if you expand a list column by clicking on the arrrow-button?: