Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
Hello,
i found out that connecting to Oracle or MariaDB is not supported in Fabric pipeline at the moment.
i know Dataflow Gen2 support those connectors but i do not want to use it since it is too slow(as i know)
and it still does not support fast-copy to on-prem database.
notebook is also not an prefered option for now because the destination must be an Warehouse instead of Lakehouse(what a despair😢)
is there any other options?
Thank you.
Solved! Go to Solution.
Hi,
You can try using Copy Pipeline for ODBC with on-prem gateway. It;s better than DF2, almost as fast as ADF Copy. BTW. You can use ADF with Fabric Lakehouse as a destination.
Regards.
You can use the Azure Data Factory tool to extarct data from Oracle database and MariaDB to Warehouse via Fabric Pipeline
Hi,
You can try using Copy Pipeline for ODBC with on-prem gateway. It;s better than DF2, almost as fast as ADF Copy. BTW. You can use ADF with Fabric Lakehouse as a destination.
Regards.
How do you actually do this? On Power BI Service/Microsoft Fabric, we've already created an ODBC Gateway Connection to our Oracle Source. When we try to use the Copy Assistant on the pipeline it requires us to use an Azure Data Lake Storage Gen2 staging environment, which we currently dont have.
Hi @jwryu
Glad that you query got resolved.
Please continue using Fabric Community for further queries.
Thanks.
Hi @jwryu
Thanks for using Microsoft Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
Appreciate your patience.
Thanks.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.
User | Count |
---|---|
40 | |
16 | |
10 | |
5 | |
3 |
User | Count |
---|---|
51 | |
51 | |
12 | |
9 | |
6 |