data gateway
18 TopicsNavision application slow for users at the same time everyday
Hey Experts, Afternoon! I have a PBI gateway connection to Navision, at the same time everyday it becomes slow for users because of Power BI. I've also already tried spacing the refresh schedules out. I can see the CPU & Memory usage and it becomes extremely high, how would I go about fixing this or has anyone had this issue before? Many Thanks, TaylorSolved1.2KViews0likes2CommentsCan't refresh reports. On-Premise Gateway / DNS Problem?
Hello, I have a problem with data refresh through an On-Premise Gateway. Both planned and manual refresh are causing issues. All reports are affected. It usually takes too long to refresh (over 10 min.) and then this error code is shown. There were times when I could refresh my reports manually today, but the issue kept showing later again. I tested reports with data from different SQ servers. Then I created a new gateway on my pc and turned off the gateway we have in our virtual power bi server. The issue remained. I started to track the data traffic and apparently the gateway is sending data to these Microsoft domains: g0-prod-fra21-001-sb.servicebus.windows.net g1 g2 ... g15-prod-fra21-001-sb.servicebus.windows.net Some of these domains return a local IP address, tested with different public DNS. Currently, g8 is returning 10.218.0.23, g9 returns 10.218.0.24, g15 returns 10.218.0.30. Others seem to have a public IP, like g0 with 51.116.232.39 for example, and the traffic goes through. I'm assuming this might be the reason sometimes the refresh works and sometimes it doesn't. Is someone else having a similar problem?Solved1.5KViews0likes3CommentsGateway to work with Power BI Report Server
Hi, I am aware of the Power BI Gateway available for accessing an on-prem DB when you are using the Power BI Service (SaaS). However, we have a need where the Power BI Report Server is hosted in a different part of a network than the database, not directly accessible. Is there an option in the Gateway to use with a Power BI server, instead of the Power BI Service? Or any other alternate solution you could suggest? ThanksSolved1.1KViews0likes2CommentsGateway com banco de dados
Olá, na empresa em qual trabalho estamos como seguinte problema: O gateway está online e aparenta estar funcionando, porém quando vamos fazer a ligação, está dizendo que "O gateway ou origens de dados não estão acessíveis", abro o power bi desktop e consigo atualizar normalmente, mas no fabric acontece isso, o que posso fazer?670Views0likes2CommentsGateway with database
Hello, at the company where I work, we are facing the following issue: The gateway is online and seems to be functioning, but when we try to make the connection, it says "The gateway or data sources are not accessible." I can open Power BI Desktop and update normally, but this issue occurs in the Power BI service. What can I do?507Views0likes1CommentData source unreachable
I have created a PBI report in the desktop version using excel files from OneDrive and dataset from Azure. In the desktop version all works well, but when I publish it I get an error. The "File" hyperlink just sends me back to the main page. And according to my IT team, there's no Gateway for Azure report. I have tried to publish a report with just excel files from OD or just some tables and measures from Azure - it works. But when I publish the combination of these two, the visuals don't work. I have checked other threads here but nothing seems to help. .1.1KViews0likes3CommentsReport Server Licence in a Production environment
Hey, I'm currently new to the BI community and am working on implementing a PBI report server solution for an organization. My question is pertaining to licences. We will be installing PBI RS to a VM in Production environment, since that's where the DB access is. However, we (obviously) do not have the permission to open Internet accesses in this environment due to security and practical reasons, which might make it difficult for me to log in to my MS ID. My question is: is it possible for me to install PBI RS on my physical machine (to log in) and open a gateway which allows me to work on the VM so that I can access the data?666Views0likes1CommentConfigure Data Gateway to Hosted Environment
Has anyone setup a data gateway with a hosted environment with an oracle database? Were their any issues that you encounted during the setup? Afterwards were you successfully able to import the data into a dataset and onto a dashboard, etc.?Solved818Views0likes2CommentsMySQL Connection
After gaining access to my newly formatted desktop PC, I downloaded again Power BI, MySQL connector 8.0.16, and an on-premise gateway. Upon connecting to my data hub, I encounter this Failed to update data source credentials: MySQL: Unable to connect to any of the specified MySQL hosts. Activity ID: 3263caea-14ad-48b2-95ea-2fc5657559b0 Request ID: 86eebf39-3655-dddd-8e23-e339c30d8e01 Status code: 400 Time: Thu Sep 29 2022 16:22:08 GMT+0300 (Eastern European Summer Time) Service version: 13.0.19134.41 Client version: 2209.3.13354-train Cluster URI: https://wabi-west-europe-redirect.analysis.windows.net/ May you advise?Solved2.2KViews0likes3CommentsCan one gateway be used by two different workspaces?
Hello, I set up a premium workspace and on-premises data gateway for my team to use for data refreshes. The gateway is located on a windows virtual server. Another team with a separate premium workspace was asking if they could use our gateway to refresh their datasets. Is that possible?Solved4KViews0likes2Comments