Fabric Ideas

Hi Product Team,   In SQL Server, the fastest way to get a row count from a set of tables is shown below.  Unfortunately, the wrong aswer is coming back, zero records.     If we look use a SELECT statement, we get the correct row count.   The statement is supported in TSQL for MS Fabric Warehouse but does not work correctly.   Sincerely   John Miner Data Platform MVP   ... View more

Dear Product Group,   Why is the very common function not supported in the Fabric Warehouse?   It is supported on all other flavor of SQL Server.  Yes, I can query the sys.objects table to get the id, but a shortcut function reduces my total amount of code.   Sincerely   John Miner Data Platform MVP         ... View more

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

It would be great if there was multi-window support for the various elements of Power Bi Desktop, similar to Dynamics 365 Business Central.   I've tried the On-Object Interaction Preview but I prefer the classic version with the option to open multiple panes at the same time, even at the cost of screen space.   Another issue is when writing/editing a long DAX measure which takes up almost all screen space, requiring you to hide and reopen the formula bar to see the changes reflected in the visuals.   I imagine a version where you could you have separate windows for: Only the visuals (no Verical Panes or Formula Bar) Report View without Visuals, Table View, Model View, Dax Query View All Vertical Panes (like Filters, Selection, Sync slicers, Bookmarks, Visualizations, Data) ... 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

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

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

It would be very useful if users could restore their own bookmarks and if report administrators had the ability to restore all user bookmarks.   Some users lost all bookmarks after an update. A recovery option would greatly improve the experience and prevent data loss. ... 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

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

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

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

Enable individual users / freelancers to study and practice fabric with a per-user license similar to Premium Per User in Power BI. F2 is a price point that is too high for them. Strong limitations in time and resources available would make sense, but there should be a clear monthly cap that cannot be like the current F2. ... 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

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

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

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

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