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.
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.