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()
This issue has been occuring for the past week, only for one specific report. Publishing from the desktop client still works normally and is being used as a manual refresh.
Details Type Start End Status Message
|On demand||21/09/2017 4:40:43 PM||21/09/2017 4:40:48 PM||Failed||The gateway operation has been cancelled explicitly by the user or from a timeout.|
I wondr if there is someone facing the same problem as me.
My Enterprise Gateway was working smoothly until yesterday. I don't know how but i cannot choose my EG to refresh my dataset :
I created a sample report to test the datasources, in the example below the error (EG disabled) is happening when i use a merge join in my power query :
when i deploy the report with this step i have this error "You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway"
but deploying without the merge join, everything works fine => i can select the EG!
I use Two souces in my report :
SQLSEVER for RLS table
Excle file for Fichier table
It seems strange to have this issue after a join operation in the model.
Thank you in advance for your help.
Yesterday, all my datasets were refreshing just fine but today nothing happens.
- The automatic refresh hasn't done anything.
- When I press "Refresh now", I get a "popup" saying "preparing refresh" for a split second and then nothing happens.
The only way to update the data is to refresh the Desktop version and then upload it.
I have datasets connection to an on-premises database and one connecting to a sharepoint site.
- The on-premises connection usually works perfect, but now nothing happens.
- The sharepoint connection usually brings up an error, if I try to refresh, but now nothing happens (I just tried it this time as a test, as it usually doesn't work automatically).
Can you please help troublefinding - It seems like an issue on you online portal somehow.
Thanks in advance.
Our report - which is based on MY SQL Queries - seems to experience difficulties regarding the scheduled refresh. This is the error that we got back:
If anyone can offer any advice or provide further information that would be highly appreciated
I'm getting this error since yesterday on a new dataset. It is a simple excel file table. I've done the following.
Signed out of Power BI Desktop and back in
Got the latest personal gateway
turned the gateway service off / on
republished multiple times during this process.
Others seem to be having the same issue. see thread here
There is a current support site error message, but it is specific to SharePoint as a data source only.
I have two accounts, one paid pro, the other a trial pro account. Come June 1st and my gateway is offline and not able to reconnect ot the service?
Here is the message I get in my gateway: "Please wait while the gateway connects to the serivce"
Since yesterday I'm having an issue connecting to an excel file in a Sharepoint folder. It was already working, but I made some changes and republished it. Refresh works fine in Power BI Desktop, but online. It seem it's trying to connect to a Sharepoint list, instead of folder. I have an other report connecting to an other excel file in the same folder and it works fine. Could this be connected to the issue in North Europe? I'm in that datacenter.
This morning, when I started Power BI Gateway - Personal, it failed with the error, "GWConf has stopped working A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available." I uninstalled and re-installed the application but am still getting the same error. The Personal gateway as worked flawlessly for weeks prior to today. I'm not aware of any changes being made to my PC but I'm using a company computer and sometimes our IT department pushes out updates without prior notification. Where do I begin looking for the cause of the failure? (I'm just a Power BI user, not a developer.)
We are running out of memory when using the aggregation function on the data query editor. It has been working for the last 6 months with no issue.
From the refresh
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
The gateways seem to disconnect from the cloud account , trying to re insert them gives an error
"personal gateway sign in error: an unknown state error occurred Initial Response"
Could someone please advise ? ?
I've published a report from my work account.
Under Dataset Settings it shows Datagateway error and shows:
This data set has been configured by *email@example.com .
I've tripple checked my credential, sign-out and in ...
I see my WORK environment, but it somehow connects the Dataset to gmail....
And doesn't allow me to set up Enterprise Gatway for Dataset or Refresh
I know others are experiencing same issue here:
I'm having trouble loading my report measures when using DirectQuery for SAP BW on Power BI cloud service.
Here is the error message:
"Couldn't load the data for this visual
Please try again later or contact support. If you contact support, please provide these details.
- I'm loading dimensions and measures (key figures) from Bex Query perfectly well in Power BI Desktop;
- The issue happens only with Measures on the Power Bi Service after publishing the report;
- Dimensions and Hierarchies are loading seamlessly on Power BI service;
- The Data Gateway is up and running;
- I've tried to convert the measures into currency format but to no avail;
- "Send a Frown (Error)" is not available in the error message window to report the technical issue;
Has anyone run into the same problem using DirectQuery (beta) and Data Gateway connecting to a Bex Query? (SAP BW)
Unable to sign in from Power BI Desktop and Enterprise Gateway after implementing Conditional AccessStatus: Investigating
We have a production implementation of Power BI for which we turned on device based Conditional Access (CA), and added relevant AD groups. After turning on CA, users in the device based AD group are unable to sign in from Power BI desktop and also cannot sign in upon installation of a new Enterprise Gateway.
We get the following message: Unable to sign in. Sorry we encountered an error while trying to sign you in. Details: AADSTS50000. Device platform Unknown used by the user is an unsupported device platform. Supported device platforms are iOS, Android, and Windows flavors.
We are on a Windows platform and tested from Windows 8 and Windows 7 machines, and encountered the same error on both. This issue applies to October 2016 and September 2016 versions of desktop. To prove that CA triggered this issue, we used a test user not in the device based AD group. The test user was able to sign in successfully.
This issue is critical as it prevents us from being able to publish directly from Power BI desktop and prevents users from installing a new Enterprise Gateway.
Please let me know if you need any additional information. If you need Trace ID, Correlation ID or Timestamp, I can provide it via email.
Power BI Desktop seems to be signing me out of my Power BI account. When I go to publish a report while not signed in it asks me for my credentials, but doesn't allow me to type anything in. I have to open Task Manager and Force Close Power BI, reopen, Sign In, then publish.
Starting at around 4:00 AM CST on 4/21/2017 the automated PBI refreshes from Azure Analysis Services has stopped working. I had to manually refresh all of my reports data sources at 7:20AM CST.
My cube processes every hour, and the PBI datasets are scheduled to automatically refresh every 15 minutes refresh. I have already waited over an hour for the automated refresh to occur, and it has not yet happened.
Please see screenshot below.
Here are the details from "About Power BI"
TimeFri Apr 21 2017 08:39:55 GMT-0500 (Central Daylight Time)
Your data is stored inNorth Central US (Illinois)
After upgrading the Personal gateway to the june version blank date fields gets imported as 1899 dates rendering my reports broken (since I filter on e.g deleted_at = blank).
Swithced back to older version (Apr release) returns import to normal behaviour.
This is an on premises scheduled refresh from an AWS RDS ProstgreSQL DB.
Any idea on how to correct this?
Still unable to refresh on Power BI Service (Online), where we have a numbe of reports that employees rely on for daily data.
Do we have an idea when this is going to be fixed? I am a user in the UK