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

Marc Bergmans 101 Reputation points
2021-02-17T05:49:35.48+00:00

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,003 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Marc Bergmans 101 Reputation points
    2021-02-18T16:45:00.667+00:00

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