Fabric Ideas

It will be great if it is possible in Power BI to conditionally format legend or line chart color in the format pane using a DAX measure, for example. While it is possible to dynamically assign colors in bar charts and conditional formatting for some visuals, it seems the legend and line chart colors formatting cannot be done with conditional formatting. If it is possible to achieve these currently, I would appreciate any guidance on how to do these. ... View more

Hey everyone,   We all know the truth—pie charts are technically allowed, but should they be? Absolutely not. That’s why I’m proposing a new feature for Power BI: Auto-Swapping Pie Charts. Here’s how it works: Whenever a user hovers their mouse over a pie chart, it instantly swaps places in the report grid with a more appropriate visualization that does make sense (like a bar chart, scatter plot, or anything that actually communicates data effectively).   Bonus Features: - If a user insists on bringing back the pie chart, Power BI will dim their screen and play a 30-second TED Talk on why pie charts are misleading.   As a start, we can implement this as an April Fool’s joke, and if the community response is overwhelmingly positive (as it should be), we can consider making it a permanent feature. ... View more

I would like to request an update to the public information attached below in the Japanese version. The English version is up to date, but the Japanese version has not been updated since 2024/11/20.   JP URL: https://learn.microsoft.com/ja-jp/fabric/database/mirrored-database/azure-databricks-tutorial EN URL: https://learn.microsoft.com/en-gb/fabric/database/mirrored-database/azure-databricks-tutorial   Reason for updating: I confirmed in the English version that a new "Prerequisites" was added. The Japanese version does not have this notation, so customers cannot test it following the correct procedure. ... View more

CONTEXT:  lakehouse (LH) == exists; no tables yet. pipeline (PL) == exists; create tables in LH for first time, then ingest data incrementally thereafter.   ISSUE: LH and PL do not sync at the same time. In other words, after a Copy data activity writes data to the LH, this data is not immediately available downstream to other activities in the same PL.  Therefore one must use the Wait activity and guess how many seconds to pause the PL leading to a non-optimal computational state of affairs.     Furthermore, since the PL already contains conditional branching for multiple tables in order to distinguish between first time full data ingest and future time incremental ingest, now the user has to use a condition + wait activity after each Copy data activity, thus adding 2 new activities for each branch already in exisitence and thereby easily breaking the max activity allowed threshhold of 80 activities per PL.     Now, the user breaks the PL into multiple PLs.  But a new problem arises.  Various PL variables maintain internal PL state values that need to be available further downstream in the original PL.  Now that this original PL is broken up into 2 or more PLs, how do you pass these values around to other PLs in both an elegant manner and a USER FRIENDLY manner without having to resort to some kludgy feature added as an afterthought to the PL machinery?    Currently 2 PL activities are available:   Invoke PL (Legacy) and Invoke PL (Preview).   When trying to pass PL variables or params around when using Invoke PL (Preview), Fabric tell the user to use Invoke PL (Legacy).     What happens when or if in a few years that legacy activity is deprecated?  Let's say some users at that time in the future will have dozens of PLs with complex data flows.  Now they will have to go back in and modify every single PL that was passing values around into other PLs and thus wasting hours not to mention increasing the possibility to introduce bugs where there were none before. That scenario is not acceptable and highly suboptimal.      SUGGESTION: 0__How about increasing the max allowed activity limit in a PL from 80 to 512, for ex?   1__How about exposing the LH sync clock as an activity to PLs so PL Wait activity can use that to precisely wait until the LH tells it the data is ready for read access?   2__How about designing Invoke PL (Preview) so it is both elegant and user friendly to pass params or variables around between PLs?   3__How about a menu option to transform the PL JSON mapping to Python code, for ex, so that the user could drop to Visual Code and continue adding/modifying the PL but directly as Python code, and then upload that to Fabric and have Fabric show it visually as usual as a PL with a bunch of activities? Also, letting Copilot analyze the code and provide suggestions and/or improvements (especially valuable for users who cannot afford a Premium SKU)?     ... View more

Hi Team, Great to get the ability to create a SQL Database via API are you working on the ability to return the connection details? To make it more useful it would be great if we could get the connection details for the created database to (similar to how we can get in warehouse).   ** Once completed can we update the offical documentation ASAP so the Terraform provided team can start using **   Return something like below:   {   "id": "5b218778-e7a5-4d73-8187-f10824047715",   "displayName": "SQLDatabase1",   "description": "A SQLDatabase description.",   "type": "SQLDatabase",   "workspaceId": "cfafbeb1-8037-4d0c-896e-a46fb27ff229"   "properties": {     "serverFqdn": "dqjx2zrgh4uejnetrut54cdkau-g3353rbpoubuvclqhgoznhkmji.database.fabric.microsoft.com",     "databaseName": "SQLDatabase1-b218778-e7a5-4d73-8187-f10824047715"   }, }   Thanks, Darren ... View more

To address the limitations of our current slicers, which are less advanced and potentially confusing compared to our competitors, a new and enhanced list and dropdown slicer should be designed with a wider range of customization options, incorporating industry best practices, and include innovative features like the ability to copy and paste lists. ... View more

Power BI - MS announcement regarding upcoming events or furute updates are great but it will be also appreciated if company announcement will be possible ... View more

When the report is exported to PowerPoint as an image and opened in PowerPoint, there will be some margins on the left and right. This margin can be reduced in the canvas settings, but it cannot be completely erased. We need an option to prevent these margins from appearing. ... View more

Secondary axes are automatically managed by the system in some cases, making it problematic for report creators with no control over intervals, ticks, and other crucial components, limiting effectiveness of various types of analysis. It would be great if the secondary axis included comprehensive format settings so that greater control over displayed data is provided. ... View more

Matrix visuals could significantly enhance the user experience by emulating Excel's intuitive sorting, searching, and filtering capabilities, even for hierarchical columns. This idea would the current limitation in Power BI's matrix visuals, which lack a comparable experience to Excel's established standard for data manipulation. ... View more

Could Microsoft support SQLMesh project so that they provide good compatibility against Fabric warehouse and lakehouse (via Spark)? Could SqlMesh be added as Fabric native workload to get it as service since this kind of sql modeling functionality with web UI is missing? Add support for Microsoft Fabric · Issue #3374 · TobikoData/sqlmesh ... View more

I only want the end users to access what's in the report, not the entire semantic model.   Today, when sharing a report, we also share read permission to the entire semantic model (except for any RLS or OLS restrictions).   This is unintuitive and risky, because many people are not aware that they actually share the semantic model when sharing a report.   Instead, I only want the end users to access what's in the report, not the entire semantic model. ... View more

I would love to be able to show/hide a visual based on conditional formatting from a measure. Say I only want to show the tables or matrix on the page if a person is selected from a slicer. I would create measure "Person Filtered = ISFILTERED(Person[PersonName])" Having a formatting option on the whole visual to "show/hide" visual based off this measure would be helpful. The current option I've found is to create a shape object to put on top of the visual and then add a measure to the background color of that shape to make it transparent if a person is selected. The problem with this work around is that you can no longer interact with the visual due to the shape being arranged in front of the visual. ... View more

If the legend is long, it will be truncated, but I want to display the full text. Therefore, I hope the following features will be added: - A function to adjust the display width of the legend - A function to wrap the legend - An option to display the full legend without truncation. ... View more

Hi,   Currently, the Power BI REST API allows us to extract only the workspace name and report name, but it does not provide the ability to retrieve a list of Data Activator Reflex items across different workspaces. We request that this feature be added to help track Reflex items more effectively. Thanks, Mahammad Jafar ... View more

If it was possible to offer a robust and customizable style management system for the matrix, it could be the key to enhancing the professional appearance of tables and matrices. Further, giving report creators the ability to adjust gridlines, color, style, and the addition of custom icons, bars, sparklines, and other elements, along with a variety of pre-designed styles, would significantly improve style management options for tabular elements. ... View more

Allow the user to add the category labels for Shape maps.  ... View more

To fix inconsistencies in analytic settings, functionality needs to be enhanced to ensure they are on par with other visual component enhancements made for Cartesians, and additional settings for scatter charts is also necessary. Report creators will find it easier to format and customize settings to align with the overall look and feel of their reports. ... View more

Microsoft should allow users to choose whether to enable smoothing rather than making it a mandatory feature. The smoothing capability should be an option, not an imposition from Microsoft. Smoothing introduces uncertainty, making it difficult to optimize costs for a Microsoft Fabric subscription. Additionally, smoothing is causing challenges across multiple areas, as highlighted in discussions within the Microsoft Fabric Community. Search - Microsoft Fabric Community ... View more