Power BI Ideas
-
Python Script in Power BI
It's great that Power BI already has the capability to run R scripts for data transformation. It would be even better if we could run Python script.
2,275 votesAnd now the preview is out! Read about our various integration points for Python here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2018-feature-summary/#python
We’ll close out the idea once we make the experience generally available in the coming months.
-
Control which bookmarks are viewable in the service
This idea has come about from the introduction of personal bookmarks in the PBI Service: https://powerbi.microsoft.com/en-us/blog/announcing-personal-bookmarks-in-the-power-bi-service/
Many report creators use bookmarks as a dynamic way of showing/hiding visuals, or navigating between tabs. Exposing an end user to these bookmarks could be confusing for them and expose the underlying workings of the report.
Personal bookmarks are great, but an option in PBI Desktop to expose certain bookmarks in the PBI Service would satisfy both report creators and consumers.
31 votes -
Hierarchy Slicer Sync
I tested the "Sync Slicers" it's a very good option but it doesn't work with Hierarchy Slicer, it will be very important to synchronize pages of report's with hierarchical slicers like Hierarchy Slicer.
333 votes -
Allow non-admins to see enterprise gateways in dataflow creation
According to my experience and the documentation, only admins of enterprise gateways can see gateways during the dataflow creation process. Can this not be opened up to report authors as well? Our enterprise gateway is controlled by IT and has one or two administrators. "Self-service ETL" won't be realized unless report authors can create dataflows using the enterprise gateway.
47 votes -
Click and Drag to Select Multiple Objects and Allow Nudge
Similar to the other Microsoft products, it'd be great if we could click and drag the mouse to select multiple object on a page. Then, once multiple are selected, allow us to nudge them with the arrow keys all at the same time. Right now, we have to click one at a time and nudge one at a time. Oftentimes, I have many items I've already spent time aligning and then I need to nudge them and I have to do it one at a time.
143 votes -
One single schedule task for sequential refresh of both Dataflows + Dataset
The biggest thing that I’m missing is the ability to schedule a Dataflow, plus a Dataset (without Premium capacity). Now you can schedule both separately, but not in an automated sequential way.
https://ssbipolar.com/2018/11/24/whats-missing-from-power-bi-dataflows/
44 votes -
copy data to clipboard
Copy Data to Clipboard should be a simple right-click context menu capability --- as it has been in Tableau for years. Often, user wants data being displayed without going through export to CSV and import into Excel. Just simple copy-paste of data out of visual to clipboard to ... whatever intended ... is extremely useful.
411 votes -
Protect .PBIX with password
Allow to protect a pbix file with a password.
67 votes -
Rename publish to web
The publish to web feature, while useful, leads to confusion around those new to platform and possibly non native English speakers. The terminology "publish to web" can be confused by instructions to publish report from desktop to web service, which is fine. Publish to web exposes sensitive business data if author is not careful. While there is a secure option that will be coming soon, I propose renaming the feature to "Publish to Public". The term public is a bit clearer as to the audience. Alternative option could be "publish to public web", just something to allow users/businesses to clearly…
35 votes -
Gateway Usage monitoring tools for Power BI Service
As Power Bi and other applications in the Power Platform become more prolific within the BI Cloudscape and Landscape integration, gateways will become used more and more. Having visibility to the capacity of a gateway, the volume of traffic through the gateway, which datasources are used more frequently than others, which types, etc would be a very useful resource to have within the Gateway management system.
105 votes -
IntelliSense Should Use Best Practice Column and Measure Naming Conventions
There is a clearly defined and accepted best practice for referencing columns and measures in the DAX language.
1. Column names should ALWAYS reference the table name.
TableName[Column Name]
2. Measures should NEVER reference the table name.
[Measure Name]This is a fundamental concept accepted by everyone with knowledge of the DAX language (everyone I know anyway).
IntelliSense in DAX sometimes follows this convention and sometimes it does not. I have created a short video (40 seconds) showing 3 examples. https://youtu.be/CvaRhKrnHRk
There are other places where column names are appended to measure names too, such as inside Quick Measures, and…
309 votes -
Interactive Python Visuals
I know Python Visuals have just been supported for Power BI, but lets get the ball rolling on this one.
Please support Visual Interactions with Python Visuals.
81 votes -
(Real) Dual axis charts
It would be nice to be able to create dual axis charts and not the combo chart, to be able to drop more than one value on an axis and synchronize those axes. It would also be good to be able to control the type of mark in this instance so you could have one bar and one hash mark. Stephen Few would be happy cause we could create bullet charts (yeah those custom visuals really don't work and have bugs)
116 votes -
matrix data export to excel
Matrix data is exported to excel in tabular format. It is a lot of rework to again pivot it in excel. We want a visual matrix to be exported to excel as a matrix/cross tab.
same is for charts. we dont want just the underlying data. When exporting to excel from Powerbi Service, we want it to be exported as-is with all the visuals.
So many posts on this topic and no answers so far.92 votes -
Improve Relationship Drag and Drop Experience
In Power Pivot for Excel, when you drag and drop columns to create relationships, there experience is:
1. Click and drag source column
2. Hover over destination table
3. The receiving column on the destination table is highlighted to indicate which column will receive the join.In Power BI Desktop, item 3 above is missing. It makes it ambiguous how the join will be made (and a poor user experience). Please add a visual confirmation to the user which column will receive the join during drag and drop.
421 votes -
Allow Slicers to be preset based on defined criteria
Allow Slicers to be preset based on defined criteria (i.e. DAX formula or other developer input).
For example, a dashboard that displays KPI data based on the current week end date. On displaying the dashboard the screen should default to the current end date with the user having the optional ability to set the date slicer for previous weeks.
At a stretch you could have a button with a bookmark action to run some DAX that could set the date slicer to the latest end date.
Taking this further you could also reverse and forward the slicer to the next…
102 votes -
Export to PowerPoint with individual image elements
Currently, the Export to PowerPoint feature exports one image file per report. Update the Export to PowerPoint feature to support exporting an image per report visual instead.
656 votes -
Key Influencers over time
Key Influencers evolution over time.
The new Key Influencers visual does a nice job to understand the contribution of different factors in a given population. If the evaluation is performed over a given period, it is likely that some factors produce a different influence over time, i.e. the mix of factors/influencers tends to be more dynamic than static over time. For example, in a mix of products at different stages of their lifecycle, it is not uncommon to see new products behaving differently to products that initiate their decline. In other cases, some factors have a significant influence triggered by…22 votes -
Rename fields on the new filter pane
Ability to rename fields on the fielter pane just like on visuals
40 votes -
Export to PDF needs to include all rows in a Table or Matrix visualization
The new feature Export to PDF appears to be just a screen capture of each report - whatever is currently being shown on the screen is what is captured in the pdf. When a report has a Table or Matrix visualization on it with rows that scroll beyond what is shown, these are not captured in the pdf. Need to have all the data show up in the pdf.
84 votes
- Don't see your idea?