To support business users, provide a GUI-based table creation feature that requires no coding. ... View more

queryinsights currently supports only ASCII characters.   Specifically, both the command column in queryinsights.exec_requests_history and the last_run_command column in queryinsights.frequently_run_queries have non-ASCII characters converted to “? ”and the last_run_command column of queryinsights.frequently_run_queries are converted to “? ”.   In order to use queryinsights in auditing, it would be effective and useful to support non-ASCII characters.   We have been informed from a Microsoft support request that this limitation will be removed in a future feature addition. We therefore hope to have this resolved as soon as possible. ... View more

Problem: Currently, when a dataset is connected to a Lakehouse as a datasource in Power BI Fabric, it defaults to a cloud connection mapped to SSO. In embedded mode, reports built on these datasets fail due to a lack of identity, as they do not inherit authentication from the service principal. To resolve this, users must manually adjust the datasource settings via the Power BI service https://learn.microsoft.com/en-us/fabric/fundamentals/direct-lake-fixed-identity   Proposed Solution: Introduce a new REST API or extend the current API functionality to allow programmatic setting (or re-setting) of the connection to the service principal, including updating datasources. Benefits: Automates the process, reducing manual intervention Minimizes downtime for embedded reports Enhances developer experience and deployment efficiency Ensures consistency in authentication settings across different environments Impact: This feature will significantly improve the workflow for organizations embedding Power BI reports using service principals, ensuring seamless and automated datasource authentication. ... View more

The OneLake Catalogue in Fabric offers to filter by domain, but the same catalogue in Power BI Desktop does not offer the same filter. Can we have feature parity here? ... View more

I would like to be able to grant write permissions on a directory-by-directory basis to individual users or target groups in OneLake's "Manage OneLake Data Access."   Currently, "Manage OneLake Data Access" only has settings for "Read" and "ReadAll."   The roles that are automatically granted write permissions are the "Workspace Admin Role," "Member Role," and "Contributor Role." However, as the above are write permissions for the entire lake house, please add a function to grant write permissions on a directory-by-directory basis. ... View more

With the rising adoption of Multi-Factor Authentication (MFA) across our organization and industry best practices, we are seeking a more robust and streamlined authentication method for connecting Power BI to Snowflake. Currently, Power BI primarily relies on username/password or OAuth 2.0 via Microsoft Entra ID. While these methods are functional, they can become cumbersome and less secure in MFA-enabled environments. We propose the implementation of RSA key pair authentication for Snowflake connections within Power BI. ... View more

Enabling automatic or scheduled mirroring of OneLake data across Azure regions would significantly enhance the platform's suitability for global enterprise scenarios. Key benefits of this capability include: Improved resilience through cross-region redundancy for disaster recovery and high availability Reduced latency by allowing data access from geographically closer regions Simplified data operations, eliminating the need for manual synchronization via Dataflow Gen2 or ADF pipelines Potential cost optimization, especially if replication avoids outbound data transfer charges Recommended configuration options: Selecting destination regions for mirroring Choosing between read-only and read/write replicas Defining sync intervals (e.g., near real-time, hourly, daily) This feature would align OneLake with enterprise expectations for multi-region data availability and performance. ... View more

In our setup, we work with multiple environments (Dev, Test, and Prod), each represented by its own workspace. To streamline deployment via pipelines, we keep Lakehouses and Notebooks named identical across workspaces.   Previously, when opening a Notebook, we could clearly see which Lakehouse it was connected to, including the workspace name it belonged to.  This made it easy to identify if a Notebook was referencing, for example the Dev Lakehousem while working in the Prod workspace. We could then simply disconnect and re-add the correct reference.   However, with recent UI changes, only the Lakehouse name is visible, not the workspace it is contained in. This creates confusion when multiple Lakehouses share the same name across different workspaces. Even when adding a new source, the explorer does not clearly show which reference is from which workspace. This makes it far too easy to mistakenly remove or connect the wrong Lakehouse especially in production environments.   This seemingly small UI regression significantly affects productivity and introduces potential risks during deployment or debugging. Please consider restoring the visibility of workspace names to Lakehouse references in Notebooks.   Before: Screenshot from google E.g: Workspace Dev -LakehouseA -LakehouseB .... Workspace Prod -LakehouseA -LakehouseB ....   After:   Only lakehouse name   We use same lakehouse name in each workspace   ... View more

Make it possible to see storage consumption at Item level in the Capacity Metrics App.   At the moment, we can only see storage consumption at Workspace level, and this makes it difficult to pinpoint exactly which items (lakehouses, warehouses) consume most storage in our workspace.   Displaying the storage size (gigabytes) at Item level would increase the usability of the Storage page in Capacity Metrics App. ... View more

Can this feature be applied to Excel files like Csv files?? ... View more

We need insights into the storage consumption of active files and soft deleted files.   The Capacity Metrics App's Storage page should have the ability to show the storage size of soft deleted files and the storage size of active files. And the total.   Today, it is not possible to differentiate between storage size of soft deleted files and active files in the Capacity Metrics App. ... View more

Currently, we understand that custom font support requires importing a font via JSON, and users must also install the same fonts on their systems. To streamline this process, we propose the following enhancement: Custom Font Storage on Server: Implement a custom storage option on the server where fonts can be uploaded and stored. Centralized Font Management: Integrate these fonts into the Power Service, allowing all users to access and view texts in custom fonts without needing to install the fonts on their individual systems. This solution will simplify font management, ensuring consistency in font usage across all users and enhancing the overall user experience. ... View more

When I write a spreadsheet into my lakehouse files folder, I would like to be able to download it without having to install the onelake storage explorer.  Please provide a download link for files in the lakehouse files folder! ... View more

Hi Team,   Can we replicate the ADLS Gen2 Lifecycle Management options to OneLake please.   eg If a customer wants to build an archival type solution with data retension policies we can't recommend using OneLake as an alternative to ADLS Gen2 storage account as it doesn't have the same lifecycle policies to allow us to delete files.   We have this idea to bring add ability to do tiers but we need the liefcycle policy option on top please https://community.fabric.microsoft.com/t5/Fabric-Ideas/Add-storage-tiers-to-Fabric/idi-p/4508264   Thanks, Darren ... View more

Hi,   Currently, it is not possible to trigger a Fabric notebook run via the REST API, when the notebook is communicating with a lakehouse that has schemas enabled.   This feature is marked as 'Public preview', but there are several threads suggesting a fix would have been in place by late 2024: https://community.fabric.microsoft.com/t5/Data-Engineering/Error-when-writing-data-into-schema-enabled-lakehouse-using/td-p/4111069   The workaround suggested does not work either. It seems very strange that it works without the schemas enabled. The underlying issue seems to be:   INFO notebookUtils [Thread-62]: [FabricClient][ListWorkspaceByMssparkutils][get] Completed request url https://api.fabric.microsoft.com/v1/workspaces/ with correlation id X, requestId: X, activityId: , status code: 403, total cost 173ms, request cost 166ms   A timeline of when this feature would be supported will be appreciated.   Regards,   Oliver ... View more

If Fabric shortcuts has ability to point to specific version of underlying delta files, we could easily implement versioning in ETL process. Currenly Data Engineering solutions implement custom versioning solutions to provide good quality data downstreams. If Fabric can provide that feature in built, that would greatly reduce development efforts. Also, everyone can follow standard approach. ... View more

When Fabric capacities are located in different regions, shortcut caching will be supported. Currently, internal shortcuts do not have a caching mechanism. Improve latency for accessing data across regions Reduce cross-region data transfer costs ... View more

Is it possible to add more write access roles for specific folders in a lakehouse? It seems that the folder-based access currently only has the option of providing read access to other users. We are thinking of a data landing lakehouse for external users to upload data into specific folders they are provided access to. ... View more

Dear community, Do you also face the challenge that you upload csv-files and need to monitor manually if the file was modified? Then you manually start the process to have the current data available in your tables/data models/reports?   In the documentation it is explained that a action can be triggered by "if the the file is created or replaced"; this only happens when the file is really uploaded manually (or by a notebook) in the browser in onelake in fabric. If it is only changed in the onelake file explorer for windows preview feature plus saved there, ONLY the activation details arrive but NO action is triggered.   It would be nice to have a possibility to trigger an action when the data within the file is modified. ... View more