gateways
157 Topics
Information is needed in order to combine data
I am getting this error message when refreshing (manually or via schedule) on Power BI service. This happened initially on a complex data model but I narrowed it down to being and issue with combine queries. I simulated another example with just 2 tables from 2 databases on the same SQL server. Both tables are appended. All works well on desktop but refresh fails on service. The gateway is installed and has always worked (and still works on other reports that do not use merging/appending queries). I have tried all combinations possible with the privacy settings with no success From other recent posts I understand I am not the only one to have this issue. For info, I do not think that it is the merging itself that causes the problem. I tried with 2 Excel tables on a SharePoint site and that worked just fine. ChristineSolved138KViews8likes29Comments
PowerBI web with MySQL Gateway and Excel on Sharepoint is not working?
Hi there, I have setup a Reporting with different sources: MySQL MailChimp Google Analytics Excel Files on a Sharepoint folder Within PowerBI desktop the refresh is working fine. For the web version I have setup a on-premises gateway for the mySQL and added the App for MailChimp and Google Analytics but see refresh for the web version is not working. I read that there are problems if you combine different sources at the web version. I also saw that after the upload the datasets are all in one instead of 4 different datasets(for each source one dataset) I have also found the following idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13405644-combine-enterprise-gateway-and-online-data-sources Is there no workaround for this issue at the moment? Best regards. DanielSolved1.8KViews0likes3CommentsAutomatic data refresh for Power BI embedded
Hi, I have implemented Power BI embedded in a web app and used the Python script to import the on-premises data to the Power BI. I use the power BI embedded generated sample .NET file without Channing anything. Question: Can we do the data automatically refresh without using the on-premises data gateway (personal mode) in the above embedded option? Can explain how to implement the automatic data refresh for Power BI embedded?667Views0likes1Comment
The On-premises data gateway installation has failed
Hi , Grretings for the day! I am trying to installing the gateway in my machine but am facing problem. Can you please help me on this. In my system below two are displaying disable mode: Use your data gateway (personal mode) Use a data gateway hence i cant able seleting the any one of them and when am trying to installing saying that : The On-premises data gateway installation has failed It looks like you are trying to reinstall. Please uninstall the current version first. here i uninstalled and again installed eventhough same problem note: below msg displaying under data source settings 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. This dataset has been configured by ******** Refresh history Gateway connection To use a data gateway, make sure the computer is online and the data source is added in Manage Gateways. A new personal gateway is available to connect to on-premises data.Install nowLearn more Use your data gateway (personal mode) Use a data gateway. Thanking you !Solved32KViews0likes11Comments
[Data Fabric] Dataflow Gen2 Error: Unable to Retrieve Data from Oracle for Large Date Range
Hello everyone, I'm running some tests with Data Fabric to retrieve data from Oracle and send it to the Lakehouse. I subscribed to the F2 license for testing purposes. Essentially, I create a Dataflow Gen2 pipeline to fetch a sales table from Oracle. This table has 200 million records and is over 120GB in size. In my pipeline, when I set a filter to retrieve only 1 day of data from the table, the pipeline works fine. However, when I increase the filter to retrieve 1 month of data, it throws an error. The errors I receive are: - There was a problem refreshing the dataflow. Please review the error message(s) below, fix the problem, and try again. (Request ID: d4f7561f-b5ad-4fe1-a3ac-4ed534a59292). -Error Code: Challenge Error, Error Details: Data source credentials are missing or invalid. Please update the connection credentials in settings, and try again. (Request ID: d4f7561f-b5ad-4fe1-a3ac-4ed534a59292). The gateway I'm using is the On-premises data gateway version 3000.178.9 (June/23).822Views0likes3Comments
Error when connecting to report that uses DirectQuery to SQL Server
Hi, Newbie here :) I published a report that uses DirectQuery to SQL Server. I have the personal mode gateway installed. The report looks fine on my desktop, but online I'm getting the error 'This data source can't be accessed by a data gateway' and then in the report holder I get 'Can't display the visual' with the below details 'Couldn't load the data for this visual Your data gateway (Power BI – personal) is offline, but a data gateway is available. Please try again later or contact support. If you contact support, please provide these details. Error CodeDMTS_NoGatewayWithAllDatasourcesToBindError Server'MyServer' Correlation IDbdb5b245-dcf2-1936-d3a1-12e0b08a095a Database 'MyDatabase' ConnectionType{FieldValue} Activity IDa61ee590-4f7c-446d-ba9c-6eacdbdc6037 Request ID5fddce3e-5c1e-f6b4-6d1d-4ee335f060e7 TimeWed Jun 14 2017 09:45:07 GMT+0100 (GMT Daylight Time) Version13.0.1700.2465 Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net' Please can you help? Is it possible this is a permissions issue? Thanks in advance! HannahSolved6.6KViews0likes4CommentsConnect to Snowflake Natively in Power BI Report Builder
I’m currently trying to connect to our instance of Snowflake from within Power BI Report Builder, and I’m not having a lot of success. Locally on my machine, I’m able to connect just fine using the ODBC connector. However, after publishing the report to a Power BI workspace I’m unable to actually run the report or manage the data source credentials. Have you encountered this kind of issue before with another client? If you’re not the right person to ask this question, please let me know. Just to give a little more context, we need to be able to connect to our instance of Power BI. Upon connecting, we would also need to be able to enter in Query text in the dataset properties window; and, if applicable, create an parameters needed for the report. We have a lot of existing reports that are pointed at our Azure SQL Database, and we’d like to be able to now point those at Snowflake. Most of those existing reports are made up of either query text, or executing a stored procedure. We have a on-prem gateway as well as a vNet gateway configured, but I'm wondering if it's not configured correctly.Solved6.1KViews0likes3CommentsGateway reports having a network connectivity issue with latest install
My on-premises gateway reported having a network connectivity issue with latest install. Here is the log contents: Starting trace on 1/23/2017 4:46:07 PM UTC Version: 13.0.1700.756 DM.EnterpriseGateway Information: 0 : 2017-01-23T16:46:25.4046482Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 CAB8F9C3 [DM.GatewayCore] Attempting to create and start service host for 'Transfer service' DM.EnterpriseGateway Information: 0 : 2017-01-23T16:46:25.4046482Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 F3B572FA [DM.GatewayCore] Using configured 'AutoDetect' for ServiceBus ConnectivityMode DM.EnterpriseGateway Information: 0 : 2017-01-23T16:46:25.4046482Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 FC975677 [DM.GatewayCore] Creating GatewayTransferServiceHost against 'sb://wabi-us-east2-relay30.servicebus.windows.net/65d329df-f033-497a-939a-4d17bd7c6522/' with following binding configuration: {"ReliableSession":{"Enabled":false,"Ordered":true,"InactivityTimeout":"00:10:00"},"HostNameComparisonMode":0,"ConnectionMode":0,"TransferMode":0,"MaxBufferPoolSize":8500000,"MaxBufferSize":8500000,"MaxConnections":1500,"ListenBacklog":10,"IsDynamic":false,"MaxReceivedMessageSize":8500000,"ReaderQuotas":{"MaxStringContentLength":8192,"MaxArrayLength":16384,"MaxBytesPerRead":4096,"MaxDepth":32,"MaxNameTableCharCount":16384,"ModifiedQuotas":0},"Scheme":"sb","EnvelopeVersion":{"NextDestinationActorValue":"http://www.w3.org/2003/05/soap-envelope/role/next"},"Security":{"Mode":1,"RelayClientAuthenticationType":0,"Transport":{"ProtectionLevel":2},"Message":{"ClientCredentialType":1,"AlgorithmSuite":"Default"}},"CloseTimeout":"00:01:00","Name":"GatewayServiceBusTransferBinding","OpenTimeout":"00:01:00","ReceiveTimeout":"06:00:00","MessageVersion":"Default","SendTimeout":"00:01:00"} DM.EnterpriseGateway Information: 0 : 2017-01-23T16:46:32.3265814Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 E5F6199B [DM.GatewayCore] Ignoring Faulted event for 'Transfer service' because it happened before the service host was actually opened DM.EnterpriseGateway Information: 0 : 2017-01-23T16:46:32.3265814Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 9EA26F93 [DM.GatewayCore] Transfer service faulted DM.EnterpriseGateway Information: 0 : 2017-01-23T16:46:32.3265814Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 612F4B3D [DM.GatewayCore] Aborting service host for 'Transfer service' that failed to create DM.EnterpriseGateway Information: 0 : 2017-01-23T16:46:32.3265814Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 47CFB9DF [DM.GatewayCore] Transfer service aborted DM.EnterpriseGateway Information: 0 : 2017-01-23T16:46:32.3265814Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 294F8B2E [DM.GatewayCore] Transfer service closed DM.EnterpriseGateway Error: 0 : 2017-01-23T16:46:32.3265814Z DM.EnterpriseGateway 00000000-0000-0000-0000-000000000000 00000000-0000-0000-0000-000000000000 0000 00000000-0000-0000-0000-000000000000 E2B513BD [DM.GatewayCore] Swallowing non-fatal exception encountered during attempt 2/2147483647 for startup of Transfer service: Microsoft.ServiceBus.AuthorizationFailedException: Generic: InvalidSignature: The token has an invalid signature. ---> Microsoft.ServiceBus.Messaging.Amqp.AmqpException: InvalidSignature: The token has an invalid signature. Server stack trace: Exception rethrown at [0]: at Microsoft.ServiceBus.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.ServiceBus.Messaging.Amqp.AmqpObject.OpenAsyncResult.End(IAsyncResult result) at Microsoft.ServiceBus.Messaging.Amqp.DuplexAmqpLink.OnOperationComplete(AmqpObject link, IAsyncResult result, Boolean isOpen) Exception rethrown at [1]: at Microsoft.ServiceBus.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.ServiceBus.Messaging.Amqp.AmqpObject.OpenAsyncResult.End(IAsyncResult result) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of inner exception stack trace --- Server stack trace: at Microsoft.ServiceBus.RelayedOnewayListener.RelayedOnewayAmqpListenerClient.AmqpRelayedConnection.Open(TimeSpan timeout) at Microsoft.ServiceBus.RelayedOnewayListener.RelayedOnewayAmqpListenerClient.GetOrCreateConnection(Uri via, TimeSpan timeout) at Microsoft.ServiceBus.RelayedOnewayTcpClient.EnsureConnected(TimeSpan timeout, Boolean isRetry) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at Microsoft.ServiceBus.Channels.RefcountedCommunicationObject.Open(TimeSpan timeout) at Microsoft.ServiceBus.RelayedOnewayChannelListener.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at Microsoft.ServiceBus.SocketConnectionTransportManager.OnOpen(TimeSpan timeout) at Microsoft.ServiceBus.Channels.TransportManager.Open(TimeSpan timeout, TransportChannelListener channelListener) at Microsoft.ServiceBus.Channels.TransportManagerContainer.Open(TimeSpan timeout, SelectTransportManagersCallback selectTransportManagerCallback) at Microsoft.ServiceBus.Channels.TransportManagerContainer.OpenOrCloseAsyncResult.OnScheduled() Exception rethrown at [0]: at Microsoft.ServiceBus.Common.AsyncResult.End[TAsyncResult](IAsyncResult result) at Microsoft.ServiceBus.Channels.TransportChannelListener.OnEndOpen(IAsyncResult result) at Microsoft.ServiceBus.Common.ChainedAsyncResult.Begin1Callback(IAsyncResult result) Exception rethrown at [1]: at System.Runtime.AsyncResult.End[TAsyncResult](IAsyncResult result) at System.ServiceModel.Channels.CommunicationObject.EndOpen(IAsyncResult result) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<ExecuteRunnerIterationAsync>d__12.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<StartRunnerAsync>d__e.MoveNext()Solved6.9KViews0likes3CommentsGetting Live data from MySQL
Hi , I have a MYSQL as Datasource from which I pull data created some custom calculated column and now implemented it using Power Bi visuals. Now I am facing issue in seeing the Live data. To see the real time data I need to go to Refresh button in reports and then the data gets updated. I checked in Settings there is a option to Schedule refresh but even that is disabled. I see there is some Gateway thing which needs to be established but I am not getting the right documentation for that. I would like to know how to configure Gateway, when it is a required, and what should I do to automatically refresh my dataset4.9KViews0likes7Comments
