Issues with Data Source Connection After Moving Gateway to Server

[Anonymous]

Hello Power BI Community,

I'm facing a challenge after transitioning our Power BI gateway from a personal computer (in personal mode) to a server, and I'm seeking some guidance to resolve it.

Background:

• The gateway was initially operating on my local PC using personal mode, connected to Power BI reports via an ODBC connection, which worked without issues.
• Recently, we migrated the gateway to a server setup. After logging into my Power BI account on the server, the Power BI online interface shows the new device with the gateway status as "online."

Problem:

• Following the migration, our existing data source connections ceased to function.
• When trying to establish a new connection, no options appear in the gateway dropdown menu.

No option available here

Questions:

1. Are there specific configuration steps that might have been overlooked during the migration of the gateway to the server?
2. Is it necessary for the Microsoft account used on the server to match the one associated with the Power BI service? Currently, these accounts differ.
3. Could there be server settings or permissions adjustments required to restore the connection capabilities of the gateway?
4. Does Power BI need to be installed on the server itself, or is it sufficient to have the gateway installed?
5. Is it necessary to refresh and re-upload a report on the server to re-establish a new connection?

I would appreciate any insights or suggestions you might have as I work through resolving this issue. Thank you very much for your assistance!

[Wikkleyn_81]

Hi @Anonymous Did you install teh Personal or Enterprise gateway on the server? If I look at the screenshot, it is a Personal gateway. Please install the Enterprise gateway and recreate the ODBC connection.

[Anonymous · Accepted solution]

Hey! Thank you for your posting, it was indeed the the Personal Gateway. But that was not the matter. It was indeed needed to download PowerBI Desktop on the server and upload a report. At least, after that it worked.

[SaiTejaTalasila]

Hi @Anonymous ,

You can restart your gateway and check.If still it's not working then you can check ODBC configuration and you can test it on your gateway machine and see whether it is successful or not.

Thanks,

Sai Teja 

[Anonymous]

Hey Sai,

Thank you for your response! I restarted the Gateway and tested the ODBC connection on the gateway machine, but unfortunately, it still doesn’t seem to work.

I'm puzzled why the gateway is recognized in one tab but can’t be selected when trying to establish a new connection. As far as I understand, this should not be affected by any existing connection settings, right?

Thank you very much for your help!

[SaiTejaTalasila]

Hi @Anonymous ,

Is that gateway showing under on-premises data gateways.Check with both the accounts you have.I suspect -May be you have created gateway with one account and you are using other account with service.This other account don't have access to the gateway so, it's not showing up.

There might be an issue the configuration too, you refer this-https://community.fabric.microsoft.com/t5/Service/Gateway-is-not-detected-by-Power-BI-service/m-p/1468622

Thanks,

Sai Teja