Power BI Gateway Configuration

[u750430]

Our Power BI Gateway Configuration was accidently deleted, so we lost all our working connections.  We followed the steps to update the Power BI Gateway program, create a new Power BI Gateway Configuration and restored the connection.

What I want to know, is there a way to make a Backup of the Power BI Gateway Configuration and then restore the Backup should this ever happen again.  I understand that a new Backup would be taken at least weekly so that we would have most of the connections.

[R1k91]

For our customer we apply a procedure made of Powershell scripts that backup the configuration files of the gateway and the installer before upgrading in this way you can restore it in case of disaster. Obviously recovery key is needed and you have to take care of it.

[v-kpoloju-msft]

Hi @u750430,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @tayloramy, @cengizhanarslan, @grazitti_sapnam, @rohit1991,   for those inputs on this thread.

Has your issue been resolved? If the response provided by the community member @tayloramy, @cengizhanarslan, @grazitti_sapnam, @rohit1991,  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @u750430,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[tayloramy]

Hi @u750430, 

As others have mentioned, a backup is not possible. 

I recommend posting an idea here: Fabric Ideas - Microsoft Fabric Community

If it gains traction, maybe the product team will develop it. 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[cengizhanarslan]

When a gateway configuration is deleted, all connections must be recreated manually. Microsoft does not provide an export/backup file for gateway settings.

[grazitti_sapna]

Hi @u750430 ,
This is a very common concern, and unfortunately the answer is partly yes and partly no.

What you CAN back up

1. Gateway Recovery Key 

This is the only supported backup mechanism.

When the gateway is installed, you create a Recovery Key.

 If you still have this key:

• You can restore the gateway on a new machine

• All registered data sources remain available

• No need to re-enter credentials

If you lose the recovery key:

• There is no way to recover connections

Action now

• Store the recovery key securely:

  • Password manager

  • Azure Key Vault

  • Secure internal documentation

You cannot backup data source connection and credentials 

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!

[rohit1991]

Hii @u750430 

Power BI Gateway does not support backing up and restoring gateway configurations or data source connections. There is no export/import or scheduled backup feature available. The only supported recovery option is using the same recovery key to migrate or restore the gateway to an existing cluster. If the gateway is deleted without the recovery key, all data sources must be recreated manually. To avoid this risk, Microsoft recommends using a gateway cluster (multiple nodes) and securely storing the recovery key, as VM or file backups do not restore gateway connections.