Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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!

    31 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 →
  2. Modify field properties in Power Query in both desktop and dataflows

    Often when building transformation logic or entire datasets I have already prepared field properties such as descriptions and synonyms. It would be useful to be able to add the properties within a dataflow or dataset so that they properties are inherited from the original Power Query.

    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. Add Week over Week calculation in Time Intelligence Measures?

    As of now I see Month on Month and Year on year calculations but at times we also need Week over Week calculation in Time Intelligence Measures? I think it will be a great value add for people who work on Weekly reports.

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

    We’ll send you updates on this idea

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

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

    We’ll send you updates on this idea

    13 comments  ·  Data Preparation  ·  Flag idea as inappropriate…  ·  Admin →
  5. Set significance / significant figures

    As of today, we can only select the amount of decimals a certain column or measure should have. However, it is often scientifically more useful to set the amount of significant figures it should have.

    2 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. 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.

    24 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 →
  7. Please put subtotal % option in Matrix View

    Hi Team please put subtotal % option in Matrix View

    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. No Undo & Redo Shortcuts

    Please add Undo & Redo Shortcuts like CTRL+Z & CTRL+Y

    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 →
  9. There is no Redo Option/Feature in Applied Steps

    There is no Redo Button. In case I delete a steps in Applied Steps category, i can not redo it so i there is no option left to close the pbix and create all the transformations again.

    3 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 →
  10. 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.

    44 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 →
  11. Allow to save Excel Workbook from Power Query Editor

    When you work from Excel with Power Query editor you can not save the development steps that you have done on queries directly. You always first need to close the Power Query editor window, keep the changes and then save the workbook. After this you need to reopen the editor to continue with the query development work. Why no 'keep changes & save workbook'- button in the editor? Would be a great time saver

    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 →
  12. One Common Function for all tables

    Hi,

    Like other programming languages why don't power BI have one function for all tables.

    Lets say i have 5 tables each table have one column and i am performing some steps on it like removing 2 3 delimiters and then taking some left and right values.

    so this yields 4 5 steps in one query.

    so issue here is again we need to perform those 4 5 step in each 5 tables.

    My idea is why don't we have one function for all and we just need to call that function by providing table name and column name as…

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

    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 →
  14. Group/ Binning with Live Connection

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

    29 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 →
  15. Datasets with RSL

    HI Folks,
    I want to create a Power BI dashboard and also would like users to give access on the datasets been used and published; therefore the members can work on the same datasets been used with out any further making changes of the data.
    However I want the users who would like to consume the data from the Power Bi datasets been published should be able to access as per the roles defined.

    Can you please help me with the feasibility and the necessary steps?

    Thanks
    Kranthi

    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. HI Folks, I want to create a Power BI dashboard and also would like users to give access on the datasets been used and published; therefore

    HI Folks,
    I want to create a Power BI dashboard and also would like users to give access on the datasets been used and published; therefore the members can work on the same datasets been used with out any further making changes of the data.
    However I want the users who would like to consume the data from the Power Bi datasets been published should be able to access as per the roles defined.

    Can you please help me with the feasibility and the necessary steps?

    Thanks
    Kranthi

    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. Option to scroll through list of Column Options from the bottom and top.

    Sometimes the list of options to select from when for instance, you create a new column and the options appear as you type. Once you type two to three letters it minimizes the list of options. But say for instance, the options you have left is quite long and using your arrow keys to scroll through them, takes longer, especially if your option is the very last one on the list.
    Would it be possible to include arrow scrolling from the bottom up as well? This will assist when your option is the last, as 2 arrow commands will result…

    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. Option to append data in table when refreshing instead of replacing.

    Would be great if we can have a feature where table refresh only appends data with the refresh time as a column value.

    Currently append is possible with incremental refresh but this requires a column that contains version details in the source data. This is not feasible for some data sources.

    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 →
  19. Option to define datatype when creating column in Power Query

    Allow users to pick their data type when creating columns via the UI. Currently when you add a column via the UI (for example, the conditional column button) it defines the data type as any. To change this you either have to add another step or if you are comfortable and knowledgeable about M you can edit the create column step in the advanced editor (though if you are comfortable with M you are probably writing the step in the editor and not the UI). By having the option to pick the data type in the UI you can help…

    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. Include Count and count distinct like quick measure

    Count and count distinct, are one of the most tipical measure with data.

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