Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Use custom query as table from Oracle database

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.

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

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