Data source errorWe cannot convert the value "[List]" to type List

[pradeepgali]

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.

Data source errorWe cannot convert the value "[List]" to type List.. The exception was raised by the IDataReader interface.

Cluster URIWABI-WEST-US-redirect.analysis.windows.net

Activity IDb086f14b-5950-6c03-35ca-1ebed29a9cc9

Request ID5c0721f5-2c01-4a90-e95d-a37b4e797b75

Time2017-06-12 12:18:02Z

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"

[v-haibl-msft]

@pradeepgali

I just tried to create the PBIX file on my side, but get following expression error in Query Editor. It seems that the SalesCentralMaster column does not exist. Do you have such error on you side? I'm using Anonymous credential.

Best Regards,
Herbert