I am having issues installing the Power BI Gateway (powerbigatewayinstaller.exe). It seems the installer doesn't initiate/run. I think there might be an issue with the application itself, since I am having the same issues on three different computers.   I have tried:  Run as administrator Start the installer from Run Check the Task Manager if the process is actually running, with no trace of the gateway. So I figured I check the Event viewer, and found a .net runtime error with event id 1026. There's also an application error, but I presume this is down to the .net runtime error. The information from the event viewer is as follows:   Tillämpningsprogram: PowerBIGatewayInstaller.exe Framework-version: v4.0.30319 Beskrivning: Processen avslutades på grund av ett ohanterat undantag. Undantagsinformation: System.IO.FileNotFoundException vid Microsoft.DataProxy.PowerBIInstallDownloader.LandingPageViewModel..ctor(Microsoft.DataProxy.PowerBIInstallDownloader.MainViewModel) vid Microsoft.DataProxy.PowerBIInstallDownloader.MainViewModel..ctor() vid Microsoft.DataProxy.PowerBIInstallDownloader.MainWindow..ctor() Undantagsinformation: System.Windows.Markup.XamlParseException vid System.Windows.Markup.XamlReader.RewrapException(System.Exception, System.Xaml.IXamlLineInfo, System.Uri) vid System.Windows.Markup.WpfXamlLoader.Load(System.Xaml.XamlReader, System.Xaml.IXamlObjectWriterFactory, Boolean, System.Object, System.Xaml.XamlObjectWriterSettings, System.Uri) vid System.Windows.Markup.WpfXamlLoader.LoadBaml(System.Xaml.XamlReader, Boolean, System.Object, System.Xaml.Permissions.XamlAccessLevel, System.Uri) vid System.Windows.Markup.XamlReader.LoadBaml(System.IO.Stream, System.Windows.Markup.ParserContext, System.Object, Boolean) vid System.Windows.Application.LoadBamlStreamWithSyncInfo(System.IO.Stream, System.Windows.Markup.ParserContext) vid System.Windows.Application.DoStartup() vid System.Windows.Application.<.ctor>b__1_0(System.Object) vid System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) vid System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) vid System.Windows.Threading.DispatcherOperation.InvokeImpl() vid System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) vid System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) vid System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) vid MS.Internal.CulturePreservingExecutionContext.Run(MS.Internal.CulturePreservingExecutionContext, System.Threading.ContextCallback, System.Object) vid System.Windows.Threading.DispatcherOperation.Invoke() vid System.Windows.Threading.Dispatcher.ProcessQueue() vid System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) vid MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) vid MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object) vid System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) vid System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) vid System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32) vid MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr) vid MS.Win32.UnsafeNativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef) vid System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame) vid System.Windows.Application.RunDispatcher(System.Object) vid System.Windows.Application.RunInternal(System.Windows.Window) vid Microsoft.DataProxy.PowerBIInstallDownloader.App.Main()   ... View more

If I connect to Snowflake as per https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-snowflake   (using Snowflake as my IDp - without Microsoft AAD integration), and MFA token caching is enabled https://docs.snowflake.com/en/user-guide/security-mfa.html#label-mfa-token-caching     ALLOW_CLIENT_MFA_CACHING  = true ALLOW_ID_TOKEN  = true   I get 2 DUO push notifications for each dataset connected to PowerBI, each time the dataset is refreshed. MFA Tokens are not cached.   Due to delays or missing push notifications, the Snowflake account gets locked.   I have tested the Windows ODBC driver with the following authenticator option in a new DSN and it caches tokens perfectly: https://docs.snowflake.com/en/user-guide/odbc-parameters.html#additional-connection-parameters   authenticator=username_password_mfa   However it doesn't seem to work in the Simba Snowflake ODBC driver that is natively installed in PowerBI: C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\Simba Snowflake ODBC Driver even if I add it to a microsoft.snowflakeodbc.ini file: [Driver] authenticator=username_password_mfa ... View more

Using Enterprise Gateway  I am seeing some large numbers for DataProcessDuration. For example one value is 637,328,255,004,381 ms.  These large values appear to be random. They show up on different data sources including AD, SQL, SSAS, and SharePoint for different dates and time. The query reports as successful in each case. These very large numbers, though only a small percentage overall, skew the reports too a point where I will either have to replace the value with some average over time or delete the record all together.   Anyone else see this trend? Any thoughts of why these values are apparently incorrect yet the data suggest the refresh had no issue and reports a success?   Thanks     ... View more

   I used to run all power bi report including connecting odbc(redshift) & rscript, but staring from yesterda, all power bi report have lost the connectivity.   In gateway connection, gateway even is not shown     when I check onpremise data gateway status is online all.  Please advise me on how to fix this..     ... View more

Since this morning we've had issues in our tenant creating new dataflows - after entering connection details and clicking next, the dataflow GUI just spins. There are no issues with the gateways as they are fulfilling refresh requests just fine. Was there a deployment for dataflows recently?  I'm in North Central US btw ... View more

Hello,   Lately, we have issues with automatic update in PBI online accounts. I have 2 different reports, each has different CSV data source from our server. Almost every day the auto update fails.   During update one of the reports, PBI tries to update both data sources at once, do not know why. Additionaly, the update process sends 2, sometimes even more GET requests on the server at a time. First request is stopped by PBI during downloading the file. Usually, PBI sends requests, our server answers and sends the whole file successfully, but PBI do not use it and it ends with error anyway. We have tried to check all time limits on our side, but it seems to be OK. It is the same with small and large files.   Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.. The exception was raised by the IDataReader interface. Next refresh for name_of_the_file is scheduled for 01/13/2017 07:45:00.   Technical Information: Activity Id: ab3448f5-857b-4cd3-8470-6f5e007d16b8 Request Id: a5c2df24-fad2-4dcd-a367-59e453eb7bdf Cluster Name: WABI-NORTH-EUROPE-redirect.analysis.windows.net Refresh Start Time: 01/12/2017 07:07:01Z Refresh End Time: 01/12/2017 07:15:58Z ... View more

Since February 26, 2025, the traffic light colors in my published Power BI report are no longer displayed. The traffic lights appear black, whereas they show correctly in Power BI Desktop. These KPIs have remained unchanged for the past three years and were added via Tabular Editor 2 as 'Traffic Light - Single' status graphics.   It seems that the recent update to the Power BI Service Gateway (February 2025) may be affecting the display of the KPIs in the published report. I’m wondering if anyone else has experienced the same issue after this update, and if there is a solution. For more details on the update, see: https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-february-2025-release/   Thanks in advance for your help! ... View more

Starting earlier this week, we randomly started having refresh failures on a dataset that was primarly using a Folder Data Source connection. After reviewing the datasource on the gateway, the Folder source shows being "Partially Online". When I refresh the data source status again, it will show "Online". I can then refresh the dataset on demand for a short time, but then it will default back to Partially Online after an extended period and fail the next scheduled refresh. Is this a known issue/bug?? ... View more

I have some datasets that contain R scripts. They ran successfully for months.   Starting from today they can't be updated (Unable to detect a gateway. Please, verify the gateway is up and running).   I user personal gateway. Other datasets are still updated successfully. Data is successfully updated in Power BI Desktop.   What I tried to do. 1) restarted computer. 2) created new workspace and registered reports in new workspace. Activity ID: dd4ebe50-97a3-4633-982a-307b9ff1142e Request ID: fd0f567d-2461-4d2a-4e82-35e471759feb Correlation ID: ba12f0e6-9f22-0444-f32d-3067c7b914dd Status code: 500 Time: Mon Aug 01 2022 09:36:19 GMT+0300 (Eastern European Summer Time) Service version: 13.0.18756.45 Client version: 2207.4.12439-train Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/ ... View more

Our dataflows have jumped from 5 minutes to sometimes timing out at 3 hour limit. The gateways involved have all been updated to the latest version, and one dataflow doesn't even connect through a gateway because all sources are web.   Around the same time this started happening, publishing reports with exisiting datasets have started taking forever (30+ mins).  Twice now I've received a 500 error while trying to publish. Previously they took under 30s (8mb report), and if I delete the existing report and dataset pubishing speed is restored to this.   Even navigating PowerBI.com through the workspace settings has gotten slow and unreliable. Just now I got an error with a picture of an owl and the following message:   TECHNICAL DETAILS Power BI was unable to read the application metadata. Please check the Power BI service status in the below support page and try again later. Date and Time: 2020-10-14 18:54:41Z ActivityId: e13c3676-e36c-4be5-9fb5-0a1ebf8ec6ca   Any help would be greatly appreciated! ... View more

October and November 2024 releases of On-Premises gateway are not working with Azure Databricks.  The error from the logs: ODBC: ERROR [IM003] Specified driver could not be loaded due to system error  126: The specified module could not be found. (Simba Spark ODBC Driver New, C:\Program Files\On-premises data gateway\m\ODBC Drivers\New\Spark\SparkODBC_sb64.dll).   It appears this is a problem in these distributions. ... View more