Suppress Native Database Query warning

[gbag3]

Is there anyway I can suppress below's warning from Power BI?  I have a query that connects to an Oracle database and every time I open Power BI, this warning pops up.  Right now, it is only an eye sore since all I have to do is select Run to suppress the warning.

Thank you,

Garry

[JohnLesher]

Can we set this value using a registry entry?  If so, where is the registry key located?

John Lesher

[ALopezLago]

Creating a DWORD value with the name DisableNativeDbQueryPrompt and setting the value to 1 will disable native query prompts. The registry path to create this value is in one of the following:

• 32-bit (on a 64-bit system): HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft Power BI Desktop
• 64-bit (or 32-bit on a 32-bit system): HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft Power BI Desktop

Thanks.

[JohnLesher]

Can we set this value using a registry entry?  If so, where is the registry key located?

John Lesher

[Bsacheri]

Good question.   How can we address this for our users?   

[GilbertQ]

I'm not sure if there is a registry key setting

[GilbertQ · Accepted solution]

Hi @gbag3

You can find it in Options and then disable it as shown below.

[gbag3]

Thank you @GilbertQ ! It worked.

Garry

[GilbertQ]

Awesome