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

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

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

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

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

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

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

Need API for Power BI gateway creation for Sql connections while using authentication method – service principals ... 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

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

For low code users, it would be awesome if there was a Data Pipeline activity that can be used to run Optimize on a table in a Lakehouse (or all tables in a Lakehouse).   For example, when using Copy Activity or Dataflow Gen2 to append data to a Lakehouse table, the tables need to get optimized (compacted) after x runs. But there is no automated, low-code way to do it. So users forget to optimize the table in the destination Lakehouse. ... 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

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

English : This is an improvement idea that would mainly help people like me who have 2 monitors, or an ultrawide monitor. It would be good if the formula bar (DAX measures) were detachable and could be allocated anywhere on the screen (outside the PowerBI UI). This way, we developers would have the interface with the visuals available to perform validations while adjusting more complex formulas that have several and several lines.   Today, Microsoft Excel has a function to duplicate the window, which would also meet this need.   Of course, not everyone and not every report has or needs large formulas like the one I'm mentioning in this post, but when the need arises, it would be great if there was a ready-made solution in Power BI.   Thanks !!   Português : Esta é uma ideia de melhoria que ajudaria principamente pessoas que como eu, possuem 2 monitores, ou um monitor ultrawide.   Seria bom que a barra de fórmulas (medidas dax) fosse destacável e pudesse ser alocada em qualquer lugar da tela (fora da ui do powerbi).   Assim nós desenvolvedores, teríamos a interface com os visuais disponivel para realizar as validações enquanto ajustamos fórmulas mais complexas que possuem várias e várias linhas.   Hoje, o microsoft excel possui uma função de duplicar a janela, que também atenderia essa necessidade.   Claro que nem todo mundo e nem todo relatório possui ou precisa de formulas grandes como a que estou mencionando neste post, porém quando houver a necessidade, seria muito bom que houvesse uma solução pronta no Power Bi.   Grato !!   Demonstration ... View more

For low code users, it would be awesome if there was a Data Pipeline activity that can be used to run Vacuum of a table in a Lakehouse (or all tables in a Lakehouse).   For example, when using Copy Activity or Dataflow Gen2 to write to a Lakehouse table, the tables need to get vacuumed. But there is no automated, low-code way to do it. So users forget to vacuum the destination Lakehouse. ... View more