native query, use of parameter and connect to oracle db

[akhaliq7]

When I try to connect to an oracle db using a parameter and I input a sql native query it returns an error 

we encountered an error while trying to connect. details

however when I leave the native query section blank then it returns a list of tables.

[Anonymous]

Hi  @akhaliq7 ,

Excuse me, Can you provide the error details and screenshots?

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[akhaliq7]

Hi below are the screenshots:

When I untick the setting on the last screenshot then it allows me to run the sql query with a parameter but is this the only way as does this not create security issues

[Anonymous · Accepted solution]

Hi  @akhaliq7 ,

According to the official documentation:

You can turn off the native database query security messages if the native database query is run in either Power BI Desktop or Excel. To turn off the security messages.

Import data from a database using native database query - Power Query | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[akhaliq7]

But it runs fine when I am not using a parameter is this a bug in the Power BI Software