Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
We want to create Power BI data connection in our on premise gateway server to point to the secondary node of SQL server instead of the primary. But currently there is no way we can put a parameter ApplicationIntent to ReadOnly for same. This feature should be available
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is there a reason that your PowerBI cannot point directly to the Analytics endpoint? What is the use case for pointing to the SQL database instead of the analytics endpoint?