Forum Discussion
Connect to a synonym table in an Oracle database?
I am sure the answer is that this is not possible but here goes. The data I want to use is set up as a synonym table instead of a normal table by our Oracel DBAs so it is not listed in the Navigator screen when I connect to the Oracle database in PBI Desktop.
In Crystal Reports, I had the same problem but you can go into the Database tab in Options and check Synonyms to have the Synonym tables be listed in the Database Expert screen for use in a report.
Is there perhaps an obscure setting in PBI that would do the same thing?
Hi MJMcbride,
It seems that this is not supported currently, you could vote on Connect to Oracle Views and Synonyms. Or you could try to use ODBC connection to see whether it works or not.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
daxCommunity Support
Hi MJMcbride,
It seems that this is not supported currently, you could vote on Connect to Oracle Views and Synonyms. Or you could try to use ODBC connection to see whether it works or not.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.