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

[Marcky]

The error Occurs when refreshing in Power BI Service but when refreshing in Power BI Desktop its working perfectly fine.

This is the code.

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

let

    Source = PowerBI.Dataflows([]),

    #"72da37b2-4dc9-43ac-819d-6c0de9ff51bf" = Source{[workspaceId="72da37b2-4dc9-43ac-819d-6c0de9ff51bf"]}[Data],

    #"9b1df221-93b4-4967-83ed-a10470a9275e" = #"72da37b2-4dc9-43ac-819d-6c0de9ff51bf"{[dataflowId="9b1df221-93b4-4967-83ed-a10470a9275e"]}[Data],

    Projects1 = #"9b1df221-93b4-4967-83ed-a10470a9275e"{[entity="Projects"]}[Data],

    #"Removed Other Columns" = Table.SelectColumns(Projects1,{"ProjectId", "ProjectName", "ProjectWorkspaceInternalUrl", "EnterpriseProjectTypeName", "State"}),

    #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each [EnterpriseProjectTypeName] = "Project" or [EnterpriseProjectTypeName] = "Product"),

    #"Filtered Rows5" = Table.SelectRows(#"Filtered Rows", each not Text.StartsWith([ProjectName], "zz")),

    #"Filtered Rows4" = Table.SelectRows(#"Filtered Rows5", each [ProjectName] <> null and [ProjectName] <> ""),

    #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows4", each [EnterpriseProjectTypeName] <> null and [EnterpriseProjectTypeName] <> ""),

    #"Filtered Rows2" = Table.SelectRows(#"Filtered Rows1", each ([ProjectWorkspaceInternalUrl] <> null and [ProjectWorkspaceInternalUrl] <> "") and ([State] = "4_Active")),

    LoadIssues2 = (site as text) =>

        let

            Source = OData.Feed(site&"/_api/web/lists/GetByTitle('Issues')/Items()?")

        in

            Source,

    #"Added Custom" = Table.AddColumn(#"Filtered Rows2", "GetIssueData", each LoadIssues2([ProjectWorkspaceInternalUrl])),

    #"Expanded GetIssueData" = Table.ExpandTableColumn(#"Added Custom", "GetIssueData", {"FieldValuesAsText"}, {"FieldValuesAsText"}),

    #"Expanded FieldValuesAsText" = Table.ExpandRecordColumn(#"Expanded GetIssueData", "FieldValuesAsText", {"ID", "Title", "Owner", "AssignedTo", "Status", "Priority", "DueDate", "Discussion", "Resolution", "Description", "Escalation_x0020_Level"}, {"ID", "Title", "Owner", "AssignedTo", "Status", "Priority", "DueDate", "Discussion", "Resolution", "Description", "Escalation_x0020_Level"}),

    #"Filtered Rows3" = Table.SelectRows(#"Expanded FieldValuesAsText", each ([Status] = "(1) Active"))

in

    #"Filtered Rows3"

[chipui]

You may want to refer this blog https://tengkuma.vercel.app/blog/posts/conquering-urls-with-relativepath-and-query-in-power-bi 

[v-yangliu-msft]

Hi  @Marcky ,

As the error indicates you have got a data source where it is dynamically created.
You can try to go into Power Query and click on Data Sources, it will say Hand Authored data source. You will then need to fix your table where this occurs.

Refer to, which describes how to set a scheduled refresh on a dynamic data source in Power BI:

https://medium.datadriveninvestor.com/setting-a-scheduled-refresh-on-a-dynamic-data-source-in-power-...

This is the related document, you can view this content:

Solved: This dataset includes a dynamic data source. Since... - Microsoft Power BI Community

Solved: Help: Dataset includes a dynamic data source error - Microsoft Power BI Community

Solved: Dynamic data sources aren't refreshed in the Power... - Microsoft Power BI Community

Solved: Power BI Service with dynamic data sources - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Marcky]

Hi @v-yangliu-msft 

I tried to make sa web content on it how ever this what im getting,

here's the query

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

LoadIssues2 = (site as text) =>
let
Source = Web.Contents(
"https://sample.sharepoint.com/sites/pwa",
[
RelativePath= Text.Combine({"/", Text.Range(site,43), "/_api/web/lists/GetByTitle('Issues')/Items()?"}),
Query=""
] )
in
Source,
#"Added Custom" = Table.AddColumn(#"Filtered Rows2", "GetIssueData", each LoadIssues2([ProjectWorkspaceInternalUrl]))

im Getting Binary result instead of table.

then when i combine the files here's the result.