Forum Discussion
PowerBI Connect to ReadOnly Replica of Azure SQL Database: ApplicationIntent=ReadOnly;
Hi,
I came across this article: https://community.fabric.microsoft.com/t5/Desktop/PowerBI-connect-to-readonly-replica-of-Azure-sql-database/td-p/1556948
Does the latest PowerBI now support this?
Thanks.
Hi SachinC ,
According to your description, Power Query does not support the ApplicationIntent parameter at this time. If you want to connect to a read-only copy of Azure SQL database, you can check out these documents, they mention that you can do so by enabling the failover feature in the advanced settings under the connector.Sql.Database - PowerQuery M | Microsoft Learn
Refreshing data in Power BI from SQL Server Read-o... - Microsoft Fabric CommunityConnect Power BI Report to Read Only Replica - Procore
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
3 Replies
Hi SachinC ,
According to your description, Power Query does not support the ApplicationIntent parameter at this time. If you want to connect to a read-only copy of Azure SQL database, you can check out these documents, they mention that you can do so by enabling the failover feature in the advanced settings under the connector.Sql.Database - PowerQuery M | Microsoft Learn
Refreshing data in Power BI from SQL Server Read-o... - Microsoft Fabric CommunityConnect Power BI Report to Read Only Replica - Procore
Best regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi there,
I am connecting to Azure SQL and I've ticked the option in Data Source Settings: Enable SQL Server Failover Support. However I am lost where to add: ApplicationIntent=ReadOnly. Am I correct in saying that it is still not supported? I am using 2.131.1203.0 64-bit (July 2024) which is the latest version as of 31/07/2024.
Please can you let me know as I have been looking and rummaging for a while.
Thank you.
Thanks for your help on this Albert,
The links you provided were very useful!
