Hi,
I have a query that works perfectly fine when updating manually. But when I try to set the automatic update, the report gives me an error because the dataset includes a dynamic data source. Also the data sources list has a warning that some data sources are missing from the list. Does anyone have an idea how to fix the query so that the red marked part would appear in the data sources list?
let
Source = Json.Document(
Web.Contents(
URL&"/rest/api/2/search?maxResults=-1",
[Query=[jql=QUERY]]
)
),
#"Record to Table" = Record.ToTable(Kysely1),
Value = #"Record to Table"{4}[Value],
#"Record to Table1" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expand Column1" = Table.ExpandRecordColumn(#"Record to Table1", "Column1", {"expand", "id", "self", "key", "fields"}, {"Column1.expand", "Column1.id", "Column1.self", "Column1.key", "Column1.fields"}),
#"Added Custom" = Table.AddColumn(#Expand Column1", "worklog url", each "https://xx.com/rest/api/latest/issue/"&[Column1.key]&"/worklog"),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "worklog", each Json.Document(Web.Contents([worklog url])))
in
#"Added Custom1"
Thanks in advance!
Julia
