I have the same issue, due to the same reason, and the article sent in the reply doesn't help at all, as the data sources are completely supported, but still gives the same error.
below is my source code for the report, let me know if u can detect the issue:
let
Source = Table.FromRecords({
[page=1],
[page=2],
[page=3],
[page=4],
[page=5],
[page=6],
[page=7],
[page=8],
[page=9],
[page=10]
}),
TicketsSince = Date.ToText(Date.AddDays(Date.From(DateTime.LocalNow()),-7),"yyyy-MM-dd"),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"page", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "responseJson", each Json.Document(Web.Contents("https://teamventi.freshdesk.com/api/v2/tickets?include=stats&per_page=100&page="&[page]&"&updated_si...))),
#"Expanded responseJson" = Table.ExpandListColumn(#"Added Custom", "responseJson"),
#"Expanded responseJson1" = Table.ExpandRecordColumn(#"Expanded responseJson", "responseJson", {"fr_escalated", "spam", "email_config_id", "group_id", "priority", "requester_id", "responder_id", "source", "company_id", "status", "subject", "product_id", "id", "type", "due_by", "fr_due_by", "is_escalated", "description", "description_text", "custom_fields", "created_at", "updated_at", "stats", "requester"}, {"fr_escalated", "spam", "email_config_id", "group_id", "priority", "requester_id", "responder_id", "source", "company_id", "status", "subject", "product_id", "id", "type", "due_by", "fr_due_by", "is_escalated", "description", "description_text", "custom_fields", "created_at", "updated_at", "stats", "requester"}),
#"Expanded requester" = Table.ExpandRecordColumn(#"Expanded responseJson1", "requester", {"name", "email", "mobile", "phone"}, {"requester.name", "requester.email", "requester.mobile", "requester.phone"}),
#"Expanded stats" = Table.ExpandRecordColumn(#"Expanded requester", "stats", {"resolved_at", "first_responded_at", "closed_at"}, {"stats.resolved_at", "stats.first_responded_at", "stats.closed_at"}),
#"Expanded custom_fields" = Table.ExpandRecordColumn(#"Expanded stats", "custom_fields", {"technology_platform", "hours_estimate"}, {"technology_platform", "hours_estimate"}),
#"Added Custom1" = Table.AddColumn(#"Expanded custom_fields", "Conversations", each Json.Document(Web.Contents(" https://teamventi.freshdesk.com/api/v2/tickets/"&Number.ToText([id])&"/conversations"))),
#"Filtered Rows" = Table.SelectRows(#"Added Custom1", each ([id] <> null)),
#"Changed Type1" = Table.TransformColumnTypes(#"Filtered Rows",{{"created_at", type datetime}}),
#"Filtered Rows1" = Table.SelectRows(#"Changed Type1", each [created_at] >= DateTime.FromText(TicketsSince)),
#"Expanded Conversations" = Table.ExpandListColumn(#"Filtered Rows1", "Conversations"),
#"Expanded Conversations1" = Table.ExpandRecordColumn(#"Expanded Conversations", "Conversations", {"id", "incoming", "user_id"}, {"id.1", "incoming", "user_id"}),
#"Reordered Columns" = Table.ReorderColumns(#"Expanded Conversations1",{"page", "fr_escalated", "spam", "email_config_id", "group_id", "priority", "requester_id", "responder_id", "source", "company_id", "status", "subject", "product_id", "id", "type", "due_by", "fr_due_by", "is_escalated", "description", "description_text", "technology_platform", "hours_estimate", "created_at", "updated_at", "requester.name", "requester.email", "requester.mobile", "requester.phone", "id.1", "incoming", "user_id"}),
#"Merged Queries" = Table.NestedJoin(#"Reordered Columns",{"responder_id"},agents,{"id"},"agents",JoinKind.LeftOuter),
#"Expanded agents" = Table.ExpandTableColumn(#"Merged Queries", "agents", {"email", "job_title", "name", "phone"}, {"Agent.email", "Agent.job_title", "Agent.name", "Agent.phone"}),
#"Merged Queries1" = Table.NestedJoin(#"Expanded agents",{"company_id"},companies,{"id"},"companies",JoinKind.LeftOuter),
#"Expanded companies" = Table.ExpandTableColumn(#"Merged Queries1", "companies", {"name"}, {"Company.name"}),
#"Merged Queries2" = Table.NestedJoin(#"Expanded companies",{"status"},Status,{"Status Value"},"Status.1",JoinKind.LeftOuter),
#"Expanded Status.1" = Table.ExpandTableColumn(#"Merged Queries2", "Status.1", {"Status Name"}, {"Status.1.Status Name"}),
#"Merged Queries3" = Table.NestedJoin(#"Expanded Status.1",{"user_id"},agents,{"id"},"agents",JoinKind.LeftOuter),
#"Expanded agents1" = Table.ExpandTableColumn(#"Merged Queries3", "agents", {"name"}, {"agents.name"}),
#"Reordered Columns1" = Table.ReorderColumns(#"Expanded agents1",{"page", "fr_escalated", "spam", "email_config_id", "group_id", "priority", "requester_id", "responder_id", "source", "company_id", "status", "subject", "product_id", "id", "type", "due_by", "fr_due_by", "is_escalated", "description", "description_text", "technology_platform", "hours_estimate", "created_at", "updated_at", "requester.name", "requester.email", "requester.mobile", "requester.phone", "id.1", "agents.name", "incoming", "user_id", "Agent.email", "Agent.job_title", "Agent.name", "Agent.phone", "Company.name", "Status.1.Status Name"}),
#"Renamed Columns" = Table.RenameColumns(#"Reordered Columns1",{{"id", "Tickets"}, {"id.1", "Interaction"}, {"Company.name", "Company"}}),
#"Changed Type2" = Table.TransformColumnTypes(#"Renamed Columns",{{"stats.resolved_at", type datetime}, {"stats.first_responded_at", type datetime}, {"fr_due_by", type datetime}, {"due_by", type datetime}}),
#"Added Custom2" = Table.AddColumn(#"Changed Type2", "Resolution Status", each if [due_by] <> null and[stats.resolved_at] <>null and[due_by]<[stats.resolved_at]then "SLA Violated"else if [stats.resolved_at]<>null then"Within SLA" else null),
#"Renamed Columns1" = Table.RenameColumns(#"Added Custom2",{{"Status.1.Status Name", "Ticket Status"}})
in
#"Renamed Columns1"
