The nice 'clean' way of handling this usually is to have a single table, then use views for your role playing dimensions. But due to the limitation of views in semantic models you generally don't want to do this as it results in directquery being used. So instead you are forced to duplicate your dimension tables into your semantic model which goes against normalisation principles. Users have suggested using USERELATIONSHIP instead, but this approach is insufficient as you can not use measures in certain scenarios. Ie as the rows in a matrix visual.   Other alternatives include flattening the source tables, but this is not ideal as then you have gaps in your data based on what is available in the source. ie if used in a date range you get awkward gaps in your visual based on the presence or lack of in your source data as opposed to a proper dimension table. ... View more

Currently fabric warehouse permission management is complicated. There are two sets of permission management, one is fabric workspace role, the other is sql syntax. Workspace Viewer implicitly grants ReadData on every warehouse in the workspace. Admins who want granular access must either (a) avoid Workspace Viewer entirely or (b) issue per-table DENY — which is the opposite of how SQL Server has worked for decades. Especially when we have hundreds of tables, users, views, roles, schemas, the permission management is complicated that we need to manually grant deny permission each time when new users or new tables are added. Also there is no integrated UI for object-level permission, Every GRANT / DENY / CREATE ROLE must be done in T-SQL. There is no view to see "who can access what" on the warehouse — admins must hand-query sys.database_permissions. Also both the configuration under "Manage Permission" and fabric workspace role will not be added to DMV.  Note: Fabric SQL Database already exposes "Manage SQL database-level roles" in the portal — maybe bring the same experience (and extend it to object-level) to Warehouse. With AI innovation, we were also wondering if it's possible to add AI-assisted permission editor: natural language → generated GRANT / DENY with preview, plus least-privilege suggestions.   Thank you for your insights ... View more

In fabric the visibility into users, app audiences and published reports in a particular workspace would be incredibly valuable, particularly from a governance point of view.    Senior management often require visibility into reports, audiences and audience members. If Microsoft are recommending to publish via app audiences, this data should be readily available to analyse and display.   ... View more

I used Microsoft Fabric OneLake external data sharing to share OneLake data from Tenant A with Tenant B. OneLake diagnostics was enabled on the Tenant A side.   After that, a user in Tenant B accessed the shared data, and an access record was output to the OneLake diagnostics logs on the Tenant A side. At that time, the logs did not record the Tenant B user. Instead, the user who created the external data share in Tenant A was recorded in the executingUpn column.   I understand that this behavior may be by design, because the external tenant user information may not be directly displayed in the provider tenant, or because access through external data sharing may be recorded under the permission context of the user who configured the share in the provider tenant.   However, from an audit and security investigation perspective, it is difficult to determine from the logs alone whether the access was a direct access by an internal user in Tenant A or an access by a user in Tenant B through external data sharing. External data sharing is an important feature for securely sharing data across tenants.   Therefore, I would like OneLake diagnostics logs to clearly identify when access is made through external data sharing. For example, the following types of improvements would be helpful:   Example: ・accessContext = External data sharing ・accessType = External share access ・isExternalDataSharingAccess = true ・Or display additional information for executingUpn, such as: 　・External tenant user 　・Access via external data sharing   It is not necessary to show the actual UPN of the external tenant user. At a minimum, I would like the logs to make it possible to distinguish between direct access by an internal user in the provider tenant and access through external data sharing.   This would allow Fabric administrators and data owners to more accurately distinguish expected access through external data sharing from direct access by internal users when reviewing OneLake diagnostics logs.   In enterprise environments, auditability and traceability for cross-tenant data sharing are important. Therefore, I believe this improvement would be very useful for operating OneLake external data sharing. ... View more

It would be valuable for Fabric Eventhouse to provide a built-in, standard replication service for cross-region data redundancy and failover. Today, there is no native solution, and teams must rely on custom approaches.   A first-class, Fabric-native replication capability would simplify BCDR and improve reliability for production workloads. This includes built-in cross-region redundancy and failover for regional outages, as well as native data replication scenarios such as Azure Data Explorer (ADX/Kusto) to Fabric Eventhouse (KQL DB) and Fabric Eventhouse to Fabric Eventhouse across regions. ... View more

Currently, tooltips in Power BI reports are automatically triggered when users hover over visual elements. While tooltips provide valuable information, there are scenarios where users may want to temporarily disable them to improve navigation or data selection. I suggest adding an option to allow users to turn tooltips on or off for individual visuals, or to introduce a keyboard shortcut or mouse combination that temporarily disables tooltips. This would greatly enhance user experience, especially when interacting with complex reports or dashboards. ... View more

We are trying to migrate from ADF to fabric and we have cosmos storage(Gen 1 )stored in ADLA in ADF and there is Gen 2 as well but to sync that as well it is asking for ADLA with service principal and client credential key...In ADF ,ADLA account is set using managed identity with no credential based access...When trying to migrate our ADF pipeline to Fabric ..We use Scope activity but connection infrastructure part is where we are unable to connect in fabric. ... View more

As a small and growing business, we have a Microsoft Partner - Partner Success Core Benefits package to support our business operation. We have Copilot functionality on all required business tools, except Power BI - this is due to our package not having F2 or higher Fabric capacity or Power BI Premium capacity P1 or higher - we currently have Microsoft Fabric (Free) and Power BI Premium Per User (PPU). To enable CoPilot functionality in Power BI, we would need to enhance our package at an additional cost, which we would not expect when the package is designed with our type of business in mind. We suggest the Partner Success Core Benefits package is enhanced for all, to enable Copilot functionality for Power BI.   ... View more

On the Fabric Roadmap release schedule, it would be very useful to be able to subscribe to a notification when an item on the release schedule becomes available on Preview and GA.  It is very cumbersome to have to periodically go look at the release schedule to see if interested items have changed status.   ... View more

Summary I propose adding a built-in pane in Power BI Desktop where developers can manage report-related tasks and notes, with optional integration to tools like Jira, Azure DevOps, or similar platforms. Problem During development, it’s common to track tasks, issues, and notes for each report page. Today, this requires switching between Power BI and external tools, making it harder to keep context and stay efficient. Proposed Solution Introduce a “Tasks and Notes” pane that allows developers to: Add notes and tasks linked to specific report pages View tasks relevant to the current page Connect to Jira, Azure DevOps, or similar tools Link or create work items directly from Power BI Sync task status between Power BI and external systems Benefits Reduces context switching Keeps tasks tied to report structure Improves collaboration and transparency Aligns Power BI with modern development workflows Closing This would improve the development experience significantly, especially for teams already using structured work tracking tools. Would be interesting to hear if others see value in this type of integration. ... View more

I keep clicking create a ticket but keep getting directed to the home screen where I can suggest ideas, there appears to be nowhere that I can log that the system does not work and show our teams attendance figures, can this be resolved as this happened for weeks last period too, so we cannot view our teams office attendance ... View more

Currently, to allow business users to access Fabric Warehouse or Lakehouse data through Excel, we need to provide workspace-level access. This exposes additional artifacts and workspace items that users do not actually need or donot need to view or have access to. It would be great if Microsoft Fabric supported more granular access specifically for Excel connectivity, allowing users to: Access only Warehouse/Lakehouse SQL Endpoints Query authorized tables/views from Excel Avoid visibility into unrelated workspace artifacts, reports, notebooks, pipelines, etc.   Many business users still rely heavily on Excel for analytics, so enabling secure and limited Excel-based access would greatly improve governance while supporting real business workflows. This would help maintain the principle of least privilege while improving the overall user experience in Fabric and analytics. ... View more

In our multi-tenant solution we use partitions in Apache Kafka to separate data for each tenant. To process events from a specific partition (aka tenant) and stream them into a tenant specific destination (KQL database in this case), it would be nice if it is possible to subscribe to a specific partition when configuring an Apache Kafka datasource in an eventstream.   Today it is mandatory to do 'Event processing before ingestion' and use transformations to filter tenant specific events and route them to the tenant specific KQL database. When you can subscribe to a specific partition, it becomes possible to use 'Direct ingestion' instead. ... View more

I recently raised a ticket to MS because I could not "choose" an account in the salesforce.com connector (with Oauth2 authentication) Vs the one used in Fabric Dataflow itself. This because the account used to devlop reports does not have direct access to SFDC (as per complnay policy the account in SFDC must be a "Personal account", where in Fabric I am using a functional account). By desing curretly this is not possible insted it is POSSBILE in PowerBI Desktop data models for example (diffeent login). Request/Suggestion would be to "align" the behavior in DATAFLOWs to behave as in Desktop Datamodel    Below the outcome of the ticket I raised TrackingID#2606030050003758 Call summary: ->You are using Functional account to login to Power BI service and then trying to use the personal account for Salesforce source login in the semantic model settings as the Functional account does not have access to Salesforce. ->However, Salesforce only supports Oauth2 authentication currently and uses the account that is signed in to Power BI to access the source. Due to this, you could not successfully sign in to the Salesforce. ->We confirmed that this behavior is expected as the only authentication method we have for Salesforce is Oauth2. ->With this we concluded to use the personal account which has access to the Salesforce data source as of now. For any feedback regarding the product,  I recommend you to please visit "Fabric Ideas - Microsoft Fabric Community"  as this is the only place where product feedback is looked into. ... View more

I'm trying to create a relationship between two tables, but the "New Relationship" window hides the "Save/OK" button at the bottom of the screen. I can't scroll within the window, resize it, or even resize the Power BI window itself because it's in full-screen mode. The screen zoom is set to 100%. Nothing works. This is a fundamental user interface problem that renders one of the core features unusable. It's unacceptable for a dialog box to hide its own confirmation button. And one last thing: this program of yours is Microsoft gar6age It's useless. Everything gives an error; every equation gives an error. I'd rather use a program from the Stone Age than use this one again.     ... View more

Currently when configuring Copy activity/Dataflow in microsoft Fabric, changing the read method from Full copy to incremental copy returns. "incremental copy is not supported for the selected source store."   This limits implementation of efficient medallion architecture patterns and increases capacity consumption because full refreshes are required.   Please add native incremental support for dataverse, including support for: -> Change tracking/ CDC -> ModifiedDate or watermark columns -> Insert/Update/delete detection -> Delta processing for lower CU consumption  -> Pipeline integration   Business impact : Without incremental capability, large datasets require repeated full refreshes, increasing processing time and Fabric CU consumption. ... View more

When saving a PBIX file, the Windows "Date modified" timestamp does not update even though the file was saved. Excel updates the timestamp correctly. This makes it difficult to track whether the report has been updated. ... View more

Would have been nice to have a functionality for 'exclude' in a Tree map visual (and other visuals)   It would have been nice to slice and dice the figures by not only explicitly including what to see, but to exclude e.g. the largest customer / biggest product etc. ... View more

The current Groups dialog window is fixed in size, which makes it difficult to work efficiently when grouping fields with long values (e.g., bilingual labels such as English/French). Users must constantly scroll horizontally between “Ungrouped values” and “Groups and members” to add and rename groups, which significantly slows down the workflow. Allowing the dialog window to be resized or expanded would greatly improve usability and productivity, particularly for enterprise and bilingual reporting scenarios. ... View more