Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Save CSV via r script run in power query in power bi service

    I have an r script to exports a staging query of historical data to CSV. This works fine in power bi desktop. It would be great if this was capable once published. Currently get zero errors, however no export to be found.
    I am trying to use this to retain past power bi refresh history as the API is only returning recent results.

    13 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. Query mode QoL: Add name of new column in applied steps

    Instead of using the generic "Added Custom" or "Added Conditional Column", rather insert the column name to make it easier to navigate through the step logic.

    For example if I add a conditional column called Turnaround time, it is far more useful for me to see that I added Turnaround time than for me to see what type of column I added.

    It saves time that is waste having to manually rename those steps and also means that if one of my colleagues works on the model, they can easily identify important items without having to go through every addition…

    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 →
  3. Add the date format 'yyyy-mm' in PBI Modeling

    To display a date in PBI visuals, the format year-month (yyyy-mm) is really useful. This one we are missing in the current selection of date formats.

    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 →
  4. Text wrap the display within Advanced Editor

    Text wrapping on a line-by-line basis within Advanced Editor. Currently you have to manually enter a carriage return and tab it over to format.

    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 →
  5. 在网页版的数据刷新的时候加上一个暂停刷新的功能

    建议在网页版刷新的时候加上一个暂停刷新功能

    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 →
  6. Half yearly growth

    Similar to QOQ, YOY, MOM growth, It would be helpful to compare 6 months growth

    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. COUNTIF in DAX Language

    A COUNTIF is sorely missed in DAX.

    (The workaround with CALCULATE and FILTER is too cumbersome and complex for most users)

    6 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 →
  8. Calculated columns on Dataflows and Datasets in service

    When the size of the data is small, connecting PowerBI Desktop to an existing dataset/ dataflow is easy.
    The problem arises when the size of the dataflow/dataset becomes big. It is frustrating and the program crashes a lot due to the size of the dataset.
    Everytime a business user asks for a new column, I have to download the whole dataset, add the calculated column and then re-upload 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 →
  9. Milliseconds incorporated into date datatype and functions

    Milliseconds incorporated into date datatype and functions

    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. Change data types and other formatting functionality with SAP HANA DirectQuery

    The SAP HANA DirectQuery does not support data prep features like changing data types as well as other formatting changes. Without the ability to prep the SAP HANA data with DirectQuery, there is no way to leverage SAP HANA's real-time data capability. Thus, whenever a user needs to change data, they are forced to use Import (a static data set).

    8 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 →
  11. invoke custom function on row

    Please add support for applying Invoke Custom Function to an entire row. Currently the UI shows the filter source as Any or Individual column. Please add Row as an additional filter source option. The resulting M lang would be
    = Table.AddColumn(someTable, "new col", each someFunction(_)), where someFunction needs the entire row as input.

    Without this capability, a user must use Advanced Editor to provide the row as input to my function.

    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. Select all option in data tab and query editor

    While formatting data we need select one row/column at a time. instead of this multiple selection should be available. It will speedup the process.

    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. Select all option in data tab and query editor

    While formatting data we need select one row/column at a time. instead of this multiple selection should be available. It will speedup the process.

    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. Time Function to Bring Time to Date or time for the day/Date

    It would be good to bring a function of Time so that It can bring data of time to date, Example: If a date is selected with time then that data or records of the selected time till 12:00 AM of the day should be displayed like it happens with YTD, MTD.

    If we select a record 30-01-2019 14:00, It should bring up all the records for that day starting from 30-01-2019 12:00 till 30-01-2019 14:00

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

    Report consumers (department leaders) are asking for the ability to drill down into transactions. This is not currently possible as transactions are not part of the content pack. Account transactions should be included in the content pack.

    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. Get Path Current File location

    Change Dynamic Path Data Source
    When import data from Folder change dynamic Path Based On Current Path of Pbix File.

    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 →
  18. PDF connector

    PDF connector - LOVE IT. Add the ability to apply same transformations to multiple pages / tables.

    1 vote
    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 →
  19. M Intellisense for functions but also for PowerQuery Excel

    Intellisense is great, but why not for functions? It would be great to have it also in Excel PowerQuery

    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 →
  20. random data sample power query

    Enable an import of a random sample from a data source into Power Query.

    When loading the top 1000 rows, this tends to obfuscate data types and issues that may be in columns further down, especially when dealing with historical datasets with columns added at later stages and older data predominantly contains null values in these columns.

    It also masks the opportunity for proper transformation due to the lack of values.

    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 →
1 2 5 7 9 41 42
  • 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.