ISSUE with connections, gateways and scheduling automatic refresh
Dear, I am making multiple reports in power BI using an Excel in the cloud. However at one point instead of having one connection, it made a connection to the cloud and some sort of gateway, even though I referred to the same excel in the same location. The issue with this is that it caused the option to schedule a refresh to dissappear. What happened and how can I solve it so it works as before. Secondly, I will have to transfer these power BI files and connections to another account, since I referred to the excel using the link to the cloud and the other account has access to the same cloud, will this go smoothly? Thank you! Kind Regards. Screenshots below!
Refresh multiple data sources from different VPN in a single dataset
Hello, We have one single report that has data imported from two different servers each one from different VPNs. We tried to create a gateway cluster and added gateways from the two VMs of each VPN. However when we are selecting both gateway for respective datasource we are facing connectivity issues from secondary gateway instance. Please let us know if there is any other workaround
Gateway Trouble (Using an Alias Server Name)
Evening For the past year in and half my organization has been creating Power BI reports connected to our Microsoft Great Plains server. Over the weekend, IT upgraded to a new Great Plains server. Prior to this upgrade, IT created an alias Great Plains server. The idea being that in the future we would not have to reconfigure our BI reports to a new server source. Testing the BI reports on Desktop worked as expected. With the launch of the new upgraded Great Plains server today, all of my BI reports connected to to the new alias Gateway no longer refresh upon request. However they all work on my desktop. IT is confirming the new alias Gateway (gateway has a status of 'running' w/ green checkmark) and I do not see any errors myself, yet all the timed refreshes are now failing. Some of the messages we are receiving incude: - Cancellation occurred when sending or receiving a request - The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. Perhaps the alias Gateway is not the way to go? Maybe I need to recommend my IT department to create a Gateway for the new server name? Any thoughts or ideas that I can try or pass along to my IT department would be appreciated. Thanks in advanceGateway Error
Hello, we have a recurrent trespassing problem of one report. There's scheduled refresh every day and stops sometimes with the following error: (translated with google from german) "Apparently an error occurred during the scheduled update because the local gateway was restarted during the update. For the next scheduled update, ensure that the data gateway is running continuously." We investigated the logs but cannot see any issues. When we start the refresh manually , there is no error. The Gateway Version number is 3000.27.30 (February 2020) Does someone has a tip / solution? Thank you in advanceGateway connection to Sharepoint Survey error
Hi All, I have a gateway setup to an "on premise" sharepoint site which has a survey list within. I have a dashboard that is connected successfully in PBI Desktop to the Survey and refreshes data fine. My issue is that the gateway connection is showing the error that it cant find various columns in the list. See photo attached. I cant seem to figure this out. My central IT help Desk sets up all our gateways so i cant get much info there.
Gateway problem
Hi, I have installed on-premise gateway in server and connect it to Power BI report 3 months ago. Schedulling for refresh data from oracle DataBase was working well for a month. From 2 months ago, however, the schedulling is not able to work and the gateway is not connected. The error message is showing that our data gateway is offline or couldn't be reached Even though the On-premise gate way is perfectly being turned in Server. For 2 months, I have been monitoring the probem this and turing on manually the gateway in server. ps. As soon as I connect with between On-premise gateway in server and Power BI report to use data on Schedule, It shows Successful connect. After 3 hours, or even 2 hours, the connection is died. Please, Let me know the solution.
Failed to create gateway
Hello Community, For the past 2 days, I have been trying to create a new On-premises data gateway. I used to be able to create and connect Gateways few weeks ago. Now for some reason, I am not longer able to. When I tried to create new Gateway I am getting this error: My account is part of Power BI Pro for Government subscription. Failed to create gateway. Please try again. Request error: Id: 'a29c6675-454a-4917-894e-905f3193662d', Status code: 'InternalServerError', Timestamp: '10/19/2019 22:44:48 +00:00', ErrorCode: 'UnknownError', Detail: '' at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<EnsureSuccessfulDMMSRequest>d__0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<CreateOrReplaceUnifiedGatewayAsync>d__2.MoveNext() I have tried 3 different computers and I am still getting the same error. uninstall\re-install doesn't help, I tried *On-premises data gateway *On-premises data gateway (personal mode) No of them work getting the same error. Thanks, CarlosIssue with Gateway with only one report
Hello everyone, Has anyone ever run into an issue where a specific Power BI pbix file seemed to have adverse affects on your on prem gateway? I had a specific report that was connecting to an AWS Redshift data source and every time I would refresh the report in app.powerbi, I would get an error message saying that the gateway ran into an issue and the gateway may have been restarting (common error it seems like). But it would only happen with that report. It also appeared, although I can't confirm, that the gateway was crashing when I would try to refresh this report and then would restore itself some time later. I ended up rebuilding it completely from scratch with a new pbix file. Additional details, all of our reports use AWS Redshift as a data source. They all connect to the same cluster.List of Users running query in Power BI Gateway
Hi is there a way to get the name of a user who is running query using Power BI gateway . I have a Oracle database setup for refresh through a Power BI Gateway . There are many users who run and refresh the query using gateway . When I see the database sessions , i can find the details of power BI gateway user details and not the exact Power BI users name who is requesting that refresh through gateway ? Is there a way to achieve it , or may be appending a user name as comments in the query generated so that we can get to know the exact user ID ?
