cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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 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.

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Power BI having issues reconciling different schemas in same Oracle Database

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.

3.png

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

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: Power BI having issues reconciling different schemas in same Oracle Database

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.

Highlighted
Community Support
Community Support

Re: Power BI having issues reconciling different schemas in same Oracle Database

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

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors