Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
bobotime
New Member

Oracle Direct Query

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?

3 REPLIES 3
bobotime
New Member

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?

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
Community Champion
Community Champion

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors