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?Showing old existing/latest data until there's a new data uploaded
Hello everyone, i have problem to show any data that appeared on July 22nd and July 30th. How to add a function that can show existing data in date slicer selection (like if on July 23rd until July 29th there's no data uploaded, data from July 22nd still shown). Until new data uploaded, only latest data shown. Is there any DAX that can i implement? like creating ins_true tabe colum with TRUE/ FALSE boolean data type or anything else? Thanks. PS: the "issue_progress" is a Text/string data type
Column value change based on matrix hierarchy
Hello, I have a matrix visualization that utilizes a hierarchy. I also have a target value that changes based on the hierarchy. What DAX should I use so that the value changes in accordance with the hierarchy? The top line visual looks like this: Supply Chain MTD YTD Target GSC 76.7% 76.7% 75.9% PSM 79.5% 79.5% 76.9% And then the drill down looks like this: Product Site MTD YTD Target GSC A RV 100.0% 100.0% 70.0% A UM 50.0% 50.0% 75.0% A BC 72.4% 72.4% 70.0% PSM P BC 55.6% 55.6% 70.0% P W 47.6% 47,6% 70.0% P I 53.3% 53.3% 70.0% Note that the target for each supply chain has one value, and then those targets change again depending on the combination of product and site. Ideally, I'd be able to conditionally format the MTD value depending on whether it was more or less than the target.Hyperlink in Power-BI to local filesystem
When I want a hyperlink tot al localfile I can use file: //blabla.xls in stead of https ://www.blabla . I want to do soemthing similar in a text box. in Power BI. So only people with access to our local netwerkdrive may open this link. It seems not a standard thing, or do I miss something relevant? thanks for your reply.
