Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Please include the option of Exporting Power BI reports to Excel which will include all the items present in the report

    Please upgrade the feature of Exporting Power BI reports to Excel which will include all the items present in the report.

    Currently Power BI reports exports only the individual visualization(Table/Matrix) by clicking on "..." options but instead we want to export the whole report at once.

    Just like how the SSRS reports exports into excel by keeping the logos, headers, formatting and other items when exported to excel.

    Requesting Microsoft Power BI team to include this functionality in Power BI as this is a life saver and absolutely necessary for our Organization.

    Thank you

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

    We’ll send you updates on this idea

    3 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  2. Better Handle Column Types on Load in Dimension Tables

    When you load a dimension table (say a calendar table) in Power BI desktop, there are often lots of numeric columns that are not additive. Examples include Year, Month Number, Day of Week etc. By default (unless you set the data type to text) these numeric columns will have the default aggregation behaviour set to SUM. But they are not additive (of course). It would be much better to set these (dimension numeric columns) as "do not summarize". This could be managed in various ways that would be better than the current state. eg, you could simply mark all numeric…

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

    We’ll send you updates on this idea

    3 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  3. OData.Feed should support entity bound function with same name as property

    Microsoft case 119083024001340 was filed for an issue causing a failure in OData.Feed when reading valid OData metadata. Microsoft Product Group agreed there is an issue but will not fix it unless there is sufficient votes.

    The issue occurs if an OData entity, lets call it MyNamespace.E1, has a property named JobStatus and there is also a bound function also named JobStatus that is bound to MyNamespace.E1. In this case, when OData.Feed reads $metadata from the OData API, it throws an exception:
    [Expression.Error] The field 'JobStatus' already exists in the record.\r\nStackTrace:\n at Microsoft.Mashup.Engine1.Runtime.KeysBuilder.Add(String key).

    Again, just to be clear, Microsoft…

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

    We’ll send you updates on this idea

    0 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  4. Allow the definition of ambiguous data relationships when creating data models & force the super user to select the desired relationship

    This is a feature that other BI tools like SAP provide, but PBI does not allow it.

    When creating relationships in a data model, PBI does not allow you to create an ambiguous relationship. We need to be able to create ambiguous relationships in a model. When a super user (report writer type) uses data associated with an ambiguous relationship, they should be prompted to choose the relationship they desire for their report.

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

    We’ll send you updates on this idea

    0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  5. 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.

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

    We’ll send you updates on this idea

    22 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  6. Combine multiple Gateway in single dataset/report

    Currently, all data sources in a Power BI report/dataset, that are not on cloud, must be available in a single Gateway to work.

    But if the datasources in the report are coming from different Gateways, that doesn't work. It is not possible to combine them for refresh.

    Say I have a Sales Report. It connects to DB A, B and C.

    DB A and B is configured in Gateway X
    DB C is configured in Gateway Y.

    The report creator have been provided access to all of them.

    Now if I try to configure data refresh in PBI Service, it…

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

    We’ll send you updates on this idea

    7 comments  ·  Gateways (Enterprise and Personal)  ·  Flag idea as inappropriate…  ·  Admin →
  7. Allow 'Search' within slicer filtering for non-text attributes

    Text attributes can be 'searched' within report slicers. However, integers cannot. For example, if someone wants to quickly find and slice by a Customer Id, it is very cumbersome right now - lots of scrolling. A simple search by Customer Id (as an integer) within the slicer would make it much faster and a better user experience

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

    We’ll send you updates on this idea

    4 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  8. Subscription for Power BI reports from Report Server

    I know this idea was recently (April 2019) shot down by Microsoft, even with over 2,000 votes in favor of it, but I'm bringing it up again. The simple fact is, we are bound by regulations that keep us from using the cloud service, so the on-premise Power BI Report Server is our only option for widespread report distribution. Paginated reports on PBIRS can be subscribed to, which makes the inability to add Power BI reports to subscriptions even more frustrating. This lack of support severely limits our ability to grow acceptance for the platform. I ask that you please…

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

    We’ll send you updates on this idea

    3 comments  ·  Report Server  ·  Flag idea as inappropriate…  ·  Admin →
  9. B2B Workspace Contributors not able to republish reports via Power BI Service

    B2B users, set up as Contributors to a workspace, are unable to replace a report with an updated version. Contributors do not have access to modify a dataset, which is required when republishing a report with a modified version. The contributor role should include data set replacement privileges.

    The option where you can enable particular users to modify a report via the dataset tab is inefficient in a large organization using a premium capacity with a large number of contributors distributed across many teams.

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

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  10. 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,146 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    13 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  11. Denodo Direct Query in Power BI Report Server

    Denodo Direct Query has been available in Power BI Server but not Power BI Report Server yet. Can we make this feature also available in PBI RS?

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

    We’ll send you updates on this idea

    35 comments  ·  Custom Connectors  ·  Flag idea as inappropriate…  ·  Admin →
  12. Separate settings for Export Data and Build Permission

    The current setup of Build Permission is too extensive and I see a need to find a middle ground in terms of data access permission. What I (and I assume others) need is a middle-level configuration where users cannot build new reports on the dataset (including analyze-in-excel), but can still use Export to Excel based on pre-configuered visuals. This way the developer can control what data granularity or filter is available to the consumers.

    This ties in to existing requests to disable Analyze-in-Excel feature specifically, and now expands into the broader scenario of Build Permission and shared datasets.

    Related post…

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

    We’ll send you updates on this idea

    7 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  13. Dataflows Direct Query

    Dataflows would be really useful if you could connect to them via DirectQuery. This would mean that we could query enormous dataflows that are not practical to load to the Data model and can make aggregate dataflows that we load to the Data model.

    Unsure if this is possible with the architecture of a Dataflow, but it could be quite handy if it is possible.

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

    We’ll send you updates on this idea

    under review  ·  24 comments  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  14. refresh dataflow with Flow

    The new capability to refresh a dataset in Flow is great - would like to see that functionality extended to dataflows as well.

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

    We’ll send you updates on this idea

    1 comment  ·  Dataflows  ·  Flag idea as inappropriate…  ·  Admin →
  15. Power BI direct connector to ADLS2 (Azure Data Lake Storage Gen2) thus Power BI directly connect to ADLS2 for reporting and Firewall slider

    currently Power BI does not have direct connection to ADLS2 and requires Power BI Dataflow to access the ADLS2 data which causing data redundancy and creating extra hop for the same data and can be directly consume form ADLS2. Power BI direct connection with ADLS2 is great addition for Advance Data Analytics and firewall slider Power BI which enable exclusive access Power BI similar to AAS (Azure Analysis Service) .

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

    We’ll send you updates on this idea

    11 comments  ·  Data Sources  ·  Flag idea as inappropriate…  ·  Admin →
  16. Please extend Dataflows and Machine Learning capabilities to Free users

    Please extend Dataflows and ML capabilities to Free users (of course limiting the processing power/storage). This would be great for learning purposes and would also help a lot in making these PBI tools more popular and increase the adoption.

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

    We’ll send you updates on this idea

    5 comments  ·  AI and Machine Learning  ·  Flag idea as inappropriate…  ·  Admin →
  17. Power Query parameter to decide to refresh or not

    I would love to have a formula in PQ that decides whether the query needs a full refresh or not. Currently, we can manually select if we want a query to be "included in report refresh". But let's say a huge flat file has not changed since the last refresh - then it's a waste of resource to do a full refresh until it changes. Thanks!

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

    We’ll send you updates on this idea

    2 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  18. Move Measures Between Tables in New Modelling View

    The new Modelling View was delivered in Nov 2018 and is fabulous. There is already a button to select all measures in a table - great. I would like to then move all the selected measures to another table, either by drag and drop or by selecting the home table in the properties list (just like you can do for formatting).

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

    We’ll send you updates on this idea

    3 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  19. query folding enable/disable option

    An option to enable/disable query folding.

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

    We’ll send you updates on this idea

    10 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  20. Disable or prevent Teams from autocreating App Workspace

    Please introduce a global setting to Prevent Teams from creating PowerBi App Workspace automatically when creating a new Team. As the new Workspaces are detached from Teams/Groups this should be a setting to prevent the App Workspaces beeing clotted with empty Workspaces from all our Teams.

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

    We’ll send you updates on this idea

    45 comments  ·  Administration  ·  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.