Power BI Ideas

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Power BI report shows error when datasource has no record

    when data set(SharePoint list) has no record, on click refresh report from Power BI desktop or refresh dataset from Power BI workspace, it shows error message:Expression.Error: The column 'ID' of the table wasn't found.
    Details:
    ID

    Editor code:
    Source = SharePoint.Tables("https://SiteURL", [ApiVersion = 15]),
    #"f5637e27-9ed1-4276-b244-539e73fafbe4" = Source{[Id="f5637e27-9ed1-4276-b244-539e73fafbe4"]}[Items],
    #"Renamed Columns" = Table.RenameColumns(#"f5637e27-9ed1-4276-b244-539e73fafbe4",{{"ID", "ID.1"}}),

    It should show some message " There is no record." instead of error message.

    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 →
  2. matrix bubble visualization

    We recognize that it is possible to change the color of the cell by the Visual effect of the Matrix depending on the value adjustment. However, we feel inconvenient that it cannot be expressed in the size of "bubble" as like Excel's Conditional format.
    Even though the user can use "R scripts" to modify the size of "bubble" as an alternative way, however, not everyone can create this script easily. Thus, we hope the feature implementation that allows us to the "bubble displays of the cell" as a standard function.

    Thank you for your consideration.

    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. Allow "Create Push Dataset" option when deploying a .pbix file.

    My current customers are by no means IT guys, let alone able to call curl requests, and it seems a little ridiculous to create and register a whole application just to provide them with an easy way to easily deploy a custom, multi-table dataset.

    It would be nice to just be able to provide a fully templated file that will create both the push dataset, as well as the resulting reports and dashboards with one stroke as well as allow rapid multi-table push datasets to be viable.

    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. Two Way Sync on Power BI Service Refresh to Sharepoint/OneDrive

    I have datasets that I author in desktop and then connect to via onedrive in the service and have the datasets set to scheduled refresh in the cloud.

    Often, if I have to make a change/update the existing pbix, I will open the file but it will only contain data from the last local refresh, and therefore won't match the data as of the last service refresh, which isn't a huge problem...

    BUT some datasets can take 20-30 min to refresh locally, which I find I should do before saving the updated dataset, because otherwise, the data as of the…

    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. Don't replace dataset if not needed

    When publishing a report from Power BI Desktop, the dataset is compulsorily overwritten today. If the dataset structure hasnt changed (no new columns or measures added). It should be possible to update without overwriting the dataset.

    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 →
  6. 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 →
  7. Data connectivity mode

    Hi Power BI team,

    Could you please enable the data connectivity mode from Import to Direct Query? Currently, it is only enabled from Direct Query to Import.

    Thank you.
    Rudy

    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 →
  8. Create log scale for X-Axis of Scatter even there is legend

    Create log scale for X-Axis of Scatter even there is legend

    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 →
  9. Measure collections

    I have a number of large Power BI projects that deal with financial information. In order to make the calculations work, I often need numerous measures. As time goes on, I build more and more frameworks that use a series of measures to get to a result in an efficient manner. The down side is that my field listing is bloated with measures making it complete mess.

    I would love to see measures removed from the field listing and placed into a collection with a grouping hierarchy available.

    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 →
  10. Edit column label by DAX

    Currently is posible to edit fields in Table o Matrix, but would be interesting to rename columns by DAX formula. for example, rename column to current month (March 2018) or last month (February 2018), etc.

    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. Bookmark issue

    Bookmark is not working when i add 15 pages. I cannot scrolldown.

    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 →
  12. Vico Office y power BI

    ¿ Alguien ha hecho algo así ?

    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 →
  13. Apply Styling to Row Levels in Matrix

    Inside of Microsoft Power BI please make it so that when using the Matrix Visualizations, we can apply styling to Level 1 of the Row Header that would be different from the sub-levels.

    See the screenshot I provided at https://goo.gl/Bu1Rss. Here "Civilian" which is Level 1 would be bold and the sub-levels "Graduate" and Undergraduate" would not be bolded.

    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 →
  14. Table Matrix Background Color

    Apply conditional formatting on text value.

    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 →
  15. hide

    Ability to keep the visual headers hidden by still allowing an option to export data. The report looks very professional without the visual headers.

    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 →
  16. After clicking 'Select All' in the slicer, select only the clicked item instead of unselecting it.

    In the Slicer tool even though 'Single Select' and 'Select All' are enabled, After the 'Select All' is selected and when the user clicks on another item it deselects the particular item instead of selecting only that item.

    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 →
  17. Be allowed to select text from Power Bi reports

    I would like to be able to highlight/select text from a Power BI report so I can copy/paste it somewhere. For Example. I produce a Power BI Desktop report that shows tickets created in my area. I would like to be able to highlight a ticket number from that report so I can then copy/paste it into my ticket system. I cannot do that so I have to hand type the ticket I see in my Power BI report into my ticket system. Too many errors that way.

    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. Simulate Power BI service memory restriction in Desktop

    As there is a 1GB restriction on memory allowed for queries in the service before you hit a resource governing issue, it'd be good to be able simulate this memory restriction in Desktop so that the report design is done modelled on what is capable when it is uploaded to the service.

    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 →
  19. Security mechanism

    Can we have security at Analysis level as against App Workspace level?

    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 →
  20. Control background image placement on report page

    When I add a background image to a report page in desktop bi, it defaults to middle of the page placement. I can stretch and fill it, but can't control where on the page it appears. Can the ability to display the image where I want on a page be considered?

    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.