Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. calculated column

    Provide the report writer the ability to add calculated columns through the Modeling tab in PBI Desktop, when the report writer has sourced a common data model (Get Data>Powerbi Datasets)

    At current, although the report writer has build permissions to the common data model, they are not able to add a calculated column.

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

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  2. Stop Executing Queries Multiple Times

    I create a query in Power BI Desktop against a data source. Power BI Desktop insists on executing it multiple (usually three) times. This makes Desktop slow and for back-end data sources exerts additional load that can also incur additional costs.

    Note: I am not talking about the scenario where a query is referred to multiple times in M, rather just a simple query loaded into one table in the data model. I assume the engine is checking data types, etc - but the current approach is very slow/painful. Optimisation is needed!

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

    We’ll send you updates on this idea

    9 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  3. Export Column Profiles as a Table

    my customers love the new column profiling feature in Power Query. With the GA today, it is even better. One thing I have been asked for a few times now is the ability to export the column profile data as the result of a query. Ideally this could be exported to Excel for further investigation, or simply return it to ta table in Power BI for further investigation.

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

    We’ll send you updates on this idea

    5 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  4. Group/ Binning with Live Connection

    Provide grouping and binning functionality against live data. In particularly against live data from SSAS Tabular data cubes.

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

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  5. Table.TransformColumns - enable referencing of other columns

    Please enable referencing of other columns in Table.TransformColumns.

    Now when I want to edit values in existing column based on other columns, I have to do 4 steps, because I cannot reference other columns directly in Table.TransformColumns.

    1 - create conditional/custom column
    2 - delete the original source column
    3 - rename the new column
    4 - reorder columns

    If I could reference other columns in Table.TransformColumns, only one step would be needed:

    1 - TransformColumns - condition directly here

    Please consider this request

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

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  6. Tabular Model Both Single Grain (cross filter) vs Multiple Grain (M:1)best chosen based on User Query

    Modeling Kimball conformed stars into one semantic model requires all facts to dimension joins be M:1. even the Junk/drill to detail dimension has to be M:1 from fact to dim. This works exactly as expected to support drill across. Single grain model for one data mart can support cross filter for everything so the use can choose attributes without any metric and is very user friendly. Could we model each data mart as single grain cross filter AND as part of the one larger semantic model and then at run time, PBI uses the single grain when only one measure…

    5 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 →
  7. Conditional batch replace in single step

    Wish to do multiple replaces in a single step similar to the conditional column step.

    Wish to have multiple conditions here too

    EG Value = 'D' where value in Column 2 starts with 'X' and value in Column 3 is 123

    9 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. Add a setting to disable column profiling altogether

    There is no way (as of Jun 2019) to fully disable column profiling. The problem is that complex queries can take a long time to execute and the column profiling header bar at the top of each column can take minute or hours of processing to show the color-coded green bar. All the while, it's eating up database resources and making PQ run slower.

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

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  9. 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.

    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 →
  10. Edit Data Table From Relationship View window

    In the current relationship view window we can delete a data table from the model.

    It would be nice to right click on the data table and click edit query for the underlying table. This would immediately open up the query editor for data table changes.

    Today you have to switch views to the table view, and click edit table. or navigate to the edit queries button and click edit queries. Doing this opens the queries, but you still have to navigate to the table you want to change.

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

    We’ll send you updates on this idea

    3 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  11. 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…

    3 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 →
  12. Skip bad rows at Load stage

    Recently we came with an issue related to wrong formats in data, at Load time if you have bad data you will have an exception and information wont load.
    We need a feature who allows you to skip bad data when you load the information and the option to see rejected records.

    11 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 →
  13. Disable "see records"

    There should be an option to disable "see records" for the graphics that support it. It is a huge issue when it comes to security. I know you can hide certain columns but in reports that should only be high level data, the see records item is really an issue.

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

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  14. Function to calculate working / business days between 2 dates

    Can we have a function similar to Networkdays in excel to determine the net working days between 2 dates. for the list of holiday which will be optional, we can enable it via list or separate table.

    6 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 →
  15. Field formatting multiple data types in a table

    In the field formatting section of a table, allow users to be able to change the data type of the column. Example: I have a custom selected measure that will give the results for both Sales or Units depending the selected slicer choice in a table. I need to have the Sales in currency format and Units in a whole number but cannot have both currently, only one of the other.

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

    We’ll send you updates on this idea

    1 comment  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  16. More evident LOAD/NOT LOAD format in queries list

    It's sometimes hard to spot which of your queries will load and which not. The cursive format is not evident first look and requires a bit of visual 'effort'. Maybe a nice Prussian blue font colour?... but that's my preference ;)

    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 →
  17. 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…

    6 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 →
  18. Excel table with the total line

    Hello,
    If an Excel table has a total row, this table will be imported with the total row in Power BI as an ordinary row.
    Adding this row will cause mistakes in the PBI report and I suppose that the majority of users don't need it in their models.
    I suggest to ignore this row when we import an Excel table in Power BI and Power Query.
    More explanation can be found in the link below:

    https://numidiabi.wordpress.com/2019/07/29/power-bi-power-query-import-table-with-total-line-big-mistake/

    Thank you

    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 →
  19. Data type in Power Query custom column

    In the dialog box that appears when you create a custom column, there should be a drop-down box where we can select the desired data type of the new column. As-is, we have to add a second step specifying data type or manually in the formula bar/advanced editor type ", type text" or whatever; it would be far more convenient to be able to do that right within the dialog box.

    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 →
  20. relationship with wildcards

    Would like to have the functionality that you are able to build a relationship using wild cards, eg:

    Dimension:
    Key: P001*Y2*****GT7777
    Key: P001**************

    FACT:
    Key: P0011Y2H22323GT6543

    The relationship to take into consideration the wildcards so that I can classify a line item to multiple times.

    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 →
← Previous 1 3 4 5 42 43
  • 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.