Fabric Ideas

This issue is listed as a known limitation: https://learn.microsoft.com/en-us/fabric/database/mirrored-database/troubleshooting#changes-to-fabric-capacity The mirrored status should not show as Running if it isn't actually running.  My idea is to add a mechanism to more robustly confirm if the mirroring is actually running or not.  Only show the Running status if it is confirmed to be truly running.  Note that this issue could theoretically occur under other circumstances, so it shouldn't be limited to only the Fabric capacity pausing scenario.   My suggestion would work well in concert with this suggestion if both were implemented: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Alert-on-failures-for-Mirroring-in-fabric/idi-p/4490680 I also recommend this idea, which would minimize the need for my own idea: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Automatically-resume-DB-mirroring-when-F-capacity-resumes/idi-p/4500709   ... View more

I want to be able to check the CU usage rate from more than 14 days ago in Microsoft Fabric Capacity Metrics. ... View more

Hi, I think it is very importante that the Fabric SQL database workload could support fully Power BI, also with Direct Lake mode, like it happens for a lakehouse or a warehouse. Fabric SQL database should be fully integrated in the Fabric platform. Thanks ... View more

I love the IDEA of these scorecards in Power BI/MS Fabric, however I feel they are falling short of the mark.  Below are some suggestions that I think could help get them to where they should be!   We use almost exclusively Direct Lake mode semantic models (both flavors on SQL endpoint and OneLake), because these are not refreshed in the traditional sense after I create a goal, the goal is not being updated daily like it is supposed to be.  Please fix this, goals should be refreshed based on the frequency I selected at goal set-up regardless of source. The Scorecard and Goals APIs need to be updated to allow SPN authentication.  Due to the limitation above, I was going to create a script to loop through all scorecards and trigger goal value refreshes, however I cannot do this programitically because SPN authentication is not supported.  I was able to hit the APIs and trigger a refresh by "borrowing" my session auth-token; which worked but is not a scalable solution. More options for calculation of parent goals based on subgoals.  Right now the only options are sum, avg, max, and min.  These options don't really work in a mixed metric scenario (e.g. % contact info of 75% and a CSAT of 7.7 out of 8).  I think a great addition here would be allow the user to select "Value" or "% of target" like you can in the "Status Rules" area.  So you would be able to either take the sum, avg, max, or min of the child values themselves OR take the avg, max, or min of the % of target of the child goals.  Alternatively, there could be a way for us to enter a formula for said metrics (maybe even DAX?)  Provide a way to weight subgoals and take them into account with the parent goal so that we can create a true balanced scorecard.  For example, if I had 3 metrics; I could rate one at 25%, another at 25% and the last at 50% contribution.  This would also require us to have more flexibility in subgoals calculations (see above) Provide an option to show the % of target IN ADDITION to the goal itself In the process of connecting a goal and target, allow the user to also select a description that can be mapped from the viz directly or the semantic model (E.g. I have a metric in a semantic model called OSAT with a description of "Overall customer satisfaction metric based on survey".)  This could be pulled through directly into a description field for that goal that could be shown as a column and/or a tool tip on hover to give the user additional context In addition to the option directly above, allow the user to provide a "manual" description for a goal and target that would be shown if it could not be linked, or they didn't want to link to it It would be great if when the user hovers over the menu items it would give them contextual help.  For example:  Follow goal hover = "Follow this goal to be notified when the status changes or when a check-in is provided.  Come back here to unfollow if you no longer want to follow." Right now the only viz that allows us to load history on a metric is a trend line at the individual day level, which is rarely used in our reporting.  So even though it does work, it is not practical.  I would like either: The ability to provide an optional report source that a goal would link to when the users clicks the "connected report" link.  This would enable me to build a hidden scorecard metric page within a report that would have a metric for tracking purposes but direct the users to the "production" version of that viz I want them to use. Or, better yet, allow history to be loaded for other charts as long as they have a date dimension linked to a marked date table Allow us to connect prior period values for a given goal as well.  These values could be compared to goals in a similar way to target metrics.  Ideally you would then be able to see on one goal how you are doing to prior period in addition to how you are doing compared to target.  These values could also be options for the "status" rules   Bugs: When I go to "Status Rules" section, if I enter a value (e.g. 80) in the "Value" box then select "% of target" the value gets overwritten and becomes difficult to change.  I say it is difficult to change because once the 100 value is there you cannot highlight the whole number and type over, you have to click into the box then use Del and/or Backspace to get rid of the number, then type it again. There is some sort of bug when you create a goal that is connected to data, it creates a blank check-in 1 month from the day it was created. I see milestones but nothing in the documentation abut what they are, why to use them or how to use them.  I feel like they would be useful, but I don't know how to interact with them. ... View more

We are leveraging Power BI models configured with Incremental Refresh and Detect Data Changes (IRDDC), using monthly partitions and a polling expression to track the maximum 'last update' date via a refreshBookmark. While Deployment Pipelines streamline model promotion, they currently lack the ability to control partition settings or manage the refreshBookmark during deployment. We request the addition of deployment options that allow us to: Preserve or overwrite the refreshBookmark based on deployment context. Exclude partition metadata from deployments when necessary to avoid unintended refresh behavior. Strategically update semantic models without disrupting incremental refresh logic. Existing 3rd Party Tools such as ALM Toolkit and TE3 provide the following options to achieve this:   These capabilities are essential for maintaining data integrity and operational efficiency in enterprise environments using IRDDC. While tools like ALM Toolkit and Tabular Editor offer workarounds, native support in Deployment Pipelines would significantly enhance governance and automation. ... View more

Currently, the Power BI mobile layout canvas has a fixed size , which limits flexibility when designing reports for mobile devices.  We would like to request the ability to customize the mobile canvas size, particularly the height, to better suit specific report requirements and improve user experience on mobile devices. ... 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

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

Interpreting visuals without a clear legend to indicate logic behind specific styles can lead to confusion and decision-making errors. An idea to enhance clarity and transparency by ensuring legends and tooltips accurately display colors, patterns, and other visual components influenced by logics, would enable report consumers to easily understand the applied logic and make more effective decisions. ... View more

Business Problem: We often need to grant specific users (e.g., a financial analyst responsible for a critical monthly P&L report) the ability to update and republish only that specific report within a shared finance workspace. Currently, to grant publish/overwrite rights for even a single report, we must assign the 'Contributor' role at the workspace level. This role gives the user permission to read, publish, edit, and delete all content in the workspace, which is often too broad and introduces risks to other sensitive financial reports and datasets. This forces us into less ideal workarounds like workspace proliferation or manual publishing bottlenecks. Proposed Solution/Feature Enhancement: Introduce a more granular permission level or an enhancement to existing item-level sharing that allows an Admin/Member of a workspace to grant a specific user (e.g., a Power BI Pro user) the explicit right to 'Publish/Overwrite' a designated individual report (or reports) within that workspace, without granting them the full 'Contributor' role for the entire workspace. This could be conceptualized as: A new permission option when sharing a specific report (e.g., 'Allow recipient to republish this report'). Or, an ability to scope the Contributor role to specific items within the workspace for publishing actions. Benefit for Finance Analytics & Similar Departments: This feature would significantly improve our ability to manage content securely and efficiently, empowering report owners to maintain their specific reports while safeguarding the integrity of other critical information within the same collaborative workspace. It directly supports better governance and reduces the risk of accidental modifications to unrelated financial data and reports. ... View more

We are currently using Power BI in an embedded fashion where the data and the analytics are surfaced to all our client in a Software-As-A-Service fashion in a multi-tenant setup with row level security. Basen on Microsoft's recommendation of implementing multi-tenancy in a secured way we have implemented service principle profile. And we found out that the Service Principle based query are not being differentiated in the Fabric Capapcity Metrics app. This differention is very vital for our tracking of the infrastructure usage and analysing infrastructure throttling.  ... View more

I am aware of the limitations as stated in the documents below. I would like to be able to share content with external users using the add-in. Title : Considerations and limitations URL : https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-about#considerations-and-limitations  -------------------------------------------- Business-to-business (B2B) scenarios aren't supported. -------------------------------------------- ... View more

Currently, when an error occurs in PowerBI, only window information is displayed and I feel the content is insufficient. For example, we would like it to be clearer whether there is a problem with the report content or the output behavior. Also, we would like to be able to retrieve information on the error content as a record and export it, etc. We believe this will facilitate inquiries when errors occur. We strongly request the implementation of the above. ... View more

Please make a UI (user interface) option to schedule a Data Pipeline to run in the user context (security context) of a Service Principal instead of my personal user.   This should also have the effect that any Notebooks within the Data Pipeline are run in the security context of that Service Principal. ... View more

Please make a UI (user interface) option to schedule a Notebook to run in the user context (security context) of a Service Principal instead of my personal user. ... View more

The primary axis are outdated and require significant improvement when compared to Excel. This makes it difficult for report creators and often leads to problems when trying to manage and style them effectively. By offering more format settings, greater control over displayed data can be provided, especially if axis ticks, new gridlines, and separators are also included. ... View more

A report or Admin API is required to provide details on capacity consumption by each workspace, enabling the distribution of billing to respective teams. If possibile, Microsoft should enhance the Fabric Capacity Metrics app by adding a visual that displays workspace-level capacity consumption alongside artifact-level consumption. This improvement would assist users managing different teams (Finance, Sales, etc.) in allocating billing based on actual usage rather than distributing costs equally across all teams, regardless of usage.   ... View more