capacities
896 TopicsFabric Capacity Permissions
So we have decided to move to Fabric F2 at my workplace but we're having issues with permissions. Me and my colleague cannot create workspaces and put it at Fabric Capacity, even though my boss has granted us Capacity Permissions. Our boss who is Capacity Admin can create those workspaces and make us Admin for those workspaces, but in those workspaces we cannot create SQL Databases or Warehouses. We had the same issue when were on the Trial-period. We cannot for the life of us figure out what to do. We want to be able to create Workspaces at Fabric Capacity and create all necessary artifacts such as SQL Databases and Warehouses.25Views0likes2CommentsArchitectural Advice: Isolating Client Reporting vs. ETL Workloads on F64 Capacity
Hello Fabric Community, We currently run both high-concurrency Client Portal Reports and Heavy ETL/Analytics (PySpark pipelines, lakehouse refreshes, ad-hoc queries) on a single F64 Capacity, leading to resource contention. Proposed Strategy: Separate Capacities: Split into two dedicated capacities—one strictly for user-facing client reporting and one for backend ETL/analytics. (Bonuse stratgey - not a primary focus )Database Mirroring: Mirror source databases directly into our Medallion Lakehouse to reduce pipeline batch ingestion load. Questions: Is splitting an F64 into two separate capacities the recommended way to protect client-facing reporting, or is workspace governance enough? What are the trade-offs regarding CU efficiency and cross-capacity OneLake shortcuts? Has database mirroring proven more CU-efficient than standard metadata-driven copy pipelines? Thanks for your insights!69Views3likes6CommentsMonitor Hub search results paginated across multiple pages instead of returning consolidated results
The monitoring hub on the Fabric platform seems to be splitting search results, even when there are few, across multiple pages instead of condensing them into one page. Is this a known issue for others using the new Monitor Hub? Can this be rectified?11Views0likes1CommentRecovery retention policies differ across Development, Testing, Production, and Sandbox workspaces?
How should Item Recovery retention policies differ across Development, Testing, Production, and Sandbox workspaces? With Item Recovery available for supported Fabric items, should organizations apply the same recovery retention period across all workspace types, or should Production workspaces have a longer retention period than Development/Sandbox?22Views0likes2CommentsCannot log ticket on Since 30 Sep update, Fabric Planning sheets go blank with any model measure.
Cannot log ticket on Since 30 Sep update, Fabric Planning sheets go blank with any model measure. Column sums still work. Planning sheets blank ("No rows to display") when using semantic model measures. Started after the 30 Sept service update.72Views1like5CommentsMs Fabric & PBI in different region
We are currently modernizing our Sales & Service KPI reporting platform using Microsoft Fabric and would appreciate advice from the community on the best way forward.Our source data is in an on-premises Oracle database, and we need to ingest Sales & Service KPI tables into Fabric for reporting. The main challenge is that our existing Power BI environment and Microsoft Fabric environment are hosted in different regions. Because of this: The existing On-Premises Data Gateway can currently be accessed only by Power BI artifacts such as Dataflows. Fabric artifacts such as Pipelines, Copy Activity, Mirroring, etc. are unable to use the existing gateway configuration. Microsoft documentation indicates that moving an existing Power BI tenant/workspace to another region is also not straightforward. Due to this limitation, we currently have access only to Dataflow Gen2 for data ingestion and need to proceed with the project using Dataflows initially. Some of the key design and implementation questions we are trying to address are: Should all tables be loaded through one Dataflow Gen2 or split into multiple Dataflows? What is the recommended approach for full load at time, full load on month ends & incremental loading: N-1 day append or watermark/Last Updated Date? What is the best approach to move from daily batch loads to near real-time reporting in the future? What are the current best practices for Lakehouse backup and disaster recovery? Has anyone faced a gateway region mismatch between Power BI and Fabric? If so, what was the long-term solution? For an F64 capacity, how do Dataflow Gen2 and Fabric Pipelines compare in terms of performance, scalability, and capacity consumption? understanding the capacity impact of using Dataflows as the primary ingestion mechanism. Any recommendations, best practices, or lessons learned from similar Fabric implementations would be greatly appreciated.76Views1like12CommentsFrom Odoo & personal gateways to a Fabric Lakehouse: Medallion + Direct Lake, and F64 down to F16
We recently modernized the Power BI estate of a manufacturing client running Odoo while working on a project at DataToBiz Before: Gen1 dataflows pulling Odoo over XML-RPC, Python scripts running through personal gateways, and many reports nobody opened. All of it ran on an F64 capacity with slow refreshes (trial version) What we did (in about 60 working days): Built everything in a separate dev workspace on a small F8 capacity, so production was never touched Used report-usage metrics to pick only the reports worth migrating Moved Gen1 → Dataflows Gen2, and switched Odoo XML-RPC → JSON-RPC Moved the Python scripts into Fabric notebooks and removed the personal gateways Bronze/Silver/Gold medallion into a Fabric Warehouse, then one certified Direct Lake semantic model Rebound the Sales, Marketing and Production reports, ran UAT against the old workspace, then deleted the old content Result: Production capacity went from F64 to F16 with stable CU usage. Estimated saving is about $75K per year. Refresh time went up significantly. Question for the community: 1. When you downsize a capacity, how much CU headroom do you keep for spikes like month-end or bulk refreshes? 2. We used 75% peak utilisation on the Capacity Metrics app as our cut-off. Curious what thresholds others trust.Solved105Views1like5CommentsFabric App availability in UK South
The Fabric region availability link says UK South now has Fabric Apps (it's not listed in the `Unavailable Fabric features` column). However, when I go to my UK South Fabric capacity, where quite a while ago I set "Enable Fabric App Items (preview)" to be "Enabled for the entire organization", Fabric Apps still don't appear in my UK South workspace when I want to add a New Item. Any idea why it's not appeared yet? https://learn.microsoft.com/en-us/fabric/admin/region-availability126Views1like5CommentsDP-600 Voucher
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } Hi everyone, I recently passed the DP-700 Microsoft Fabric Data Engineer Associate certification and am now planning to take DP-600 (Microsoft Certified: Fabric Analytics Engineer Associate) while the Fabric concepts are still fresh in my mind. Unfortunately, I wasn't able to use a previous DP-600 voucher when I first received it as I wasn't ready for the exam at the time. I was wondering if anyone is aware of any current voucher opportunities for DP-600, or has an unused voucher that they won't be using and is transferable (if permitted by the voucher terms). Any guidance would be greatly appreciated. Thanks in advance! Regards, Amanul55Views1like2Comments