Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. its really great but we need like real time scenarios to understand in a some more better way.

    i saw the guided learning for dax. its good but if you provde real time projcets examples, that will makes us more meaningful to the sessions

    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 →
  3. allow multi delete for columns in query editor!!!

    don't know why you would do this in excel but not in Power BI!! It took me over 30 minutes to delete columns in ONE report. Not to mention that I have 26 more to go. This is absurd.

    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 →
  4. New measures no longer highlights default "measure =" text to be replaced

    Prior to the most recent update, when a new measure was started, it would highlight the default text in order to allow you to type in the name of the measure you are creating. Now, it just defaults to the start of the DAX calculation and you have to either backspace, or CTRL + A in order to override the default inserted text. Could you please revert back to the way it has always been?

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

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

    5 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. DAX Store

    Create a DAX Store which can hosts some of the commonly used simple to complex scripts. We should also have users to contribute to Store.

    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 →
  8. DAX Store

    Create a DAX Store which can hosts some of the commonly used simple to complex scripts. We should also have users to contribute to Store.

    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 →
  9. cancel refresh

    Allow a refresh that us running in the service, for a dataset to be cancelled (in the same way that a dataflow refresh an be cancelled) this way if a dataset that say usually takes 10 mins to refresh is still running 3 hours later we can cancel it and restart the refresh

    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 →
  10. Multiple connections between databases

    Allow activated multiple connections between databases, with a sort of what to do first. In this way, looking to mirror the possibility that exists in MS Access, which is very useful when working with tables in which the links need to be from more than one field to achieve the waiting result.
    Considering that the PBI identifies connections as filters, there should be the possibility to sequence this process, that is, the user must choose the order of action of the connections.

    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. Ligações múltiplas atividas

    Permitir ligações múltiplas ativadas entre bases de dados, com um ordenamento do que fazer primeiro. Buscando assim espelhar a possibilidade que existe no MS Access, que é muito útil quando se trabalha com tabelas nas quais as ligações precisam ser de mais de um campo para se atingir o resultado aguardao.
    Considerando que o PBI indentifica ligações como filtros, deveria haver a possibilidade de sequenciar esse processo, ou seja, o usuário escolher a ordem de ação das ligações.

    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. Field formatting - more units of measurement

    In the field formatting we are unable to add unit of measurements like days, months etc.

    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 →
  13. Evaluate Excel Cell properties in Power Query of when importing Excel files

    Excel is one of the most widely imported datasources. Table sections a often broken up by a Bold font/ /spaces or tab within the cell for grouping. All this valuable information is lost when importing data from excel into Power Query. It is virtually impossible to import some grouped data without hardcoding all sections through custom transformations, something we would all love to avoid.

    if [myColumn].CellProperties('Font-style') = "Bold", true, false

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

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

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

    31 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. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
  • 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.