excelexcel-2013powerquery

Always Allow Native DB Queries

In Excel 2013 how can I change options (or is it possible) to always allow native DB Queries?

Can someone walk me through how to set this up?

Solution

  • When in Excel
    1) Click Power Query from the "Ribbon" across the top
    2) Choose Options
    3) From the Options Window that loads select Security from the left
    4) Untick the box that says "Require user approval for new native database queries"
    5) Click OK