Skip to main content

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"

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

Reply


Terms & Conditions