question

Brian avatar image
Brian asked

PowerQuery connection string , using readonly intent

Looking to use ApplicationIntent=Readonly within Powerquery. Looks like the only way to do it is to setup a ODBC connection. Does anyone have any other Ideas? Thanks
sql-server-2012excelavailability-groupsconnection-string
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
David Wimbush avatar image
David Wimbush answered
You don't give too much detail but does this help?: http://blogs.msdn.com/b/alwaysonpro/archive/2013/08/02/connect-to-sql-server-using-application-intent-read-only.aspx
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Brian avatar image Brian commented ·
Thanks for looking at it. The issue is power query appears limited in what can be entered into the connection for SQL server, ie just server and database, you cannot add ApplicationIntent to the connection String. The only way that i see it being possible is setting up a OBDC connection which is not something i wanted to do.Just looking for other ideas.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.