How to pull all columns into power bi even it has single entry

[Johnson_Raj]

My data source is airtable, using the API I am pulling my tables from airtable to power bi.

Columns that have zero entries or less entries are not been pulled.

Say for example, I have 20 columns and 100 records. Certain columns (say 5 columns) have values for few records. Those columns are not pulled into power bi. 

[v-zhangti]

Hi, @Johnson_Raj 

You can refer to these documents and check if they can help:

Handling paging for Power Query connectors - Power Query | Microsoft Docs

powerbi - Paging REST API results in Power Query - Stack Overflow

powerbi - How to get paginated data from API in Power BI - Stack Overflow

How to do Pagination on a REST API in Power Query (Part 1) - YouTube

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.