Token comma expected and connection to Oracle

[jgelderblom]

Hi,

I'm trying to connect to a table in my TOOLKIT enviornment, which a specific WAVE and Oracle Target Enviornment (UAT). When I'm trying to load the table into PowerBI the error: Token Comma expected. 

Does anybody know how to solve this problem? When I leave the query out, the table is just empty.

let
Query= BEGIN SOURCE.SET_CONTEXT_API.SET_CONTEXT[(WAVE, ALL)] END;
SELECT TARGET.SET_TARGET_ENV(UAT)
FROM DUAL; Bron = Oracle.Database("osl2286.dnvgl.com:1521/TOOLKIT", [HierarchicalNavigation=true]),
SOURCE = Bron{[Schema="SOURCE"]}[Data],
ABSENCE_BALANCES1 = SOURCE{[Name="ABSENCE_BALANCES"]}[Data]
in
ABSENCE_BALANCES1

[v-haibl-msft]

@jgelderblom

How about the result if you remove 'Query= BEGIN SOURCE.SET_CONTEXT_API.SET_CONTEXT[(WAVE, ALL)] END; SELECT TARGET.SET_TARGET_ENV(UAT) FROM DUAL; '?

Best Regards,
Herbert

[jgelderblom]

 Hi Herbert,

Then I just get an empty table, because of the fact that de source and target enviornment hasn't been set. 

Regards,

Jeroen