March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello,
Ive recently installed an on-premise power bi gateway on one of our servers. I have installed it successfully and everything looks good on the server. When I log into the Power BI service I notice that it doesnt show up in my list of Managed Gateways.
What I've noticed so far is that the server account that I log into the server with doesnt have a office 365/Power BI license but when I run the installation for the gateway it prompts for a user to register the service with and I use my own account that does have a power bi pro license. My concern is even though Im giving it the account that I use for the power bi service to register the gateway (and it prompts and I sign in without issue), it is somehow using the default account im signed into the server because when it gets to the step below, it is showing the server account instead of the account that has the license.
Ive also uninstalled and reinstalled using the same process with no success. Any other ideas on how to switch the account its registered too on the installation?
Thank you!
Solved! Go to Solution.
I was able to resolve this. The account that I installed the power bi gateway with had to be a part of the administrators group on the server and be associated with a power bi license. Then I could log into the power bi service after setting up the gateway to see it show in My Gateways.
Anytime I was logged in with my other account doint he install that didnt have the power bi license, I wasnt able to run the install as other account with the license and associate it.
Seems to be confusing in that aspect. I wasnt able to use a different account when I registered the gateway, it kept using the account I was currently logged into the server with.
Thanks for you help!
I really don't follow the phrase "be associated with a power bi license".
The user I used to install the On-Premises Data Gateway is a member of the Administrators group, but that user is just a user on the server. It is not "associated" with a Microsoft account or any licensing of anything. It is just a stand-alone user on a Windows Server VM.
The On-Premises Data Gateway is working fine with Azure and Business Central, but does not appear when I connect to the Power BI Service.
Hi, @it_russ I have a problem which is similar to your's . So I had a gateway already installed on the server and I had done it with my work account which has license . But now when I try to sign in to On premises data gateway configurator , and try to sign in with the same account, I get this error:
The gateway is running fine and I can see the gateway in the managed gateways section as well. I even updated the gateway but it did not asked me to sign in. But the updation was also successfull. But as I can recall , it used to ask for sign in before installing a new update. Could you please help out.
It asks me to configure the gateway .
Hi @Anonymous
Can you check to make sure that the PBI Service is running?
Thank you for the response GilbertQ. If you mean this option during the installation, then it should be the correct type of gateway.
Also, when I export the logs and look at the properties of the gateway, it still shows my server account in the DisplayableId and not the account I used to register. I assume it should show my account that I registered the gateway with.
I've called the Getgateways in the Power BI REST API as well and it doesnt show there either - https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/getgateways
I was able to resolve this. The account that I installed the power bi gateway with had to be a part of the administrators group on the server and be associated with a power bi license. Then I could log into the power bi service after setting up the gateway to see it show in My Gateways.
Anytime I was logged in with my other account doint he install that didnt have the power bi license, I wasnt able to run the install as other account with the license and associate it.
Seems to be confusing in that aspect. I wasnt able to use a different account when I registered the gateway, it kept using the account I was currently logged into the server with.
Thanks for you help!
Literally fixed. MSFT support missed this detail during a support case I just closed. Thanks for your assist 🙂
Wow... Just wow. I was beating my skull against a wall, not able to figure out why my gateway wasn't showing up. Like you said, it's a weird quirk with the installer.
What didn't work:
I was logged-in to my server (where the gateway is) with an admin account because my standard account wasn't an admin and wasn't authorized for login. I installed the GW with my admin account (no Pro license) and configured it with the email address of my standard account (with a Pro license). Everything looked good, but the GW wasn't showing up in PBI Service.
What did work:
I added my standard account to the local administrators group. Did a "run as" to run the installer as my standard account (while logged-in to the server as the admin account), configured the GW for my standard account, and ...poof! Magic! GW immediately showed up in the PBI Service.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
39 | |
22 | |
21 | |
10 | |
10 |
User | Count |
---|---|
60 | |
56 | |
22 | |
14 | |
12 |