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

[hachishti]

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"

[Marcky]

if you could help us here @ghoshabhijeet 

[ghoshabhijeet]

@Marcky  Sure. I can help you on this. Please provide the pbix file.

[Marcky]

Hi @ghoshabhijeet i sent it to you already. Thank you so much for your reply

[ghoshabhijeet]

Thanks @Marcky for sharing the file. I have replied to your message. Please check.

[Marcky]

Hi @ghoshabhijeet  ive sent you the updated

[ghoshabhijeet]

@Marcky  Please check my reply. Thanks !

[Marcky]

is this resolve? im having the same issue and we also have the same source https://community.powerbi.com/t5/Service/This-dataset-includes-a-dynamic-data-source-Since-dynamic-d...

please share your resolution if its resolved thanks.

[Jayaselvan]

Could you please share the error message?

Sharing an error snaphot is good or the pbi file is the best.

[hachishti]

hi @Jayaselvan , Thanks for your reply.

below is the error screenshot

Moreover, I have updated the Power Query which causes the above error in refreshing the data source. In the PBIX file, there is no issue, once I publish the pbix and then refresh the error occurs. 

[ghoshabhijeet]

@hachishti  Could you please share the pbix file ? If yes, please upload the file on a cloud drive and share the link. If you want you can share the link on private message. Thanks !