Forum Discussion
Write data directly to DWH from external application?
- Anonymous1 year ago
Hi Fragmaticx,
Thank you for reaching out to Microsoft Fabric Community Forum.
It appears that you're encountering slow performance when inserting data directly into your DWH table from an external application. This often occurs if each row is being inserted individually, which is not efficient for large datasets.
Consider using data pipelines to load bulk data from storage solutions like Azure Blob Storage or other external sources into your DWH.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to give "Kudos"Regards,
Vinay Pabbu
Might be better to pull instead of push. If you already have a finished dataset then maybe use pipelines or DF Gen2 to pull that in and fast copy it to the DWH.