Forum Discussion
Solved
Performance on Oracle to Oracle load
Happy New Year! I am using the on-prem gateway to load Oracle data into Oracle database, the load speed is really slow, the insert process is just 5kb/s which is not acceptable. Is there any conf...
Hi caomayan,
Thanks for confirming that your issue is in fabric.
As per my observation, there is no error here but there is a performance latency issue. So I suggest you to please follow the below steps:
- Check for table indexes and constraints that might slow down inserts. Temporarily disable them during bulk loads.
- Partition target tables if dealing with large datasets.
- Reduce Data Volume, only transfer the data you need by applying filters at the source query level.
If the issue still persists, I suggest you to please raise a support ticket
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
