Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add column - Index column, i.e. Table.AddIndexColumn, shall create whole numbers (int) instead of decimal numbers (float)

    Currently the Table.AddIndexColumn() functions creates values of type decimal (floats). I see no reason for creating decimal numbers since the incremental steps can't be set to decimal number, nor the initial value can be set to a decimal value:

    Table.AddIndexColumn(table as table, newColumnName as text, optional initialValue as nullable number, optional increment as nullable number) as table

    The documentation does not say what type the new column will have, but now it's created as decimal number.

    The recommendation will be that Microsoft either changes the type of the generated column, or extends the parameter set with a type so we…

    2 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  2. Create efficient "development mode" for Query Editor query refreshes

    As of August 2019, development of queries with large result sets is painfully slow. It appears this has been a problem for several years. Building power queries is on the critical path and a pre-requisite to data modeling. There also seem to be some defects related to the Power Query implementation in PBI Desktop. Anecdotally, sometimes by cancelling and restarting refreshes, or performing an overlay install of PBI can help queries once "frozen" during a refresh cycle magically return results instantly.

    Ideas to remedy Power Query performance:

    1) Cache the entirety of "base" queries from which others are "referenced".
    2)…

    3 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  3. Power BI with Jupyter Notebook Interactivity

    As a Data Analyst, I work a lot with Power BI in one part and Jupyter notebooks in the other part to explore datasets. Notebooks are perfect to explicitly show the different phases of analyzing data. Power BI is the perfect solution to create rich dynamic reports with top notch visuals.

    What about a creating a Power BI connector for Jupyter notebooks. Or being able to attach a Jupyter notebook to Power Query to combine the best of both worlds. I know that there is a Python Script capability inside Edit Query, but we want much more :)

    Disclaimer: I…

    4 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  4. dimension description template

    It would be very useful to add a 'dimension description' page for most used common dimensions. This would complete the dimensional modeling (as by theory) of nominal, ordinal, categorical (etc) dimensions.

    Examples
    - A dimension can have a preferred sort order (by name, by attribute, by measure)
    - A dimension can be numeric, but still ordinal (average and additions not applicable), and the basic interpretation is 'string with numbered sort orders'
    - A dimension can be non-additive (average numbers) or non- multiplicative
    - A dimension can be numeric with labels (e.g. driving distance with road exit names)
    - A dimension…

    2 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  5. Automatically create custom Date tables for all Date fields

    Similar to how a hidden date table is created for every date field in the model by default, there should be ability to define a custom date table that automatically gets associated with all date fields in the model. This will allow model developers to be more productive when there are multiple date fields in the model.

    3 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  6. Rename applied steps before steps are created

    Could we please have an applied step renaming box appear when someone creates an applied step that will allow them to rename the step before the step is created? The “default” name that Power Query normally assigns would appear in this box by default.
    It is good practice to rename applied steps after creating them (especially with more complex queries), and this process would be much less cumbersome if the user was automatically prompted to change the step name prior to the step being created.

    2 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  7. modeling - currency formatting

    I have a difficulty when I have decimal data and need to turn several columns into unit.

    Improvement Ideas:
    1 - Favorite or choose the ones that should be at the top, in my case I have to select column by column and search among so many units that have.

    2 - Select multiple columns and format at once. Ex: Decimals direct to real currency R $.

    3 - Or, formatting princel to replicate this same currency unit format

    2 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  8. Encapsulation, code reuse

    We aren't in 1970 anymore. We need code reuse and logic encapsulation.

    Suppose I have a lot of Data sources and I want to use it on a lot of report with the same kind of manpulation in M or in Dax.

    In M I use a lot of date manipulation in DAX and we often recreate the same calculation in DAX.

    I shouln't have to rewrite function / code from pbix to pbix

    How about custom library, outside fucntion call (in any other language) and so on!

    2 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  9. Export Data From Visualisations as they appear in PowerBI

    It would be good to be able to export data that appears in PowerBi visuals in Excel in the format as they are presented. Currently export will retreive the underlying data and not how it has been pivoted/presented within PowerBI.
    Benefit of this is that the investment in time to get it ini that format is not wasted (or needs more time to redo in excel) if that data is needed for other teams to use

    5 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  10. power query date diff function

    Add date diff function in power query similar to DAX version.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  11. export data from one Power bi data set to other

    set an automatic data export to an excel file located in One Drive. this could help in using the data used by different power bi models as currently we cannot modify / create tables in models where we are using data source = Power Bi dataset or Power Bi dataflows.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  12. Incremental data refresh from a stored procedure

    Incremental refresh works good when refreshing data from tables. We have to deal with complex logic and predefined structure which is not possible from tables. Incremental refresh from stored procedure will be very helpful.

    7 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 →
  13. Incremental refresh - update report not dataset

    When I want to make changes to a report with incremental refresh, I cannot pull it down from the server. I understand why, as there would potentially be too much data for PBI desktop to handle.
    We have a copy saved on SharePoint, so I would make changes to that and then redeploy. However, at the point of publishing it overwrites the data on the service. The next refresh is then a full refresh. In the meantime, users would not have access to all the data.
    I would like the ability to only make changes to the report, and for…

    2 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  14. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  15. combine settings of multidimensional model in one page

    One of the options in the multidimensional model (see theory) is to indicate a dimension is an ordinal.
    The settings for the behaviours of an ordinal dimension are now scattered all over te place.
    * Modelling - Default summaration = Don't Summarize
    * Graph - Sort by = Ascending
    * Graph - X-axis = Categorical
    * Query editor = Change data type to text (as alternative)
    * Separate table = Sort order by values of other column
    .

    In a separate 'Multidimensional modeling page' the dimension could just be indicated to be 'ordinal' and all the above settings should be…

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  16. Button to remove spaces between text

    Add a button to remove spaces between text in a column while Query editor. We have Trim but this only removes leading and lagging spaces.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  17. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  18. Add row number in matrix/table

    maybe an on/off button to add row numbers

    2 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 Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  19. Change "owner" on shared dataset

    For shared and certified datasets, we would like to be able to change the "owner" information to the data steward of the dataset, i.e. the person who certifies and controls access to the data. Currently the "owner" shows up as the person who published the dataset - which isn't appropriate for production datasets that are published by IT.

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  20. 1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Data Preparation  ·  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.