Forum Discussion

elijudy1's avatar
elijudy1
Frequent Visitor
7 years ago

Power BI having issues reconciling different schemas in same Oracle Database

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 databas...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
elijudy1
Frequent Visitor
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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