The PowerBI matrix visual only allows users to accurately sort on the leftmost Rows field. Users want to be able to sort the matrix like a table in Excel. They want to be able to sort also on the Values fields to see the highest values for specific metrics to show up on the top. Doing this is not straightforward. It requires users to click through the More Options menu, go to the Sort By menu and select their field name they want to sort by. This still does not produce the intended effect when we also have a field in the Columns section. In our use case we have 4 fields in the values section that are repeated per quarter (using the Date in the Columnn section). Users would like to be able to sort on specific fields for specific dates by simply clicking the column header. However, the leftmost Rows field is the only one which produces the expected sorting behavior. ... View more

Currently, it is possible to get the value sets for a variable library via Items - Get Variable Library Definition - REST API (VariableLibrary) | Microsoft Learn but since it's an LRO, there's a high cost in time & processing to get the values (e.g. wait for the operation, getting the defintion, procesing the body, converting the payload, etc.)    The idea is to make avaialble an interface that returns the valueset for a given variable library/variable, example ...  GET https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/VariableLibraries/{variableLibraryId}/variables/{variableId}/valueset   This will be equivalent to the functionality exposed by notebookutils  samplevl = notebookutils.variableLibrary.getLibrary("sampleVL") samplevl.test_int samplevl.test_str   ... View more

We need to subscribe base on the report type. For example, subcribe for paginated reports and normal reports.  ... View more

Hi, it would be great if, when getting a result from a query in the SQL endpoint, it allowed the option to add thousands separators, currency symbols, etc., to make reading the results easier. ... View more

EDIT: I've identified that this was due to a user setting caching issue, not a permissions issue. This issue was resolved by switching browsers.   The new public preview of the Manual Update for On-Premises Data Gateway is now live!   Sadly, although the role description on the Gateway settings page shows that the Admin role allows users to manage gateway updates, the [ Gateway Update available ] and [ Update gateway ] triggers seem gated behind the Fabric Admin role membership.   It is difficult in my organization to get the Fabric Admin role membership, and this seems an unnecessary complication for the BAU task of updating the gateway that I am already an administrator of, and removes much of the benefit of the convenience of the web based update mechanism in preview.   It would be great to see the web based update be enabled for members of the Admin role on the gateway. ... View more

Currently, creating and testing a Fabric Data Agent requires a paid F2 or higher Fabric capacity. Many users, including myself, would like the opportunity to evaluate and test this feature before committing to purchasing capacity. I would like to suggest allowing Fabric Data Agents to be available under: - Trial capacity environments - Limited-time evaluation access - Developer/testing sandbox mode   This would help organizations better understand the value of Data Agents, validate use cases, and make informed purchasing decisions. Providing trial access would accelerate adoption and encourage more customers to invest in Fabric capacity once they experience the feature firsthand. ... View more

I would like the ability to add icons to the different deployment pipelines. Each business group has their own workspaces and deployment pipelines. I would like to be able to add icons to each of these, so I can easily differentiate them.    Alternatively, they could use the icon of the final deployment stage workspace.   Similarly, in the pipeline view, it would be nice to have an icon of each stage. I would use the icon of the workspace set to that stage, so using that icon automatically would be sufficient. ... View more

Hello Fabric Community ! Here an Idea to improve Power BI user experience and report possibilities : - extend the Sort by option of the new card visual to the values inside the Card (exactly like with the multi-row card) Best regards! ... View more

I recently had a spike on my fabric capacity with no user tagged against the query activity. After discussing with support this was identified as due to the eviction and recalculation caused by changing the storage mode on the semantic model from small to large.   This possibility of this CU spike is currently not documented and the blank user in the capacity metrics app also creates confusion. Two suggested improvements.  1. Include this in the docs as a consideration for when changing the storage size, currently this is not documented. 2. Set the user to a useful value in the capacity metrics app, ideally something like storage mode conversion task but even Power BI Service as used for other internal operations would be better.  ... View more

I am working on automating CI/CD for semantic models in Power BI / Fabric. I can successfully deploy semantic models and define RLS/OLS roles using TMDL, but I am unable to automate the assignment of users or Azure AD groups to those roles. At the moment, role membership must be added manually through the semantic model security UI. Is there any supported way to automate role membership for RLS/OLS, for example via: - Power BI REST API - XMLA endpoint / TOM - Fabric REST APIs My goal is a fully automated, repeatable deployment without manual post-deployment steps. ... View more

Hi, I have a great idea - I have a lot of tabs and  I need to sort them somehow. So it will be great to have some folders option nearbyTabs. If you like my idea and it would be implemented, do not forget to share profits 🙂  ... View more

Hallo, Ich hätte eine Idee für eine Funktion, mit der man für Dropdown-Slicer und ähnliche Filter Standardwerte definieren kann, die sich dann auch automatisch aktualisieren. Ein Beispiel: Es sollte möglich sein, als Standard immer die aktuelle Kalenderwoche auszuwählen. Wenn eine neue Woche beginnt, aktualisiert sich die Auswahl automatisch. Dann sind alle anderen Wochen nicht ausgewählt. Umgekehrt sollte es auch möglich sein, standardmäßig alle Kalenderwochen außer der aktuellen vorauszuwählen. Nutzer könnten dann bei Bedarf die aktuelle Woche manuell hinzufügen.  So kann sich ein Unternehmen zum Beispiel den Umsatz alle vollendeten Wochen anschauen, ohne das die Aktuelle nicht vollständige Woche dabei ist. ... View more

Users or workspace admin need to enable "email subscription" by workspace leve instead of tenant level. This function can provide more flexibility to manage the email subscriptions. Thanks. ... View more

Allow copying conditional formatting from one cell to another in the same matrix row.  It is so frustrating!  I have columns of values for 48 month8.  I have to set rules for each one to see if it is below, within, or above a set of values. If it matches the value, it's green, if it's below, it's yellow, if it's above it's red. The conditions are all the same.  It's taking me forever to set the conditional formatting for every ond of the 48 columns.  Please make this easier. ... View more

Allow copying conditional formatting from one cell to another in the same matrix row.  It is so frustrating!  I have columns of values for 48 month8.  I have to set rules for each one to see if it is below, within, or above a set of values. If it matches the value, it's green, if it's below, it's yellow, if it's above it's red. The conditions are all the same.  It's taking me forever to set the conditional formatting for every ond of the 48 columns.  Please make this easier. ... View more

Hello sir,ma'am We would like to optimze powerBI user experiece, Regarding the creating the new measure in powerBI data pane If measure is wrongly created in wrong table it must be able to drag into the correct table. If there are More measures then there must be ascending or descending order for displaying measures ,latest measure will appear on top or  acoording to Alphbatical sorting ... View more

Currently, Power BI does not support displaying Top N positive and Bottom N negative values in the same visual without complex DAX workarounds. It would be extremely useful to have a native option in bar charts to display, for example, Top 5 increases and Top 5 decreases based on a measure, while respecting slicers and filters. This is a very common business scenario (variance analysis, KPI evolution, YoY comparison). ... View more

Please make it possible to interactively run a Notebook as a Workspace Identity, Service Principal or Managed Identity.   Purpose: This would allow us to connect to resources that our personal user account doesn't have access to. This would allow us to interactively test notebooks using the Workspace Identity, Service Principal or Managed Identity before we include the notebook in a pipeline. This way, we could test: the identity's access to data sources and the notebook code's functional compatibility with running as SPN/WI/MI (because not all notebook functionality like semantic link is compatible with SPN, we'd like to be able to test this interactively before including the notebook in a pipeline). ... View more

I would love to have a dropdown slicer that supports word wrap. Right now, we have a complicated solution that involves buttons and a list that acts like a dropdown slicer but is very clunky.   Making the slicer longer does not help due to space as was suggested.  ... View more