Table doesn't Exist

[damiancds]

I'm trying to add an Oracle query data source. I tried adding a few tables together with unions but it kept stating: "Oracle: ORA-00942: table or view does not exist"

So, i thought it was the unions, so i removed them and added each table separatelty, until i got to the last table. It was giving the same error. Weird thing is, I can query it and pull anything I need from it in Toad data point, so I know there's nothing misspelled.

What am I missing? could there be a possible restriction on pulling certain tables. For more information this is an "old historical version" of the other two tables that i was able to add. (IE, we have a current table (3 months to current date), historical (6 - 3 months), old historical (all data - 6 months old). But I'm not sure if that has anything to do with it.

[v-easonf-msft]

Hi, @damiancds 

Could you please tell me whether your problem has been solved?
If yes, you could accept the helpful answer as solution. You also could share your own solution here. For now, there is no content of description in the thread. If you still need help, please share more details to us.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft]

Hi, @damiancds 

Have you check whether  this user has executable privileges for this statement?
You can try to call the statement in the database first.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@damiancds , If you trying to add a query, make sure that query is working with the same user credential on SQL developer without any issues. Check if there is any other detailed error. If everything is fine and it is still not working log an issue at - https://community.powerbi.com/t5/Issues/idb-p/Issues