Question: I've reviewed the Microsoft Fabric roadmap but haven't found any mention of Dataflow Gen2 support for ingesting data into non-'dbo' schemas in Fabric Warehouse.
Does anyone know if there are plans to allow direct ingestion into custom schemas for both new and existing tables, without requiring a staging step in dbo?
I've explored the staging workaround, but I’d prefer a solution that avoids data duplication and allows direct schema mapping.
Any insights would be appreciated!
1 Comment
- Alaahady
Advocate II
As a user actively transitioning to Microsoft Fabric and leveraging its enhanced capabilities for big data analytics, I strongly support enabling custom (non-dbo) schema support in Dataflow Gen2. This feature is essential for maintaining organized, scalable, and enterprise-grade data architectures—especially in environments where schema separation is critical for governance, performance, and collaboration across teams. Avoiding the need for staging in dbo not only reduces duplication but also aligns with best practices in data warehousing. Adding this capability will significantly improve adoption and usability of Fabric, reinforcing Microsoft’s strategy to empower data professionals with flexible, modern tools. Looking forward to seeing this enhancement prioritized!
Recent ideas
extend storage capacity of varchar(8000) to varchar(max) for warehouse
The maximum string length of 8000 is often considered too short to store longer descriptive data or embed a JSON value within a text field in a database. Dividing the data into smaller chunks and st...c_mettler5 hours agoNew MemberCompleted3.3KViews61likes13CommentsAdjust column width in SQL Analytics Endpoint user interface
I can't see the column names and cell values in some of the columns in my tables in SQL Analytics Endpoint because the column width is too narrow. Also, the tooltip also doesn't show the entire...frithjof_v6 hours agoCommunity ChampionCompleted4.2KViews75likes8CommentsIn TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >"
Using in the Power Bi's Service Cloud. In TableEX visual when using Custom tooltip, it shows below it the automatic "-> Drillthrough >" and selects & clicks the drillthrough page. In TableEX vis...LR37 hours agoRegular VisitorNew4Views0likes0CommentsAllow Power BI subscription sender identity to be configured
The new Power BI subscription delivery platform changed existing subscriptions so that notification emails now show the subscription owner as the sender instead of mailto:[email protected]...bbussey9 hours agoRegular VisitorNew20Views4likes2CommentsSupport Workspaces folder pairing across Fabric Deployment Pipeline stages
Fabric Deployment Pipelines should support deploying items organized in workspace folders when equivalent folder structures exist across stages. Currently, deployments can be blocked when items are ...majofv10 hours agoNew MemberNew5Views0likes0Comments