Trouble connecting to SQL 2014 Database using Power Query RRS feed

  • Question

  • I am trying to connect to a SQL 2014 Database using Power Query.  My connection string requires that I set the "Application Intent" setting to a value of "readonly", The connection parameter is required by SQL 2014 because of the failover cluster configuration.   

    I have successfully been able to connect via PowerPivot with the following connection string:

    Provider=SQLNCLI11;Data Source=<Server>;Persist Security Info=False;Integrated Security=SSPI;Initial Catalog=<DB>;Application Intent=readonly

    I cannot seem to find the correct syntax to connect via SQL 2014.  This is the syntax that I have been attempting: 

    Sql.Database("<Server>", "<DB>",[Application Intent=readonly])

    Is this currently supported?

    Thanks, Barbara

    Tuesday, November 11, 2014 8:21 PM


  • It's not yet, I'm afraid, but it's something we're aware of and have vague plans to address :/.
    Tuesday, November 11, 2014 9:44 PM