Monitor report usage metrics - Power BI | Microsoft Learn   Referring to the steps in the document above, after creating the Power BI usage metrics, I performed the following steps: 1. Specified a new semantic model "Report Usage Metrics Model" as the data source from Power BI Desktop. 2. Switched to the model view and clicked "Make changes to this model" from the menu to change to DirectQuery mode. After changing the storage mode to "DirectQuery" with the above steps,   I can check the storage mode from "Properties," but it is grayed out, confirming that the storage mode cannot be changed.   The storage mode is grayed out. I understand that the "Usage Metric Report" is read-only, so there are limitations in functionality, but it would be convenient if the storage mode could be changed, so I will submit this as a request for improvement. ... 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

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

Dear Power BI Team, I hope this message finds you well. I would like to bring to your attention a challenge that many Power BI users, including myself, face while designing professional reports. Specifically, the current version of Power BI Desktop lacks an option to fully justify text within textboxes. The ability to justify text is a fundamental feature for text alignment in most design and reporting tools. Its absence in Power BI makes it challenging to create visually balanced and professional reports, especially when presenting large paragraphs of text or narratives. Aligning text to the left, center, or right does not provide the same level of visual harmony and readability as a fully justified format does. This limitation is particularly evident when creating reports for stakeholders or clients where high standards of presentation are expected. I believe that implementing a Justify Alignment option would significantly enhance Power BI's text formatting capabilities, ensuring users can produce polished and well-structured reports. It would also align Power BI with other reporting tools that already offer this feature, further strengthening its position as a leading data visualization platform. I appreciate the tremendous work your team puts into improving Power BI and hope you will consider adding this feature in future updates. Thank you for taking the time to review this suggestion. Best regards ... View more

In the notification settings for schedule updates, I would like to be able to set notification settings other than email. For example, notification settings to an external tool such as a scheduler that does not require manual confirmation and can be managed by automatic monitoring. ... View more

When exporting a report as a PDF in the Power BI service, I would like to be able to export the report keeping the original font. If a font is replaced by another font, I would like to be able to export it in my country's font, not in a different country's font. ... View more

Many organizations use SharePoint (e.g., Excel files) as a data source for Power BI reports. Currently, business users rely on their personal SSO credentials to refresh semantic models, which leads to connection issues when: The model owner leaves the company. The owner's password changes. Ownership of the model is transferred. For other data sources like SQL databases, best practice is to use service accounts to avoid these issues. However, Power BI does not currently support Service Principal authentication for SharePoint sources. Feature Request: Enable Service Principal authentication for SharePoint Online in Power BI to improve security, maintainability, and reliability of data refreshes. If you agree, please upvote to help prioritize this enhancement! ... View more

The current card visual forces users to overlap elements or waste copious amounts of time creating custom visuals. The new card feature should give users the ability to create multiple cards in a single container and provide a greater level of customization. ... 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

When exporting to an Excel file with “Data in current layout” in the report visual, I do not want the row with the filter content to appear in the bottom row. ... View more

It would be beneficial to incorporate features from Pivot tables that allow for the expansion and collapse of columns and hierarchical column groups within tabular visuals. This would not only solve the current limitations of matrices but also provide report creators with the flexibility to hide and show rows and columns, saving these settings for future use, thus eliminating the need to scroll through irrelevant data. ... View more

I would like a style slicer that pops up a calendar that allows selection by a single date, rather than a range of dates. ... View more

Enabling customized calculations at the query level for subtotals and grand totals would offer greater flexibility in reporting and preserve performance. Efficient organization of control settings to modify the style of these totals separately will empower report creators to achieve their desired appearance, while addressing their need for more control and customization in reporting. ... View more

Imagine a world where report creators can automatically apply slicer and filter selections based on specific logic, revolutionizing data analysis and user experience. This innovative approach eliminates any need for complex workarounds, optimizes slicer functionality, and paves the way for more efficient and effective data reporting. ... View more

There is no way to monitor the load times at the moment for paginated Reports as the Load times of Paginated Reports are not integrated into the Usage Metrics. Idea: Please incorporate the Load Times of Paginated Reports into Usage metrics or provide another way to monitor these times ... View more

Need API for Power BI gateway creation for Sql connections while using authentication method – service principals ... View more

Fabric Warehouse currently supports the OPENROWSET function, which allows you to read CSV files directly. However, when it comes to reading JSON files, you need to use a workaround. This involves treating JSON files as text or CSV files and then using OPENJSON and JSON functions to parse the JSON documents. While this method works, it is considered a hacky workaround and not very elegant. To improve this, Fabric Warehouse should add a native support for JSON in the OPENROWSET function. This would eliminate the need for tricks with OPENJSON and JSON functions, making the process of reading JSON files more straightforward and elegan.   The current workaround for reading json is: SELECT TRY_CAST(JSON_VALUE(jsonContent,'$.orderId') AS INT) AS orderId, JSON_VALUE(jsonContent,'$.orderDate') AS orderDate, JSON_QUERY(jsonContent,'$.orderDetails') AS orderDetailsObject, JSON_QUERY(jsonContent,'$.deliveryAddress') AS deliveryAddressArray FROM OPENROWSET( BULK 'https://<storage>.dfs.core.windows.net/datalakehouseuk/raw/json/orders.json', FORMAT = 'CSV', FIELDTERMINATOR ='0x0b', FIELDQUOTE = '0x0b' ) WITH ( jsonContent VARCHAR(500) ) AS r;   ... View more

I have three workspaces -- DEV, UAT, and Prod.  Within these workspaces, I have several independent projects - each with their own deployment schedule and processes. The current pipeline process makes it nearly impossible to deploy these projects independently of one another because a human being has to rebuild the pipeline for every deployment.  Not only that, but the difficulty in rebinding notebooks, semantic models, etc as part of the deployment makes the whole pipeline process a non-starter. It would make the deployment pipeline process much easier/better if I could: 1) specify what data pipelines, data flows, notebooks, semantic models, reports, environments, and lakehouses need to move between workspaces 2) specify what data within lakehouses needs to be copied 3) rebind any notebooks, semantic models, and reports In short, I want a pipeline package for each project that I can define within the source workspace(s) ... View more

Make it possible to write SparkSQL without having a Default Lakehouse.   With 3- or 4- part naming, i.e. [workspace].[lakehouse].[schema].[table]    there should be no need to attach a Lakehouse in order to use SparkSQL.   Needing to attach a Lakehouse is annoying and adds extra complexity. ... View more