Hello,
I have the following query in a power bi report which I uploaded to Power BI service.:
let
// Read all pages of data.
// After every page, we check the "NextLink" record on the metadata of the previous request.
pages = GetAllPages(indexName, "file"),
#"Expanded _source" = Table.ExpandRecordColumn(pages, "_source", {"owner", "last_access", "extension", "last_change", "filesize", "dupe_md5", "doctype", "PII", "filename", "indexing_date", "filehash", "path_parent", "host_path", "last_modified", "named_entities", "group", "dupe_last_modified", "dupe_first_created", "rules_name", "rule_outcome", "category"}, {"owner", "last_access", "extension", "last_change", "filesize", "dupe_md5", "doctype", "PII", "filename", "indexing_date", "filehash", "path_parent", "host_path", "last_modified", "named_entities", "group", "dupe_last_modified", "dupe_first_created", "rules_name", "rule_outcome", "category"}),
#"Expanded _source.named_entities" = Table.ExpandRecordColumn(#"Expanded _source", "named_entities", {"NamedLocations", "NamedPeople", "NamedOrganisations"}, {"NamedLocations", "NamedPeople", "NamedOrganisations"}),
#"Expanded _source.PII" = Table.ExpandRecordColumn(#"Expanded _source.named_entities", "PII", {"HasPhone", "HasPCI", "HasPerson", "HasPII", "HasEmail"}, {"HasPhone", "HasPCI", "HasPerson", "HasPII", "HasEmail"}),
#"Removed Blank Rows" = Table.SelectRows(#"Expanded _source.PII", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
#"Changed Type" = Table.TransformColumnTypes(#"Removed Blank Rows",{{"last_access", type datetime}, {"last_change", type datetime}, {"indexing_date", type datetime}, {"last_modified", type datetime}})
in
#"Changed Type"
When I try to refresh this report in Power BI Service it gives me the following error:
"You can't schedule refresh for this semantic model because the following data sources currently don't support refresh: Data source for Query1"
I'm assuming the error refers to the query.
A little more info around this:
- The report connects to an 'http' adress (elastic server).
- When I click on Data Source settings it shows the following "c:\users\names\microsof....json"
The main question I have is if the refresh error message I'm getting is related to the query or the json file (which I don't have access to)?
If it's related to the query, I'd appreciate if someone could guide me in the right direction to fix it. Not necessarily expecting a full blown solution, but some direction as to what to review or change and I should be able to figure it out from there.
Thank you!
