Forum Discussion

smedarametla's avatar
smedarametla
Frequent Visitor
2 years ago

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 Synonyms. Please help. Thanks.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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 

    • smedarametla's avatar
      smedarametla
      Frequent Visitor
      2 years ago

      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.