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
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