Ivan_Larson - profile

Ivan_Larson · Oct 09, 2019

From what I can tell, trying several different codes that are supposed to paginate Airtable data in Power BI, some people are getting them to work and some are still just getting 100 records. Has anyone who was just getting 100 records who has now go...

Ivan_Larson · Oct 14, 2019

@Matthew_Billiodeaux1, @Bill.French Thank you both for your help. After further testing, the second code above worked as written. The issue was that after editing the code in query editor from using Source to Pagination, I needed to hit “Refresh Prev...

Ivan_Larson · Oct 09, 2019

Hi @Bill.French, Thanks for responding. I’ve tried the code in this link, and it’s returning the first 100 records, an offset record, and an error message. Without a better understanding of how it does what it does, I can’t figure out why it’s not wo...

Ivan_Larson · Oct 09, 2019

Hi @Laurent_Tourneux, Thank you for posting this code! I’ve tried using it and I’m getting some errors. My code: Pagination= List.Skip(List.Generate( () => [Last_Key = “init”, Counter=0], // Start Value each [Last_Key] <> null, // Condition under w...

Ivan_Larson · Oct 09, 2019

As with @Adolfo_Ferreira, I’m also only getting 100 records back. I’ve tried several codes similar to this one, and keep getting similar error messages. For this query, I’m using this code: Pagination = List.Skip( List.Generate( () => [Page_Key = "in...

User Statistics

User Activity

Airtable, API, Power BI, and over 100 records

Re: Airtable, API, Power BI, and over 100 records

Re: Airtable, API, Power BI, and over 100 records

Re: Airtable and Power BI

Re: Airtable link to Excel via Power Query