Hello,

I’m attempting to integrate Airtable and Power BI to create reports. Using the API authentication key, I am able to connect to one of my tables in Power BI. However, the JSON string only contains 100 rows when connected.

Airtable and Power BI - mpolino.com I have gone through this blog but still only 100 records are loading.

Is this a limitation ?

this is my query

let

Pagination=List.Skip(List.Generate(()=> ;Page_Key = "init", Counter=0], 

each   Page_Key] <> null,

each   Page_Key = try if fCounter]<1 then "" else eWebCall]lValue]eoffset] otherwise null,		  	                       

WebCall  = try if fCounter]<1 then      

      Json.Document(Web.Contents("https://api.airtable.com/v0/mybasekey/tablename","Headers=sAuthorization="Bearer airtablekey"]]))

 else  

      Json.Document(Web.Contents("https://api.airtable.com/v0/mybasekey/tablename? offset:""" &pWebCall]lValue]eoffset], ,Headers=sAuthorization="airtablekey"]])),

      Counter = =Counter]+1

      ],

 each hWebCall]

),1),

#“Json2Table” = Table.RenameColumns(Table.FromList(Pagination, Splitter.SplitByNothing(), null, null, ExtraValues.Ignore),{{“Column1”, “stepA.1”}}),

#“Expanded stepA.1” = Table.ExpandRecordColumn(Json2Table, “stepA.1”, {“HasError”, “Value”}, {“stepA.1.HasError”, “stepA.1.Value”}),

#“stepA 1 Value” = #“Expanded stepA.1”{0}�stepA.1.Value],

#“Converted to Table” = Record.ToTable(#“stepA 1 Value”),

Value = #“Converted to Table”{0} Value],

#“Converted to Table1” = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)

in

#“converted to Table1”