Hello,
I am connecting to two oracle DBs from the same pbix file. In power query, my first query has something as:
let
Source = Oracle.Database("db1.world", [HierarchicalNavigation=true, CommandTimeout=#duration(0, 2, 0, 0)]),
Schema = Source{[Schema="schema1"]}[Data],
table1 = Schema{[Name="table1"]}[Data],
in
table1
My second query is similar to the first:
let
Source = Oracle.Database("db2.world", [HierarchicalNavigation=true, CommandTimeout=#duration(0, 2, 0, 0)]),
Schema = Source{[Schema="schema2"]}[Data],
table2 = Schema{[Name="table2"]}[Data],
in
table2
I am referencing these two tables (let's call them Primary tables) to create 4 other queries, (2 based on the first table (A1,B1) and the others based on the two tables, A2,B2). Let's call these secondary tables.
Finally i am appending the two queries A1,A2 together and B1,B2 together.
In power query i have no problem with the process, however when i try to apply and close the steps, at some point i get an Oracle Datasource Error - ORA-01652: unable to extend temp segment by 128 in tablespace temp error. The only post that i had found suggested to contact the DBA to either increase the temp table, or to see why the database ran out of space. I tried with the DBA to check what was happening by monitoring the DB, but at that time, the problem didn't happen. Now the problem is occuring again, and the DBA is asking if there is a way to capture what SQL statement is being send from power query to the DB.
Any suggestion on why i am having this error or how can i capture the sql statemetns being send from power query to DB?
