If you are using Azure SQL DB Premium tier or Azure SQL Managed Instance (Business Critical Tier), you will benefit from using the read-only replicate provided to lighten the workload on your read-write database and avoid unwanted locks. This article will provide guidance to explain how to do this on Power BI and Azure Analysis Services (for Power Query type…
