Use custom query as table from Oracle database

[ingrid]

I'm trying to use a custom sql as table. Adding a view in the database is not possible. 

I've tried to add the sql (SELECT * FROM FEITBESCHIKTEVOORZIENING) in the advanced options field but then I get  an ORA00-942 error (table or view does not exist). The table does exist because I've added it in the model.

The source from the table is:

---------------------------

let
Source = Oracle.Database("mdkpwmon", [HierarchicalNavigation=true]),
WMONEDPBI = Source{[Schema="WMONEDPBI"]}[Data],
FEITBESCHIKTEVOORZIENING = WMONEDPBI{[Name="FEITBESCHIKTEVOORZIENING"]}[Data]
in
#"FEITBESCHIKTEVOORZIENING"

---------------------------

My querstion is how do I have to change this so that I can use the custom query?

I've tried this (and some other variables for sql, like query):

---------------------------

let
Source = Oracle.Database("mdkpwmon", [HierarchicalNavigation=true]),
WMONEDPBI = Source{[Schema="WMONEDPBI"]}[Data],
FEITBESCHIKTEVOORZIENING = WMONEDPBI{[sql="SELECT * FROM EITBESCHIKTEVOORZIENING"]}[Data]
in
#"FEITBESCHIKTEVOORZIENING"

---------------------------

but I keep getting an error: the key didn't match any rows in the table.

[Greg_Deckler]

Is it
EITBESCHIKTEVOORZIENING

or is it
FEITBESCHIKTEVOORZIENING

[ingrid]

It is FEITBESCHIKTEVOORZIENING. But the typo is not the problem unfortunatly.