This month is a very exciting month for us! We are making several of our most popular connectors generally available, including SAP HANA. Bookmarking is also now generally available, which means you can start creating bookmarks from scratch in the Power BI Service. We are also previewing a powerful feature, report page tooltips, that lets you use visuals in your own custom designed tooltips.
Don’t forget you can now get Power BI Desktop from the Windows Store if you’re running Windows 10!
Here’s the complete list of March updates:
- Report page tooltips (preview)
- Bookmarking is now generally available
- Display units and precision control for table & matrix columns
- Turn off the visual header in reading mode for a report
- Improved default visual placement
- User List by CloudScope
- Timeline by CloudScope
- KPI Chart by Akvelon
- R DataTable
- Outliers Detection
- Data Insights by MAQ Software
- Dumbbell Chart by MAQ Software
- Clustering using OPTICS by MAQ Software
- SAP HANA connector enhancements
- SAP BW DirectQuery is now generally available
- Azure Analysis Services connector is now generally available
For a summary of the major updates, you can watch the following video:
We are very excited to announce the preview of our report page tooltips feature. This feature lets you design a report page to be used as a custom tooltip for other visuals in your report. This gives you full flexibility to design whatever kind of custom tooltips you want, from using cards to show detailed information to miniature drillthrough pages shown on hover.
To start creating your custom report page tooltips, first you have to design the tooltip you want to show. We recommend you use a smaller page size, so you don’t have to worry about the tooltip being too large to show on your normal report pages. We have added a new page size template called Tooltip to use as a starting point, but you can use any page size you want.
While designing your tooltip, we recommend viewing it in Actual size, so you know exactly what your tooltip will look like on hover.
Once you’ve finished creating your tooltip report page, you’ll need to mark the page as a tooltip so we know you want to use it as such.
From here, there are two ways you can start using this tooltip in your report. The first is to tie it to a specific field using the Tooltip fields bucket in the Filters pane. This behaves similarly to the drillthrough fields bucket. Any fields you put into the tooltip fields bucket will be tied to this tooltip. If you use this field in charts throughout your report, this tooltip will be used instead of the default Power BI tooltip. You can put both categorical and numerical fields in this bucket, including measures.
For example, if I put SalesAmount in the Tooltip fields bucket…
That page will be used as a tooltip in other charts using the SalesAmount field.
The other way you can tie a custom tooltip page to your charts is to manually set it. Visuals that support report page tooltips now has a Tooltip card in the formatting pane. In the card, you can set any page that’s marked as a Tooltip page, even if it doesn’t have anything in the Tooltip field bucket, to be the tooltip for this visual. This is useful if you want to design a tooltip to be used for a specific visual.
Another use case is to manually override the automatically selected tooltip if we picked the wrong one to use. For example, in the chart above, if I had one tooltip tied to the Units field and one tied to the Category field (the two fields used to create the chart), we’d pick one of these tooltips to use automatically. If you didn’t like the tooltip we picked, you can use this manual override to pick the other one.
If you manually override the tooltip in this card, you can always go back to our “automatic” selection by selecting Auto in the dropdown list. You can also completely turn the report page tooltips off for a chart using the toggle in the Tooltip card. This will force a chart to use Power BI’s default tooltip, even if there are matching report page tooltips in the report.
There are a couple of other things to consider when building report page tooltips. First, when using these custom tooltips for line charts, you will only get one tooltip for all lines in the chart, as you do today. The field in the legend does not get passed through as a filter on the tooltip. In the example below, the tooltip is showing all units sold on that day across all three classes: Deluxe, Economy, and Regular.
Second, when a chart is being cross-highlighted, the report page tooltips will always show the cross-highlighted data, even if you are hovering over the “faded out” section of the data point. To see the unfiltered data in the tooltip, you will need to clear the highlighting.
This feature is in preview, so you will need to turn it on in the Options dialog (File > Options and settings > Options > Preview features). Currently report page tooltips are not supported when viewing reports in our mobile apps or in embedded environments, including Publish to web. In these cases, we will fall back to Power BI’s default tooltip. Report page tooltips are also not supported yet for custom visuals.
Please try out this new preview feature and let us know what you think!
Watch the following video to learn more about report page tooltips:
Back in October, we released a preview of bookmarking, a powerful feature that can be used for anything from storytelling to app-like navigation. Since then we’ve updated the feature to add more flexibility and we ran a contest that resulted in some pretty amazing submissions. This month, we are very excited to make bookmarking generally available. This means you will no longer need to turn bookmarking on through the Preview feature tab in the Options dialog, and you can now create bookmarks in the Power BI service without needing to first create a bookmark in Power BI Desktop. This also means that all the custom visuals that are published by Microsoft on AppSource support bookmarking. Other visuals in the marketplace are in the process of adding support to bookmarking.
Our formatting improvement this month is an improvement for table and matrix field formatting. For numerical values, you can now control both the display units and decimal places per column similar to what you can already do for data labels on charts. This setting will override any model-level formatting set for that field.
Watch the following video to learn more about display units and precision in table and matrix:
Frequently, if you are embedding your published report, especially if it is in a webpage, you don’t want or expect your users to do many of the actions that currently show in our visual header, such as opening the visual in focus mode or drilling down. If this is the case, we now have a way to completely disable the visual header for your entire report when it’s viewed by consumers.
To turn off the visual header, you can check the Hide the visual header in reading view box in the Report settings section in the Options dialog. Once you’ve done this and published, you will no longer see the header for any visuals in your report when it’s being consumed. This includes Reading mode in the Power BI service, Publish to web reports, and any other embedding experience. Note that you will still see the header in Power BI Desktop (since it’s always in edit mode) and when editing the report in the Power BI service.
Watch the following video to learn more about disabling the visual header:
We’ve made some improvements to where we are placing visuals by default when you create them. You should notice that the automatic placement is now more logical and does a better job of filling in gaps that are available around already existing visuals.
Watch the following video to learn more about the improved visual placement:
Mapbox provides mapping and location tools for business intelligence. Their maps, search, and navigation APIS and SDKs seemlesly integrate into data visualization platforms like Power BI or can be extended to create custom dashboards or analytics tools.
With the Mapbox Power BI custom visual, Mapbox brings five powerful features for visualizing data with maps to Power BI:
- Multiple visual types that allow you to choose from heatmaps, graduated circle maps, and cluster aggregation maps all within one visual
- Vector maps that help you filter and understand big, dynamic data with tens of thousands of data points rendering at 60 frames-per-second
- Custom map design tools that allow you to control every element of your visualization, from color, to size, to min and max zoom
- Upload most types of custom map data from shapefiles, KMLs, to imagery GeoTiffs and drop them in your dashboard as a custom map style
- Use cluster aggregations to understand spatial trends way beyond density by styling clusters based on a measure sum, min, max, or average value
These features enable you to arrange and visualize data in new ways to help you understand your data better, all while leveraging Power BI’s infrastructure to uncover new insights.
To create this visual, you will need a free Mapbox account. As of now, you’ll get 50,000 map views free per month, then you’ll be billed for overages at $0.50/1,000 map views. You can always see the latest pricing information on Mapbox’s pricing page. Only the report creator will need an account, and anyone can view an existing visual.
Watch the following video to learn more about the Mapbox custom visual:
User List by CloudScope is a specialized grid-style visual that allows you to display data about users, organizations or other data elements. You can view this list in either a compact or expanded format depending on your presentation needs. You can also cross-highlight other visuals when selecting on an item in the list.
The compact version of the visual can display:
- Verified status
- and any number of generic data fields
The expanded list adds:
- Background photo
Get this visual on AppSource.
Watch the following video to learn more about the User List by CloudScope custom visual:
The Timeline by CloudScope visual displays a list of social data information in a format similar to a Twitter timeline. You can create this visual by providing up to seven fields from your data model:
- User picture
- User name
- User screen name
- Created date
This will create a timeline visual you can use to integrate social media information into your report. Each status item in the timeline can be used to cross-highlight other visuals on your report page.
There is also an enhanced version of this that you can create by providing a property collection called TweetJson, which will allow you to display embedded tweet media, author verified status and distinguish between different tweet types (tweets, retweets, replies and quoted tweets). You can learn more about TweetJson on CloudScope’s website.
Watch the following video to learn more about the Timeline by CloudScope custom visual:
KPI Chart by Akvelon is a single visual for visualizing and analyzing the correlation between two measures. It combines a line chart and a column chart with the same X axis to show a representation of the distribution of numerical data. Additionally, KPI Chart by Akvelon allows you to show static and dynamic background KPI regions that can characterize, for example, the level of success before reaching the target. This chart is simplified version of the standard Line and Clustered column chart with the added ability to create multiple lines and add horizontal regions to assess progress.
View the visual on AppSource.
Watch the following video to learn more about the KPI Chart by Akvelon custom visual:
The R DataTable by David Eldersveld is an interactive R-powered table that helps you easily explore and filter data.
Some of the benefits of the R DataTable include:
- Search – Global search field to filter data across all columns
- Pagination – Use "Show # of entries" to choose between 5, 10, 25, 50, 100, or 1000 records to display per page
- Column-level filters – Conveniently filter column values using the option below each column header
Some of the format options include:
- Initial Entries – Choose the default number of entries/records per page
- Filters – Choose where to position the column filters (Top, Bottom, None)
You can find the visual on AppSource.
Watch the following video to learn more about the R DataTable custom visual:
Use the Outliers Detection to find outliers, a data point a significant distance from most other points, in your data using the most appropriate method. This can help you find measurement errors or indicators of important occurrences or events. One such example is fraud detection, where outliers may indicate fraudulent activity.
There are many different methods to detect outliers, and in this custom visual you can use five of the most popular detection methods:
- Zscore – a standard deviation approach
- Tukey’s method – a interquartile (IQR) range approach
- LOF (Local Outlier Factor) method – computes the local density deviation of a given data point with respect to its neighbors. It considers samples that have a substantially lower density than their neighbors as outliers
- Cook's distance – shows the influence of each observation on the fitted response values. An observation with Cook's distance larger than three times the mean Cook's distance might be an outlier
- Manual method – allows you to define your own upper and lower thresholds for the original data
In addition to the different detection method, the visual also supports three ways to visualize outliers:
- Scatter plot
- Box plot
- Density plot
For each plot type, you can decide to visualize the original data or outlier scores.
Check this visual out on AppSource.
Watch the following video to learn more about the Outliers Detection custom visual:
Data Insights by MAQ Software allows you to view data in multiple formats. You can switch between a horizontal bar, a vertical bar, a brick, or a tabular format. With Data Insights by MAQ Software, you can easily explore, select, and view selected data in the format that best fits your individual business needs.
You can download this visual from AppSource.
Watch the following video to learn more about the Data Insight by MAQ Software custom visual:
The Dumbbell Chart by MAQ Software displays critical measures and shows changes over a duration or across categories . The Dumbbell Chart helps you analyze changes in critical data. This visual is an excellent choice for illustrating the change between two data points and comparing the distances between them. The visual consists of a dual-axis combination chart, where one axis is marked by a circle and the other is marked by a line that spans data points you provide.
Key features include:
- The ability to display the performance of multiple indicators.
- The ability to compare the growth or loss of indicators across various categories.
- Easy interaction with many data points using the zoom functionality.
- Quick downloading of an image of the chart with the capture image widget.
Watch the following video to learn more about the Dumbbell Chart by MAQ Software custom visual:
The Clustering using OPTICS by MAQ Software visual uses the OPTICS based clustering algorithm to analyze groups and hierarchies within a group. The algorithm works on density-based clustering, so you can also identify individual points that don't belong to any of the groups. You can perform hierarchical clustering on your data to identify more closely-knit groups within larger groups. This visual also allows you to adjust the clustering parameters to control hierarchy depth and cluster sizes.
Key features include:
- Ability to identify outliers based on convex hull plots
- Data is scaled and pre-processed automatically so no need to do so externally
- Add your own dataset for tooltips
- Ability to identify sub clusters/hierarchal clusters in your data
- Ability of hover tooltips and zoom effects
- Capability to manually adjust the parameters of the clustering model
- No need to define the number of clusters
Watch the following video to learn more about the Clustering using OPTICS by MAQ Software custom visual:
This month we’re making a couple of enhancements to the SAP HANA connector:
Last month we released a preview of the new SAP HANA DirectQuery multidimensional connector. A few weeks ago, we enabled Power BI Service support for the connector (via the On-premises data gateway February update). This month we are glad to announce that the new DirectQuery multidimensional connector has hit general availability. Note that you can still opt into using the DirectQuery relational connector by enabling the option under “File -> Options and Settings -> Options -> DirectQuery -> Treat SAP HANA as a relational source”.
In this release, we’ve enhanced support for connecting to SAP HANA servers with SSL encryption by surfacing the SSL Certificate Validation options in the Power BI Desktop Credentials prompt. Note that you may need to remove or edit already stored credentials for a given SAP HANA server that you connected to before in order to leverage these new options. Support for these new options will become available in the Power BI Service (via On-premises data gateway) in one of the next few Gateway updates. Stay tuned!
You can learn more about our SAP HANA connector in our documentation.
We’re announcing general availability of the DirectQuery mode for SAP BW, which was introduced as a Beta feature a few months ago. Thanks everyone for your feedback during this Beta period, which helped us enhancing the connector and getting it into GA status. For this connector, it is important to discard existing preview DirectQuery reports. Errors will occur on old reports when you try to refresh the report.
You can learn more about our SAP BW DirectQuery connector in our documentation.
Another connector becoming GA in this month’s release is the Azure Analysis Services connector. We want to thank all of you for the feedback and encourage you to continue using this connector as it becomes generally available.
If you ever get an error while using Power BI Desktop, you’ll no longer see the old send-a-frown experience where you email us the information. We’ve upgraded our error reporting experience to use Windows Error Reporting. Now whenever you hit an error, you’ll be able to send us the information directly through this new error dialog. In addition to being able to submit errors in Power BI Desktop directly, another benefit of our move to Windows Error Reporting is that you now have a centralized place to see and search all your Windows diagnostic data that you've reported to Microsoft, which you can learn about in the Windows privacy blog.
Since we are now using Windows Error Reporting, you can also view any errors you’ve previously encountered while using Power BI Desktop. To do this, search for ‘problem reports’ in your start menu.
If you select View all problem reports, you’ll get a dialog showing all your errors and you can double click any issue in the list to view the details that were sent to Microsoft, including any screenshots.
If you chose to not submit a report initially, you can always get all the information from here to send to our support team later, if needed. Just click View a temporary copy of these files and save anything you need to send to our support team.
That’s all for this month! We hope that you enjoy these updates and continue sending us your feedback. Please don’t forget to vote for other features that you’d like to see in the Power BI Desktop.