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 characters needed characters left characters exceeded

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

1 Answer

· Write an Answer
David Wimbush avatar image
David Wimbush answered
1 comment
10 |1200 characters needed characters left characters exceeded

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

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.