SAP BW Issue
I have an issue when try to refresh a Dashboard. In the web service the error is: If I try on teh desktop app, it works without problem. If I select "Refresh data" there is no issue, but if I try "Refresh Schema & data" the error is: How can I solve it? In order to mantain the Dashboard working on the Web service.
Personal Gateway for R script
Hi there, I have used an R script in my BI Dashboard, published it and set an auto refresh with a personal gateway. The personal gateway is on and ready to use, the auto refresh works with no error but the column that refrences the R code does not show the correct data. The column is meant to show Trues and falses but it only shows False. When I refresh in desktop it works perfectly and the column displays the correct info. I think I am missing something in the personal gateway or in the actual R code but I have read everything I can find on this and just can't seem to get it right. I am new to using R in BI so the whole process has been trial and error but it is just odd that it works in desktop but not service. The R code is used as a step in one of my tables in query editor, this is how it starts off: new_dataset <- dataset new_data <- data.frame(new_dataset) HS <- new_data$"US_HTS_Code__c" COO <- new_data$"Country_of_Origin2__c" new_data$ADDFlag1 <- Any guidance will be greatly appreciated, thanks so much!
On Premises Data Gateway (Personal Mode) Offline
Hi, I'm currently having issues with our Gateway showing as offline and i'm having trouble. The following error is being shown when trying to open it: When trying to sign we get the following error: Error generating an asymmetric key. Exception message: Key not valid for use in specified state. Key not valid for use in specified state. Server stack trace: at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter) at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.PowerBI.DataMovement.Pipeline.ConfigurationContracts.IGatewayConfigurationService.GenerateAsymmetricKey() at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GenerateAsymmetricKey()An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is: System.Security.Cryptography.CryptographicException: Key not valid for use in specified state. at System.Security.Cryptography.Utils.CreateProvHandle(CspParameters parameters, Boolean randomKeyContainer) at System.Security.Cryptography.Utils.GetKeyPairHelper(CspAlgorithmType keyType, CspParameters parameters, Boolean randomKeyContainer, Int32 dwKeySize, SafeProvHandle& safeProvHandle, SafeKeyHandle& safeKeyHandle) at System.Security.Cryptography.RSACryptoServiceProvider.GetKeyPair() at System.Security.Cryptography.RSACryptoServiceProvider..ctor(Int32 dwKeySize, CspParameters parameters, Boolean useDefaultKeySize) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayServiceHost.AsymmetricKeyGenerator.ProduceAsymmetricKey(String containerName, Boolean cleanUpOldKeys, Int32 rsaKeySize) at Microsoft.PowerBI.DataMovement.Pipeline.GatewayPipelineTelemetry.PipelineTelemetryService.ExecuteInActivity[T](PipelineActivityType pipelineActivityType, Func`1 action) at SyncInvokeGenerateAsymmetricKey(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet) I've tried reinstalling and restarting, which tells us the key is invalid but other than that we have no idea what could be causing this issue. Any ideas as to what the issue could be, or is there some update which has gone through this weekend I'm unaware of? Thanks.Personal gateway
I try to install personal gateway in my dataset on the powerBI.com. It showed the error that I already have this personal gateway in my computer, I need to un-install to re-install this one. I went to the manage gateway and try to remove the personal gateway and there is the error that I can't remove it.Problems with Personal Gateway
Good afternoon friends! I am trying to teach myself Power BI and have had great success UNTIL I had to install a personal gateway. It appears that I have the latest version (June 2019 release 2), and the installation says that my gateway is all set up. I sign in and get the message "The gateway is online and ready to be used". However, when I publish my report from Power BI Desktop and try to open it in Power BI, it tells me "there is no gateway to access the data source Oracle". If I go into Settings/Datasets and highlight the one I am using, my gateway does not show up under "Gateway connection" (and basically, go to Manage Gateways and set one up). I'm at a loss, so anything that anyone can tell me would be a great help! Thank you!
