Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Dec 30, 2021 08:17 AM
Only 57 out of 98 columns are loaded through the query HERE in Power BI. Does anyone know how can this be fixed?
Mar 08, 2022 06:53 AM
I have the same issue! I’m using the M code provided by Airtable and it works fine, except that only about half of the fields are being captured. There seems to be no correlation to data type, column order, anything. It affects all bases. Any help would be appreciated!
Mar 09, 2022 06:26 AM
Aha! After some testing I determined that the columns weren’t being imported because they contained no data. I had built the structure in Airtable but hadn’t populated it with much data, and once I had entered some input, the columns were available through Power Query. Hope that helps!
Mar 17, 2022 10:18 AM
Thanks Sam for the feedback! in my case the columns I’m missing contains plenty of data.
May 28, 2022 04:27 AM
Similar issue here. Columns with almost no data wheren’t being imported, since I populated the empty fields with dummy values they showed up in Power Query.
Sep 14, 2022 12:11 AM
Same here, had this issue with Excel too. Tried different field types to see if there’s any pattern, but no luck.
So, do I need to populate empty fields with something in order for the column to be pulled through?
Sep 14, 2022 08:42 AM
Yep, I suggest you populate each column with a “TEST” value or similar, and then in PQ you can filter it right out to ensure you’ve got the right data.
Dec 29, 2022 09:56 PM
So according to airtable tutorial on how to load data on PowerBI here
"PowerBI will only load a field if the first record coming from Airtable has data in that field. So if the field is empty, then it won’t show up in Power BI."
This mean if the first record in the database has a field that is empty that field wont showup, even if in later records that field has data.
Anyone know how to avoid this? besides creating the first record with fake data?