Forum Discussion
Power BI + Gateway
Hi All,
I have been asked by user to setup Gateway for his Power BI. I have absolute zero knowledge so would appreciate any help on setting this up.
So far i have installed On-premises data gateway on a Server and signed in with my email address. He has got Power BI on his laptop installed. How do i get Power BI to comunicate with Gateway?
Many thanks
Milan
15 Replies
Hello Anonymous ,
It is best to have a good understanding of PowerBI Gateway and how it communicates with PowerBI.
In simple terms:
The gateway is required whenever Power BI must access data that isn't accessible directly over the Internet (e.g. Cloud). It can be installed on a server on-premises, or VM-hosted Infrastructure-as-a-Service (IaaS).
The following link provides step by step information on how to set up a gateway:
https://www.sqlshack.com/setting-up-power-bi-data-gateway/
Anonymous If it is running and connected, then Power BI should already know about it. You can go to the gear icon in the Service and then Manage Gateways. It should show up. Then you just have to give the user permissions to use it and configure the data sources.
Does the user have a PowerBI license (PowerBI Pro or PowerBI Premium)?
Also from your images the gateways that you see are the ones that were set up under your account.
Does the user want to access/modify a gateway that you created with your account?
You need to share the gateway with the person (Administrators TAB)
Hey Anonymous,
To themistoklis question. Can you explain if the user is trying to access the Gateway itself from the service or is the user trying to publish a report and is having issues where he cannot see the Gateway (for instance cannot schedule a refresh)?
If you added the user as an Admin to the gateway from the Admin menu on the service then he should be able to see it. If that's what you're trying to accomplish then when he clicks the settings menu does he see Manage Gateways or is that not shown?
I'm kinda wondering if what your user is looking for is for you to setup the data sources which need to be accessed through the gateway? If so then you'll need to click the Add Data Source button in the top left corner of Manage Gateways.
Then you'll need to add the user to the data source.
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.I am the user trying to access the Gateway.
The situation is the following:
We need to run multiple refreshes during a day on our datasets for our reports.
Various people in the organisation have access o these Reports to run a refresh.
Currently the data is being refreshed via a "Personal Gateway".
This is an issue when my PC is offline or when I am out on a business trip and not connected to our intranet.
I would like to have multiple accounts be able to refresh the said dataset via the "On Site Gateway".
Hey STGMD,
Did Anonymous add your data source to the gateway with credentials then add you as a user? If so what happens when you go to your data source on the service then to the Gateways. Do you see the gateway?
Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.
