How using an excel variable in where statement to import data from an Oracle Database in Excel Power Query

Question

Hello,

I have a very large table in an Oracle database.
I want to limit the import into Excel Power Query by using the where statement in the sql-query used by the connection to the Oracle Database.
In the where statement I want to compare a field of a Database with an variable that comes from Excel and chosen by the user.
I found a little information on the web, but i don't succeed in creating the correct formula.
Can someone help me or tell me where i can find detail information about this feature ?

Thank in advance.

Answer 1

Hi @Marc Bergmans

See SQL Native query with parameter. It's based on SQL Server but the approach should be the same with Oracle

Answer 2

I found the solution in the answer.
It was the privacy setting that I had to turn to Ignore.