This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Pow

Hello Guys...!

I'm getting an error in Datasource while using the below function in Power Query.

-------------------------------------

let
baseURL = "https://myorg.sharepoint.com/sites/PWA/_api/ProjectData/Projects()?$Filter=ProjectType ne 7",
Source = OData.Feed(baseURL, null, [Implementation="2.0"]),
#"Removed Other Columns1" = Table.SelectColumns(Source,{"ProjectId", "ProjectName", "ProjectWorkspaceInternalUrl"}),
#"Added Custom" = Table.AddColumn(#"Removed Other Columns1", "GetWeeklyUpdatesDataColumn", each LoadWeeklyUpdateData([ProjectWorkspaceInternalUrl])),
#"Expanded GetWeeklyUpdatesDataColumn" = Table.ExpandTableColumn(#"Added Custom", "GetWeeklyUpdatesDataColumn", {"Id", "Title", "KeyAchievements", "NextSteps", "Escalations", "ID"}, {"GetWeeklyUpdatesDataColumn.Id.1", "GetWeeklyUpdatesDataColumn.Title", "GetWeeklyUpdatesDataColumn.KeyAchievements", "GetWeeklyUpdatesDataColumn.NextSteps", "GetWeeklyUpdatesDataColumn.Escalations", "GetWeeklyUpdatesDataColumn.ID"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded GetWeeklyUpdatesDataColumn", each ([GetWeeklyUpdatesDataColumn.ID] <> null)),
#"Sorted Rows" = Table.Sort(#"Filtered Rows",{{"GetWeeklyUpdatesDataColumn.ID", Order.Descending}}),
#"--StartFindMaxId" = #"Sorted Rows",
GetMaxId = Table.Group(#"--StartFindMaxId", {"ProjectId"}, {{"MaxID", each List.Max([GetWeeklyUpdatesDataColumn.ID]), type number}}),
#"--EndFindMaxId" = #"--StartFindMaxId",
#"Merged Queries" = Table.NestedJoin(#"--EndFindMaxId", {"ProjectId"}, #"GetMaxId", {"ProjectId"}, "--EndFindMaxId", JoinKind.LeftOuter),
#"Expanded --EndFindMaxId" = Table.ExpandTableColumn(#"Merged Queries", "--EndFindMaxId", {"MaxID"}, {"MaxID"}),
#"Added Custom1" = Table.AddColumn(#"Expanded --EndFindMaxId", "MatchMaxID", each [MaxID] = [GetWeeklyUpdatesDataColumn.ID]),
#"Filtered Rows1" = Table.SelectRows(#"Added Custom1", each ([MatchMaxID] = true))
in
#"Filtered Rows1"