Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Power Query windows 8

    Have power query work in Windows 8, 10 with UAC enabled so the live tiles and metro apps work!!!

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  2. Power Query should provide analysis of data in a column

    Power Query should provide data on what type of data is in a specific column. For instance if you have a data that has a number of some type it should say " The Column contains decimals out to the 10th place or something along those lines to enable the user to make informed decisions about how to format the data.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  3. Azure Login and Datasource Browsing

    Visual Studio allows those with Azure accounts to sign-in and browse their available objects: SQL Azure DBs, Blob Stores, even Websites. It would be great if this existed in the Designer.

    Today, you have to lookup your Azure server name (non-memorable gibberish like 'axh98pt') for each datasource, then Google for the rest of the URL (its databases.windows.net for SQL Azure). Once you've done that you can proceed.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  4. 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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  5. Re-integrate 3D PowerMap into BI Designer

    There have been some good updates to the new PowerDesigner product, but the inability to generate 3D world maps like in the PowerMap COM Add-in to Excel are missed. Please bring them back in the final product.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  6. copy charts between report sheers

    cut and paste between report sheets in the online Power BI service site - cannot copy a chart and paste it to a new report sheet.

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

    We’ll send you updates on this idea

    0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  7. GCD and LCD Functions or the ability to display ratios as 1:3

    I would like to have either the GCD and LCD functions or the ability to display ratios as 1:3. From a HR stand point for showing gender transparency, being able to show on a report that there is 1 female to 3 males in the workforce would be helpful.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  8. DB connection was disconnected when we have connected Amazon Redshift from PowerBI Desingner with ODBC.

    We have a problem.

    DB connection was disconnected when
    we have connected Amazon Redshift from PowerBI Desingner with ODBC.

    The data-volume is like this:
    Record count: about 50million
    Column count: 35
    data size of one record: about 1K bytes

    We operated the Power BI Desingner as follows.

    ・Run PowerBI Desingner,
    ・Choose [Get Data]
    ・Choose [ODBC]
    ・Choose [My-Redshift-Setting]
    ・Load(Query1)
    ・(We waited about 70mins.)
    ・The process have succeeded,and App change at Query-Tab(Left side bar).
    ・Then, we could see the the first of about 100 records data
    (We are not sure whether we could see all data or not)

    The problem starts from…

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  9. Allow developer to prgrammatically build a powerpivot model

    I'd like to build the model programmatically, or at least from a precreated template.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  10. UI feedback: Improve the download button

    The download button for downloading the tools looks like it's going to download the current dashboard or something. It took me a few minutes of looking for the Designer download before I decided to try clicking the download button.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  11. Better control over large datasets

    Currently, connecting to an online CRM instance with 250k users is completely useless considering it takes 1hour to download contact information. The designer should support smaller datasets while in design mode.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  12. Financial Year Offset month parameter ie: 30Jun

    a parameter that is set for a query once that basically says all date methods and calculations now should work to 30-Jun and not 30 Dec . Date Slicer also should work with this offset.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  13. Include Pivot Table Show Value As Calculations

    It would be great to have the Excel Show Value As calculations from Pivot Tables available in Power BI. This would provide easy access to a wide range of calculations such as - Percentage calculations, Rankings, Running Totals and Difference From without having to figure out PowerPivot calculations.

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

    We’ll send you updates on this idea

    0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  14. Calculated column (Data model) vs custom column (Query)

    Pre-emotively speaking i'm sensing there will be confusion between calculated columns and the custom column you can insert in the query layer. Might be a good idea to contemplate merging these two as just adding a "new column" either from the report view or the query view.

    realise that the underlying language is M and the calculated columns language so it isn't an easy decision. I would pick M only due to the big scripting component behind the scenes of Query.

    Would love to see what others think of this.

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

    We’ll send you updates on this idea

    2 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  15. streaming, incremental or approximate queries for faster manipulation

    Check this
    http://research.microsoft.com/apps/pubs/default.aspx?id=153555
    specially the video sampleAction

    I'm convince that Power BI Designer is the tool for this. and microsoft has the researcher ready...
    this can have a so huge added value.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  16. More insights required when loading a query

    Please download this .pbix: http://1drv.ms/19kbMxs, open it and try and load data into the reports (you will need to create a data source setting for http://sqlblog.com in order to do so). It takes quite a long time to run so please be patient.
    The query attempts to load data from http://sqlblog.com, it does so by getting a list of bloggers from this blogging site, then iterating over them and requesting more information from the site for each one.

    Notice that the last step in the query adds a field called "YearMonth". With this step as part of the…

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

    We’ll send you updates on this idea

    under review  ·  0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  17. include a load to button under the query name in the power query editor

    Inside the Power Query editor window, it would be nice to have a load to button next to it, instead of having to mouse over to the left most of the screen on top to load the data.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  18. Allow arbitrary mapping boundaries

    It would be great if we could somehow load arbitrary boundaries say via GeoJSON or other geospatial format. Then a category could map against the categories in that boundary file.

    For example, maybe we have neighborhood designations that vary or special districts that would be unique across jurisdictions. Rather than try to guess every possible boundary, let us load in the file as related data to map against.

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

    We’ll send you updates on this idea

    0 comments  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  19. Allow the desktop client edit reports on X.powerbi.com

    I have a report I made in the web view, it would be good to be able to edit it in the desktop client.

    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  ·  Desktop  ·  Flag idea as inappropriate…  ·  Admin →
  20. Invoke function as new query

    Let me right-click a function and choose something like "Invoke as" to pass parameters and give a name to a query to be created.

    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  ·  Desktop  ·  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.