Forum Discussion
This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the PBI
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:
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.
Hi Anonymous
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.