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.
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Can you please help?
Below is the query that's causing the error. It works fine in PowerBI Desktop. Fails the refresh routine in PowerBI portal.
let
Source = Json.Document(Web.Contents("https://jda.com/api/sitecore/Search/GetKnowledgeCenterSearchResults?mode=expanded")),
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"body", "color", "contentType", "date", "description", "fileSource", "formattedDate", "headline", "industries", "industryDisplay", "language", "photo", "salesTags", "tags", "title", "url", "urlTarget", "videoID", "videoType"}, {"body", "color", "contentType", "date", "description", "fileSource", "formattedDate", "headline", "industries", "industryDisplay", "language", "photo", "salesTags", "tags", "title", "url", "urlTarget", "videoID", "videoType"}),
#"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"date", type datetime}, {"formattedDate", type date}}),
#"Expanded industries" = Table.ExpandListColumn(#"Changed Type", "industries"),
#"Removed Columns" = Table.RemoveColumns(#"Expanded industries",{"body", "color", "tags"}),
#"Added Custom" = Table.AddColumn(#"Removed Columns", "Pitch Perfect - Solutions.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"Solution")))})),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Pitch Perfect - Products.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"Product")))})),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "Pitch Perfect Industry.Label", each List.Intersect({[salesTags],List.Distinct(Table.ToList(Table.SelectColumns(SalesCentralMaster,"SubIndustry")))})),
#"Expanded Solution" = Table.ExpandListColumn(#"Added Custom2", "Pitch Perfect - Solutions.Label"),
#"Expanded Product" = Table.ExpandListColumn(#"Expanded Solution", "Pitch Perfect - Products.Label"),
#"Expanded Industry" = Table.ExpandListColumn(#"Expanded Product", "Pitch Perfect Industry.Label")
in
#"Expanded Industry"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.