cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gbag3
Frequent Visitor

Suppress Native Database Query warning

 

 

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.

Query.PNG

Thank you,

Garry

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @gbag3

 

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

 

Email Pic.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

8 REPLIES 8
JohnLesher
New Member

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

 

John Lesher

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

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

 

John Lesher

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

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

GilbertQ
Super User
Super User

Hi @gbag3

 

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

 

Email Pic.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

gbag3
Frequent Visitor

Thank you @GilbertQ ! It worked.

 

Garry

Awesome




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors