Pagination & Dynamic Sources Inquiry

[krixtsup3r]

Hi Guys, I took a solution on this link regarding pagination:

https://community.powerbi.com/t5/Power-Query/Handling-a-Paginated-API-with-Prebuilt-Next-Page-URI-in...

I was able to load it successfully and got the data that I needed but upon publishing it in Service I am now getting an error about not being able to refresh it due dynamic sources. Is there any way to iterate this and work make it work? 

I am using Asana API as source and they are using 'next_page' for pagination. 

[lbendlin]

https://datachant.com/2016/06/27/cursor-based-pagination-power-query/

[krixtsup3r]

Hi @lbendlin , thanks for this I tried to use this but cant make it work out. My api link is like this:
"https://app.asana.com/api/1.0/projects?limit=100&workspace=*************&opt_fields=team,name,owner,...", [Headers=[Accept="application/json", Authorization="Bearer *************"]]

I have tried removing the part Headers=[Accept="application/json" but I get a credential error. Credentials on this one should be just anonymous but it's not working. Thank you.

[lbendlin]

Consider using relativepath and options to keep the base URL static.

[krixtsup3r]

I tried that but getting confused on which to put it exactly I have tried different ways in adding it but is not successful. Here is my code:

let
	    Source = Json.Document(Web.Contents("https://app.asana.com/api/1.0/projects?limit=100&workspace=***************&opt_fields=team,name,owner,current_status,due_on,start_on,created_at,modified_at,public,members,custom_fields,custom_field_settings,color,notes,html_notes,workspace,archived", [Headers=[Accept="application/json", Authorization="Bearer ***************"]])),
    #"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", {"gid", "color", "created_at", "current_status", "custom_fields", "custom_field_settings", "due_on", "html_notes", "members", "modified_at", "name", "notes", "owner", "public", "start_on", "team", "workspace", "archived"}, {"gid", "color", "created_at", "current_status", "custom_fields", "custom_field_settings", "due_on", "html_notes", "members", "modified_at", "name", "notes", "owner", "public", "start_on", "team", "workspace", "archived"}),
    #"Expanded team" = Table.ExpandRecordColumn(#"Expanded Column1", "team", {"gid", "resource_type"}, {"gid.1", "resource_type"})
in
    #"Expanded team"