Power BI oracle Database do not display data

[Anonymous]

Hi Guys,

We are unable to load data from oracle database.

Before selecting any data to display; we would use below command

EXEC VPD.SET_USER('xyz.ADMIN');

Followed by  select command

Select * from Owner.Xyz where RowNum<=5;

As we provide above statemt for each query; It error out with Invalid token as we are using ";"

How can i make sure DAX allow me to use both command in single Query and yet display data?

Our Oracle team is not intrested to create logon tigger.

Regards,

Navin

[msuravarjjala]

hi Naveen,

How did you resolve the issue with Power BI and Oracle VPD? I have a similar requirement. Can you help?

[Anonymous · Accepted solution]

Trigger sample

create or replace TRIGGER loginname.VPD_Logon
  AFTER LOGON
  ON loginname.SCHEMA
BEGIN
  Vpd.set_user('DBA.ADMIN');
END;