Forum Discussion

Joel Harmon's avatar
Joel Harmon
Copper Contributor
Feb 20, 2018

Excel 365 Native Database Query Warnings

I have searched far and wide and there is currently no one on the entire Internet that has answered this question yet:   In Excel 365, how do I get to Options-->Security in order to suppress the ...
excel
Rnishat0786's avatar
Rnishat0786
Iron Contributor
Aug 23, 2018

Hi Joel

 

Kindly follow the steps given below to suppress the warning that you are getting "Native Database Query".

 

Open Excel - Click on Data - Get Data - Query Options. Once you click Query Options you will get another Pop up Window - Select Security - You will get Native Database Queries - uncheck "Require user approval for new database queries" & click on Ok.

 

You may refer to the screen shots below - 

 

Thanks

 

Robin Nishad

Technical Consultant

PBellerose's avatar
PBellerose
Copper Contributor
Jan 22, 2020

Rnishat0786 : Since this is a Global setting, I'm guessing this only applies to local machine and it should be set on all machines that will open the workbook?

 

If so, anyone know what is the registry key and what it should look like?

 

Thanks!

  • HansWS's avatar
    HansWS
    Copper Contributor
    Apr 28, 2020

    PBellerose 

    This page has an answer about RegKeys.

    https://stackoverflow.com/questions/37186442/always-allow-native-db-queries

     

    Thanks for this simple set of screen shots!  Spent an hour looking for this.

    • PBellerose's avatar
      PBellerose
      Copper Contributor
      Nov 26, 2020
      Hi HAnsWS,

      We have moved our native Queries on Power BI Service so we won't be needing this setting anymore.
      But thanks for the link, I'm sure it will be helpful to others

Resources