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"
