I'm using Tableau Prep and have been able to connect to my Oracle server without any problems. All tables load and can be filtered and cleaned without limitations. However, when I created a custom SQL query I get an error that Tableau can't connect to the datasource. All of the other full table pulls are running just fine, but the custom query can't connect. What am I doing wrong?
@Wyl Mc
Hi, would you be able to create a small custom sql, something like select * from y and test if the custom sql works? If it does not, what error do you receive? what is the custom sql you are trying?
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
