Forum Discussion
oracle schema incorrect
Thank you for pointing me in the right direction. I see now that these are dropped tables in the recycle bin. I tried to purge the tables but do not have sufficient admin rights to do so. But there is a bigger question, which is why they are shown at all.
When I access this database and browse the schema using other products these "dropped tables" are not displayed. Also when I access the database using Excel Power Pivot or Power Query these tables are not displayed. It is my understanding (I may be wrong) that the recycle bin contents are not in the "All_Tables" table.
This behaviour of diplaying these tables seems unique to Power Query (based on my rather limited experience) and renders the product useless until I can find a solution. The problem is that there are too many of these tables (1000's) and Power BI cannot resolve the full list without "locking up". Even if I could solve that problem I cannot work with a list that contains 50 tables I want and 1000's of tables that I don't want.
Is there a control buried somewhere in Power BI that can be configured to read all tables except "dropped tables"?
There is a typo in the previous reply. What I meant to say is:
This behaviour of diplaying these tables seems unique to Power BI Query (based on my rather limited experience) and renders the product useless until I can find a solution.
Eric_ZhangMicrosoft Employee
It seems that when connecting to Oracle, Power BI runs some certain query to find out the tables(including the dropped ones) in schema. As a workaround, try to set up a query(select * from sometable) when connecting.