Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a GET API call as source but table is limited to just 200 rows. I am at 216 rows of data and tested the GET response in postman - where I am showing 216.
I show in step 216 being recognized as count but in table it is only showing 200 rows. Is there an adjustment I am misisng to get all 216 rows?
I
Tried different avenues, but this one worked for me.
Opening the Query Editor, then looking for the button "Advanced Editor" and then when opening the coding section, went form this:
let
Source = Json.Document(Web.Contents("https://publicapi.mycompany.com.au/rosters", [Headers=etc...
I added this:
let
Source = Json.Document(Web.Contents("https://publicapi.mycompany.com.au/rosters?limit=1000", [Headers=etc
And it worked!
Most public APIs limit the amount of data returned per request. I don't know what API you're making your requests to, but most likely you'll need to paginate through multiple pages to bring back all 216 rows. I'm fond of using the `List.Generate()` Power Query function for API pagination.
Can you provide the Power Query M script you're using to make this request to the API? Also, can you provide the URL to the API documentation?
It is, been struggling with scripts to try and get this to work. New to this, but this is script now
let
Source = Web.Contents("https://api.mavenlink.com/api/v1/time_entries?from_archived_workspaces=true&per_page=5000" & "from_archived_workspaces=true", [Headers=[Authorization="bearer keyishere12345"]]),
convertToJson = Json.Document(Source),
time_entries = convertToJson[time_entries],
#"Converted to Table" = Record.ToTable(time_entries),
#"Expanded Value" = Table.ExpandRecordColumn(#"Converted to Table", "Value", {"created_at", "updated_at", "date_performed", "time_in_minutes", "billable", "notes", "rate_in_cents", "cost_rate_in_cents", "currency", "currency_symbol", "currency_base_unit", "user_can_edit", "approved", "taxable", "is_invoiced", "story_id", "workspace_id", "user_id", "active_submission_id", "id"}, {"Value.created_at", "Value.updated_at", "Value.date_performed", "Value.time_in_minutes", "Value.billable", "Value.notes", "Value.rate_in_cents", "Value.cost_rate_in_cents", "Value.currency", "Value.currency_symbol", "Value.currency_base_unit", "Value.user_can_edit", "Value.approved", "Value.taxable", "Value.is_invoiced", "Value.story_id", "Value.workspace_id", "Value.user_id", "Value.active_submission_id", "Value.id"})
in
#"Expanded Value"
GET of all time entries