Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Column Level Security for reports

    Ability to define rules at column level, to control the data fields available to different roles (e.g. employee salary visible to the users in finance roles only, while other employee details visible to other department roles).

    1,236 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    105 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  2. Drill Mode By Default

    It should be good if we can set Drill Mode ON/OFF by DEFAULT instead of clicking manually on the arrow every time on report.

    1,188 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    237 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  3. Clear all slicers

    Clear ALL slicers on a page with one click, perhaps an addition to a slicer for a clear all slicers button or perhaps a custom visualization that is a button to press to clear all slicers.

    1,167 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    53 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  4. SAP BusinessObjects BI Universe

    All of the current Ideas that mention SAP BusinessObjects BI Universe integration are marked as completed as this feature was offered pre June/July release. This is nearly a critical requirement for adoption in my organization.

    I had previously heard that this was removed due to licencing restrictions, can we get an official response on that? Is there any possibility of this being re-integrated?

    1,152 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    147 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  5. Organizing Measures into Categories using Folders

    Adding few measures to your data model in PowerBI could be easily managed, but what about adding tens or even hundreds of measures! Organizing those measure into categories using folders could help a lot.

    To show you what I exactly mean, I will demonstrate the alternative way to create those folders using empty tables:


    1. Select "Enter Data" from the Home ribbon > Change the column name to "Id" and choose the table name e.g. "_Financial Measures" (Create all the tables)

    2. Select "New Measure" from the Modeling ribbon (Or choose any shortcut) > Type and create a new measure e.g. Total…
    1,115 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    11 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  6. Built in Git support in PowerBI Desktop

    When you create a PowerBI report in Power BI Desktop it transparently create \ use a git repository. So you just worked normally, then when you hit publish, it actually push to remote.

    Gitignore could be used to exclude data from being published to the repository. PowerBI would have version control which is desperately needed.

    This would work well with the whole Microsoft buying Github \ Azure DevOps, both from the perspective of promoting good practices such as code version control and CI\CD - process of developing in development and promoting to UAT\production

    It would also allow IT to get…

    1,041 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    12 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  7. Security - Ability to maintain source security for reports published on BI Sites

    The general requirement is that visualizations (Power View, SSRS etc...) must not circumvent existing policies, or introduce yet another set of security policies on top of those already implemented at the source.


    • For example, a visualization of sales data needs to reflect the policy that account managers can only read sales data for their region.

    • For performance reasons, this is enforced at the source by injecting predicates into the query based on the end users identity. If identities for end users are not passed down the process chain into the data layer, it leaves us little option but to publish…
    1,011 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    88 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
    under review  ·  Sirui Sun responded

    Hey all!

    We’ve continued to make progress here, so I wanted to update this thread with our current capabilities for maintaining security on dashboards/reports.

    As always, all of this information can be found in our Row-Level Security (RLS)documentation: https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

    > If you have set up RLS in Analysis Services, Power BI will send the signed-in user’s credentials to Analysis Services, and respect the RLS rules set up on the on-premises model.

    > Separately, you can set up RLS in Power BI for data sources that you import or connect to via DirectQuery. This process starts in PBI Desktop, where you define roles, and write DAX to constrain what data these roles can see. As part of this process, can you use the UserPrincipalName() DAX function to get the current signed in user’s UPN (e.g. joe@contoso.com). Then, once you publish to service, you can assign users to these…

  8. SSRS Reports for drill down into detailed reports

    I think using SSRS type of reports to show detailed information that make up measures dispalayed on the dashboard would be useful. Currently I do that in performance point using actions from my tabular models. I think if that was included this would be a full replacement to performance point.

    988 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    24 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  9. export to PowerPoint via the power BI desktop only

    I work in a big insurance company and due to security reasons, we can't upload anything to the cloud / the power BI web services.
    However, we love and use the Power Bi desktop to create beautiful internal reports. but we need to share them internally with slides.
    we need a way to export reports directly from the power BI desktop to PowerPoint (without publishing the report to the web)

    This is a must have feature for all the analysts in my team and will love to have your support on that.

    952 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    96 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  10. Connectivity to Google sheets

    Connecting to Excel workbooks in OneDrive is a great first step, but connectivity to Google Sheets should be there too.

    949 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    79 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  11. 942 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    69 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  12. Make functions refreshable when the data source is a parameter of the function

    Like discussed here: http://community.powerbi.com/t5/Integrations-with-Files-and/Refreshing-queries-with-functions-doens-t-work/td-p/2450 - queries where data access happens inside a function and where the data source is dependent on parameters to the function should be refreshable.

    930 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    107 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  13. 900 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    193 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  14. Transfer of ownership of created dashboards

    It would be great if there was an option to tranfer ownership of created reports and dashboards. This way, work would not have to be duplicated if the original creator was to leave the company/change roles/etc.

    881 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  55 comments  ·  Dashboard  ·  Flag idea as inappropriate…  ·  Admin →
  15. SAP

    Connect to SAP BW with single-sign-on via on-premise gateway

    Large SAP BW installations with thousands of users are often accessed via single-sign-on (SSO) e.g. the users windows credentials are used to authenticate to BW. SSO simplifies the user experience and reduces user administration costs. These users should be able to setup on-premise gateway connections that can be used to refresh data sets in the Power BI Service. The connections should leverage that individuals BW roles & authorizations and not require a BW password i.e. automatically associate the Power BI user ID to the associated SAP user ID.

    877 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    52 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  16. Hide Filters pane on Power BI Report Server

    Is there any possiblity to hide Filters pane in Power BI Report server. We don't want to show the filters been used to external clients in our report for unnecessary discussion on calls.

    Something like &filterPaneEnabled=false in Power BI Report Server

    874 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    46 comments  ·  Report Server  ·  Flag idea as inappropriate…  ·  Admin →
  17. field of "duration" type

    is it possible to add support for "duration" data type in the report view as in Power Query?

    869 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    140 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  18. Create calculated columns when using SSAS live connect

    In May 2017 Power BI Desktop started supporting creation of DAX measures when working in live connect mode to an external SSAS model: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/

    Vote on this idea if you want support for calculated columns in this mode as well!

    843 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    32 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  19. Email notifications on auto-refresh failure

    The scheduled data source failure notification is only sent to the data source owner, it would be more useful if you could specify the recipient(S) or group.

    825 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    20 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  20. Vertical and horizontal multiples (Small Multiples/Trellis)

    As it is realized in Power View for Excel. THNX!

    821 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    93 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.