Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Use RelativePath and Query options for Web.Contents()
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.