Help

AirTable To PowerBI Limit Removal of 100 Rows

Topic Labels: API
Solved
Jump to Solution
2152 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Waseem_Khan
4 - Data Explorer
4 - Data Explorer

Hi,

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:

let
Source = Json.Document(Web.Contents("https://api.airtable.com/v0/appqRdDk5cCOPccJ5/Third 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.id", "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"})
in
#"Removed Columns"
1 Solution

Accepted Solutions
Bill_French
17 - Neptune
17 - Neptune

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

See Solution in Thread

1 Reply 1
Bill_French
17 - Neptune
17 - Neptune

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