Forum Discussion
Airtable - Certain Columns Pulled in as Lists, Cannot Get the Data
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.
Code looks OK, as far as I can tell without actually seeing the data that is returned.
I believe that the returned data for your dropdown-fields is encoded and one has to find the correct encoding keys.
Otherwise error-would be shown.
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.
This is fantastic ImkeF , thank you!
Took me a bit to figure out how to merge the tables. Here's how I got it to work based on what I understood, curious if this is what you meant - I pulled into Power BI from Airtable the additional tables from which the initial one pulls drop down options. Then, using the "Manage Relationships" in Power BI, I was able to setup a one to many relationship between the Airtable data and it worked!
I appreciate your support and patience. Thank you for helping me solve this issue.
ROKRI
Hi I have a similiar question. I am using Airtable for a survey I am doing where one table has the stops I make with several columns that are linked to another table for tools I select based on where they purchased them(each column has a different purchasing source). The issue I have is whenever I expand the column into new rows(because PowerBi sees a list), it duplicates each record's info for each column I expand.
I'm wondering if there is a better way to set up my Airtable info to better popular the data into PowerBi without having so much extra data and duplicates?
I can setup the relationship up to match the record id to the correct tool name but with 500 surveys and over 3k tools there is a ton of duplicate info and tens of thousands of records.
Table 1- Stops
Record 1 has Person with city, state, age etc... and also has 10 linked column where I choose the tools he has based on where he purchased them.
Table 2- Tool Database
Record 1 has model # and other info as well as the linked records showing which techs chose which tool.
Whenever I expand a record it duplicate all the survey info name, city, state etc but will only have the 1 record inside of the column. This seems very inefficient and even though I can tell PowerBi to Count (Distinct) when doing charts, it can be confusing. Stops with multiple choices in columnToolbox Database showing record id and person choices.
I believe I am having the same problem. How do I merge them with the respective tables?
