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!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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?