data gateway
25 TopicsHow to connect my on premises data gateway in personal mode
Hello everyone, I am new to Power BI and trying to connect my on premises data gateway in personal mode with my dataset. My data is saved on a mariadb data base. I am following this tutorial: Power BI Data Gateway in Personal Mode: Installation and Usage Tips Until 5:27 I could follow all steps By 6:20 the screen of the tutorial and mine is different: My screen: Does anyone has an idea what I have to do? Do I need to change any settings at my on premises data gateway in personal mode?Solved3.4KViews0likes4CommentsNavision 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.4KViews0likes3CommentsGateway 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? ThanksSolved1KViews0likes2CommentsGateway 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?654Views0likes2CommentsGateway 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?495Views0likes1CommentData 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. .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?655Views0likes1CommentGateway Error
Hi All, I have a report with source as SQL. I have deployed that report in the service. To schedule the refresh for that report, it is required to install and configure Gateway. So, i tried to install the Personal Gateway first, it got installed, but unable to configure it with my account. Similalry i have tried Standard gateway also, (uninstalled the personal and installed the Standard) even then getting the same issue. Below is the error screenshot of it. The above mentioned is everything performed in one of our Servers. The same process i have done in my base machine, and it is working fine. Only issue is in the Server. Please help or provide any solution for this. Thanks, Sudharshan.6KViews0likes1CommentData gateway - Should I Install and where to install?
Good day everyone! A rookie question. My objective is to distribute completed power BI report to users through web interface. I have subscribed with Power BI Pro version. I used Power BI desktop to make the report and the deliverable is just one .pbix file that connecting to SQL Server 2012 for data source. I build the same report with both way of querying SQL server (Import and direct query). And I uploaded both reports to my workspace. Both report got error when I tried to open it in my workspace: For the one database connection is using "Import", it can display the dashboard like barchart things. But if I click on the dataset "Refresh" button it said "Something went wrong - Scheduled refresh has been disabled. Please try again later or contact support. If you contact support, please provide these details." "Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh. Cluster URIWABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net Activity ID0cb0327e-9259-4980-bcc2-68dc7a1daca7 Request IDac1a381a-5d11-939c-f94f-37e5722ffae2 Time2023-01-05 08:37:13Z" For the one database connection is using "Direct Query", it cannot display the dashboard (as no data inside). When I first click on the report it already shows a red ribbon at the top of the screen "There is no gateway to access the data source [myDBName]." as well as "Data source unreachable - There is no gateway to access the data source en02live . Verify the gateway connection configuration on the dataset settings page and make sure all required data sources are added to the selected data gateway." The current infra setup here is : - SQL Server 2012 (the data source and I use internal IP address to access to it) - My laptop with SSMS (I use this to query and create a temp table. And this is where the Power BI dashboard load data from) - My laptop with PowerBIDesktop installed (I use this to develop the report) - My workspace (that is my login under my 365 account which subscribed as Pro user) So, questions are: It seems my next step I need a "data gateway" in place. However I have no idea where should I put that gateway in? Shall I install the on premise gateway in SQL server? The gateway setup: it seems allows me to login using my 365 account. But it does not have setup to connect to my SQL server by putting in credential and ip/host name of my data source (i.e., SQL Server). How that data gateway works? If I need to distribute the report to users, do I need to get extra Pro license for them? We have at most 5 to 6 users only that need to access Power BI report. Thanks a million for all advices or sharing of link that help me to make this come true.Solved4.1KViews0likes1Comment