topic ERROR MIRRORING IN FABRIC - AZURE SQL DATA BASE in Data Warehouse

ERROR MIRRORING IN FABRIC - AZURE SQL DATA BASE

jmalcober — Tue, 28 May 2024 21:15:26 GMT

Hello Fabric Community,

I am currently facing an issue while attempting to create a mirrored Azure SQL database in Fabric. I have successfully created a managed identity in Azure, named sqlmanagedidentity, and assigned it owner permissions on a database called replica in Azure SQL.

However, when I try to finalize the mirroring process in Fabric, I encounter the following error message:

Error: PowerBI user with prefix XXXX not found

Here is a screenshot of the error:

Also I attached the configuration & permissions of managed identity

Any help will be appreciated, looks like i'm stuck in the last step.

Thnks in advance

Re: ERROR MIRRORING IN FABRIC - AZURE SQL DATA BASE

Anonymous — Wed, 29 May 2024 09:42:33 GMT

Hi jmalcober
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks

Re: ERROR MIRRORING IN FABRIC - AZURE SQL DATA BASE

Anonymous — Mon, 03 Jun 2024 15:58:35 GMT

Hi jmalcober
Apologies for the delay in response. Are you still facing this issue?
Please let me know.
Thanks

Re: ERROR MIRRORING IN FABRIC - AZURE SQL DATA BASE

Anonymous — Tue, 04 Jun 2024 17:20:54 GMT

Hi jmalcober
We haven’t heard from you on the last response and was just checking back to see if you can provide the details asked above.
Thanks

Re: ERROR MIRRORING IN FABRIC - AZURE SQL DATA BASE

jmalcober — Tue, 04 Jun 2024 18:09:10 GMT

Hi,

I solved the problem, moving the azure database to the same zone of our PowerBI teenat.

We had the database in the same teenat but diferent azure zones. PowerBI in NorthEurope and Azure SQL in West Europe.

Moving Azure SQL to North Europe solved the problem

Thnks