See SQL Native query with parameter. It's based on SQL Server but the approach should be the same with Oracle
How using an excel variable in where statement to import data from an Oracle Database in Excel Power Query
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.
1 additional answer
Sort by: Most helpful
-
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.