Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

AirTable To PowerBI Limit Removal of 100 Rows

Topic Labels: API
Jump to Solution
1235 1
Showing results for 
Search instead for 
Did you mean: 


I’d like to remove the limit of 100 Rows on pagination in PowerBI.
Can anybody please provide some code as I’m not good at code.
Here is my current code:

Source = Json.Document(Web.Contents(" Inning Report?api_key=my_key_here")),
#"Converted to Table" = Record.ToTable(Source),
Value = #"Converted to Table"{0}[Value],
#"Converted to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table1", "Column1", {"id", "fields", "createdTime"}, {"", "Column1.fields", "Column1.createdTime"}),
#"Expanded Column1.fields" = Table.ExpandRecordColumn(#"Expanded Column1", "Column1.fields", {"OpportunityID", "New Category", "Anticipated Timing", "Country", "Existing LP", "Client", "Reporting Name", "Low", "High", "Expected", "Comment", "Account", "BAI Status", "Status"}, {"Column1.fields.OpportunityID", "Column1.fields.New Category", "Column1.fields.Anticipated Timing", "Column1.fields.Country", "Column1.fields.Existing LP", "Column1.fields.Client", "Column1.fields.Reporting Name", "Column1.fields.Low", "Column1.fields.High", "Column1.fields.Expected", "Column1.fields.Comment", "Column1.fields.Account", "Column1.fields.BAI Status", "Column1.fields.Status"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1.fields",{{"Column1.fields.New Category", type text}, {"Column1.fields.Low", Int64.Type}, {"Column1.fields.High", Int64.Type}, {"Column1.fields.Expected", Int64.Type}, {"Column1.fields.Status", type text}, {"Column1.fields.Existing LP", type text}}),
#"Sorted Rows" = Table.Sort(#"Changed Type",{{"Column1.fields.OpportunityID", Order.Ascending}}),
#"Renamed Columns" = Table.RenameColumns(#"Sorted Rows",{{"Column1.fields.OpportunityID", "OpportunityID"}, {"Column1.fields.New Category", "GEPIFCategory"}, {"Column1.fields.Anticipated Timing", "AnticipatedTiming"}, {"Column1.fields.Country", "Country"}, {"Column1.fields.Existing LP", "ExistingLP"}, {"Column1.fields.Client", "LPName"}, {"Column1.fields.Reporting Name", "ReportingName"}, {"Column1.fields.Low", "TargetLow"}, {"Column1.fields.High", "TargetHigh"}, {"Column1.fields.Expected", "TargetExpected"}, {"Column1.fields.Comment", "OpportunityNote"}}),
#"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Column1.fields.BAI Status", "Column1.fields.Status", "Column1.createdTime"})
#"Removed Columns"
1 Solution

Accepted Solutions

I think this will help - How to send more than 100 records using API?

See Solution in Thread

1 Reply 1

I think this will help - How to send more than 100 records using API?