Not all table columns loaded to Power BI

Only 57 out of 98 columns are loaded through the query HERE in Power BI. Does anyone know how can this be fixed?

1 Like

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!

1 Like

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!

2 Likes

Thanks Sam for the feedback! in my case the columns I’m missing contains plenty of data.

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.

1 Like