Can't schedule refresh as Web.Content is used
Hello, I've been trying to connect a Power BI report to gitlab to extract data related to current issues. The Report uses the following query : SRC : (base_url, rel_url_part1 and token_value are parameters) let BaseURL_1 = base_url, URL_1 = rel_url_part1, Source_1 = Web.Contents(BaseURL_1,[RelativePath = URL_1,Query = [state="all",scope = "all",per_page = "100",page = "1"],Headers=[Authorization=token_value]]), JsonDoc_1 = Json.Document(Source_1), table_1 = Table.FromList(JsonDoc_1, Splitter.SplitByNothing(), null, null, ExtraValues.Error), expand = Table.ExpandRecordColumn(table_1, "Column1", {"id", "iid", "project_id", "title", "description", "state", "created_at", "updated_at", "closed_at", "closed_by", "labels", "milestone", "assignees", "author", "type", "assignee", "user_notes_count", "merge_requests_count", "upvotes", "downvotes", "due_date", "confidential", "discussion_locked", "issue_type", "web_url", "time_stats", "task_completion_status", "has_tasks", "task_status", "_links", "references", "severity", "moved_to_id", "service_desk_reply_to"}, {"id", "iid", "project_id", "title", "description", "state", "created_at", "updated_at", "closed_at", "closed_by", "labels", "milestone", "assignees", "author", "type", "assignee", "user_notes_count", "merge_requests_count", "upvotes", "downvotes", "due_date", "confidential", "discussion_locked", "issue_type", "web_url", "time_stats", "task_completion_status", "has_tasks", "task_status", "_links", "references", "severity", "moved_to_id", "service_desk_reply_to"}), filter = Table.SelectRows(expand, each Text.Contains([web_url], "xxxxx")), expand_columns = Table.ExpandRecordColumn(filter, "closed_by", {"id", "name"}, {"closed_by.id", "closed_by.name"}), expand_columns2 = Table.ExpandListColumn(expand_columns, "labels"), expand_columns3 = Table.ExpandListColumn(expand_columns2, "assignees"), expand_columns4 = Table.ExpandRecordColumn(expand_columns3, "assignees", {"id", "name"}, {"assignees.id", "assignees.name"}), expand_columns5 = Table.ExpandRecordColumn(expand_columns4, "author", {"id", "name"}, {"author.id", "author.name"}), expand_columns6 = Table.ExpandRecordColumn(expand_columns5, "assignee", {"id", "name"}, {"assignee.id", "assignee.name"}), expand_columns7 = Table.ExpandRecordColumn(expand_columns6, "references", {"full"}, {"references.full"}), remove_columns = Table.RemoveColumns(expand_columns7,{"user_notes_count", "merge_requests_count", "upvotes", "downvotes", "confidential", "discussion_locked", "time_stats", "task_completion_status", "has_tasks", "task_status", "_links", "references.full", "moved_to_id", "service_desk_reply_to"}) in remove_columns I get to refresh data locally, but when I publish to the workspace I get this error : Scheduled refresh is disabled because at least one data source is missing credentials Could you kindly help me find the origine of this error ? Thanks in advance,