Forum Discussion

gbag3's avatar
gbag3
Frequent Visitor
9 years ago
Solved

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.

Thank you,

Garry

Need Help

8 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi gbag3

     

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

     

  • JohnLesher's avatar
    JohnLesher
    New Member
    8 years ago

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

     

    John Lesher

    • Bsacheri's avatar
      Bsacheri
      Advocate I
      8 years ago

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

      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago
        I'm not sure if there is a registry key setting
  • JohnLesher's avatar
    JohnLesher
    New Member
    8 years ago

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

     

    John Lesher

    • ALopezLago's avatar
      ALopezLago
      Microsoft Employee
      7 years ago

      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.