Report server On Premise refresh failed
Dear all i have a strange problem with our PBI On-Prem 2024.sept version server. A lot of reports are not refreshing sheduled, nor manual. It says "Completed Data Refresh", last run: a date from yesterday. If i add a new schedule, it keeps saying "Refreshing". in PBI server Logs i cannot see any serious or refresh related error. On MSSQL server Agent, all scheduled jobs did run with OK result. I installed the PBI server on another machine, copied the ReportServerDB and TempDB and the problem is still the same on the new server. What sould i check? Thank you for your help!
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,
Gateway Error - Can't Refresh Published Dashboards : Non-gateway network exception encountered in ac
I'm experiencing issues with the scheduled refresh on my Power BI dashboards. I have six published dashboards that have been running smoothly since January, but since last week, I've been encountering gateway errors. My gateway starts running at 12:10 AM, followed by a scheduled refresh at 1:30 AM. However, only one dashboard completes the refresh, while the others crash. Interestingly, I have another scheduled refresh at 1:30 PM, and this one runs without any problems. While reviewing the error logs, I found the following: DM.EnterpriseGateway Error: 1 : 2024-09-06T04:31:30.3353144Z DM.EnterpriseGateway [DM.NetworkCore] Non-gateway network exception encountered in activity scope: System.ServiceModel.CommunicationException: The socket connection has been disposed. Timestamp:2024-09-06T04:31:30 ---> System.IO.IOException: The write operation failed, see inner exception. ---> System.ServiceModel.CommunicationException: The socket connection has been disposed. ---> System.ObjectDisposedException: Cannot access a disposed object. This error occurred exactly when my dashboards were scheduled to refresh. Can anyone help me understand what's going on?Semantic Model & Dataflow refresh error visible directly in workspace
Currently, when a Semantic Model or Dataflow is failing a user only sees a triangle with an exclamation mark which notifies the user something has gone wrong. Instead of just warning the user that something has gone wrong it would be a good feature to actually show what the latest refresh error was caused by. I've created an idea to implement a feature (See link below) that would allow for faster debugging since the proposal is to show the latest error immediately in the workspace rather than having to click on the error symbol and downloading the file for an extensive report. Microsoft Idea
