This article answers frequently asked questions about Mirroring Azure Database for PostgreSQL flexible server in Microsoft Fabric.
Features and capabilities
What authentication to the Azure Database for PostgreSQL flexible server is allowed?
Currently, for authentication to the source Azure Database for PostgreSQL flexible server, we support basic authentication with user name and password. Microsoft Entra ID users, and Service Principal will be supported soon.
Is there a staging or landing zone for Azure Database for PostgreSQL flexible server? If so, is it outside of OneLake?
A landing zone in OneLake stores both the snapshot and change data, to improve performance when converting files into delta tables.
How long does the initial replication take?
It depends on the size of the data that is being brought in.
How long does it take to replicate inserts/updates/deletes?
Near real-time latency.
Do you support replicating of views, partitioned or external tables?
No. Currently, only replicating regular tables are supported.
How do I manage connections?
Select the settings cog, then select on Manage connection and gateways. You can also delete existing connections from this page.
Can Power BI reports on mirrored data use direct lake mode?
Yes, since tables are all v-ordered delta tables.
Self-help for Mirroring Azure Database for PostgreSQL flexible server in Microsoft Fabric
How do I know Fabric is replicating data on my Azure Database for PostgreSQL flexible server?
If you're experiencing mirroring problems, perform the following server level checks using system catalog views and functions to validate configuration. Contact support if troubleshooting is required.
- Execute the following query to check if the changes properly flow:
select * from azure_cdc.tracked_publications;
For troubleshooting steps, see Troubleshoot Fabric mirrored databases from Azure Database for PostgreSQL flexible server.
How to enable System assigned managed identity (SAMI) on Azure Database for PostgreSQL flexible server?
With a single step in the Azure portal, you can enable System Assigned Managed Identity (SAMI) of your Azure Database for PostgreSQL flexible server.
What are the replication statuses?
Can Azure Database for PostgreSQL flexible server mirroring be accessed through the Power BI Gateway or behind a firewall?
Currently, access through the Power BI Gateway or behind a firewall is unsupported.
What steps does restarting the Mirroring include?
The data from source tables will be reinitialized. Each time you stop and start, the entire table is fetched again.
What happens if I remove a table from Mirroring?
The table is no longer replicated and its data is deleted from OneLake.
If I delete the Mirror, does it affect the source Azure Database for PostgreSQL flexible server?
No, we just remove the replication slot.
Can I mirror the same source database multiple times?
No, each Azure Database for PostgreSQL flexible server can only be mirrored once. You just need a single copy of the data in Fabric OneLake, which you can share with others.
Can I mirror only specific tables from my Azure Database for PostgreSQL flexible server databases?
Yes, specific tables can be selected during Mirroring configuration.
What happens to Mirroring during an HA failover for my Azure Database for PostgreSQL flexible server?
Mirroring is currently not supported for servers with HA enabled.
Security
Is data ever leaving the customers Fabric tenant?
No.
Is data staged outside of a customer environment?
No. Data isn't staged outside of customer environment, only in the customer's OneLake.
Cost Management
What are the costs associated with Mirroring?
There is no compute cost for mirroring data from the source to Fabric OneLake. The Mirroring storage cost is free up to a certain limit based on the purchased compute capacity SKU you provision. Learn more from the Mirroring section in Microsoft Fabric - Pricing.
What do we recommend a customer do to avoid or reduce Azure Database for PostgreSQL flexible server costs?
See Plan and manage costs for Azure Database for PostgreSQL flexible server. Consider using a dedicated, smaller Azure Database for PostgreSQL flexible server, based on requirements.
How are ingress fees handled?
Fabric doesn't charge for Ingress fees into OneLake for Mirroring.
How are egress fees handled?
If the Azure Database for PostgreSQL flexible server is located in a different region from your Fabric capacity, data egress will be charged. If in the same region, there is no data egress.
Licensing
What are licensing options for Fabric Mirroring?
A Power BI Premium, Fabric Capacity, or Trial Capacity is required. For more information on licensing, see Microsoft Fabric licenses.
Stop or pause Fabric Mirroring
What are the results of stopping Mirroring?
Replication stops in the source database, but a copy of the tables is kept in OneLake. Restarting the mirroring results in all data being replicated from the start.
What if I stop or pause my Fabric capacity?
The Fabric capacity needs to be active and running. A paused or deleted capacity will impact Mirroring and no data will be replicated.