Power BI having issues reconciling different schemas in same Oracle Database

[elijudy1]

In SQL Developer, SQLPlus, and Excel I successfully run a query where a table sits in a specific schema under a specific database. But the query won't run in Power BI. Queries to other Oracle databases run but this specific one won't. This specific one queries a table from a different schema, but the database is the same. Power BI seperates the schema and then reads it as empty, whereas SQL Developer, SQLPlus, and Excel do not seperate the schema, they instead see the table under one schema. How do I know Power BI seperates the schema? Because when I don't run the query and just connect to the database, Power BI introduces a schema under this database that is not shown in SQL Developer, SQLPlus, or Excel. This schema is the username for the database. This make no sense to me and is quite mysterious. But it is an issue. Because now I have to create an Excel file that will run the query, then connect to that Excel file using Power BI. That's a drag.

[Anonymous]

Hi @elijudy1 ,

Do you means use t-sql query to get data from database? If this is a case, you can enable advanced options and add your query to sql statement.

I think it is impossible to use power bi to invoke additional driver or client to query data.

Regards,
Xiaoxin Sheng

[elijudy1]

Thank you for your quick response. I do add t-sql query to the sql statement for all my queries. Queries to this database referencing this particular table come back with an error stating the table is not defined. This is the only table I get this error with. Other queries to this Oracle database not querying this table come back fine. In fact when I try and poll the database without a query the specified table shows up as an empty schema rather than a table.

[Anonymous]

HI @elijudy1 ,

What type of table you used? entity table or dataview from external database?
If you have multiple databases(with similar table names) install on that device, I'd like to suggest you to use full name to invoke that table.

BTW, current power bi not support to get data from dynamic data structure tables. Power query steps will cache previous table structure and you can only update same data structure table records.

Regards,

Xiaoxin Sheng