Help

Exporting Airtable Data into PowerQuery

Topic Labels: Importing & Exporting Sync
Solved
Jump to Solution
6018 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Edd_Tillen
6 - Interface Innovator
6 - Interface Innovator

I've used this very helpful page to be able to export my tables out of air table and into Power Query, and from there into Excel: Sending Airtable Data to Microsoft Power BI & Power Query | Airtable Support

However, I'm having an issue that some seemingly random columns aren't being picked up by PowerQuery. I've done this with 5 tables, some have worked perfectly, some haven't. The columns that are missing are different types, sometimes check boxes, sometimes free text fields. I can't work out what the pattern might be, and therefore how I might fix it.

I'm hoping someone might have come across the same issue in the past, and know exactly what I'm talking about and how to fix it.

 

10 Replies 10

Hi @Public_Knowledg 
Is there a way to specify the fields I want to return instead of retrieving all fields?