Oracle Direct Query

[bobotime]

Hi everyone, I'm going crazy, I can't understand the problem.

I have direct Oracle queries that update Powerbi tables (which obviously have relationships), there are over 30 million records, for a few days the query has not finished, it remains in a loop and does not finish and therefore I have to block everything and remove the changes.

I tried creating a new query and it loads the content without any problems and in a short time.

I do not understand?
Could the update problem be due to the relationships these tables have with other tables?

Can you help me please?

[bobotime]

Thanks for the reply AntrikshSharma,
How can I check this?

However, when I went to download the diagnostic trace file I detected an error; it can't manage a field because the table no longer exists, in fact I deleted that table, why does it keep it in memory?

[v-cgao-msft]

Hi @bobotime ，

Is there a measure still referencing the deleted table? There is a similar discussion here:
Solved: Table deleted long time ago not found while refres... - Microsoft Fabric Community

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[AntrikshSharma]

@bobotime Did you check if your database is even receiving any request from PBI service?