Forum Discussion
Unable to read Synonyms in Oracle Connection
Hi, I am trying to establish connection in Power BI to Oracle ADW. I could see the schema name but nothing under it. That schema only contains SYNONYMS. Hence wondering if Power Bi can read/identify...
Hi smedarametla ,
Try to use below code to confirm whether you can see query result:
SELECT * FROM YOUR_SYNONYM_NAME;
Also, is it possible to provide some screenshot information and describe it so that I can do further troubleshooting.
Best regards,
Adamk Kong
I am able to see the data in synonyms only if I query like you suggested. But not able to see the list of synonyms when I expand the schema.