This month’s update for Power BI Desktop filled with both small and large improvements across the entire product.
See complete list of October updates at end of this post.
Get PBIX here.
My picks:
Data connectivity - Web By Example connector is now generally available
The Web By Example connector was released a few months ago as a Preview feature. With this month’s release of Power BI Desktop, we’re making the connector GA.
Please note that in order to be able to refresh datasets that leverage this connector in the Power BI service, you will need to upgrade to the October release of the On-premises data gateway.
Data preparation - Data Profiling in Query Editor (preview)
The Power Query Editor offers hundreds of data transformations for you to transform, filter and prepare your data for analysis. However, identifying quality issues such as errors, empty values and outliers can be quite difficult.
With this month’s release of Power BI Desktop, we’re adding Data Profiling capabilities into the Power Query Editor, allowing you to easily identify errors and empty values in your data previews. You can enable Data Profiling from the Preview features tab in the File -> Options dialog.
After enabling the feature, you should be able to see the quality bar below the column headers indicating whether there were any error values found or not.
Analytics - Explain the increase for non-additive measures
Power BI's ‘Explain the increase’ and ‘Explain the decrease’ insights questions are now available on all measure types, not just sums and counts! It works the same way as it did for sum and count measures, so from a visual, just right click on a point and select Analyze > Explain the increase.
The visuals you get back will depend on the type of measure you are using. You will continue to get the waterfall chart showing the breakdown for additive measures (sum and count). For measures that are averages or ratios, you will see a dot plot visual, and for everything else, you will see a clustered column chart. No matter what, they will all be geared to answering the question you asked: why did this measure’s value increase or decrease.
Complete list of October updates
Get PBIX here.
Thank you for reading...
See complete list of October updates at end of this post.
Get PBIX here.
My picks:
- Data connectivity
- Web By Example connector is now generally available
- Data preparation
- Data Profiling in Query Editor (preview)
- Analytics
- Explain the increase for non-additive measures
Data connectivity - Web By Example connector is now generally available
The Web By Example connector was released a few months ago as a Preview feature. With this month’s release of Power BI Desktop, we’re making the connector GA.
Please note that in order to be able to refresh datasets that leverage this connector in the Power BI service, you will need to upgrade to the October release of the On-premises data gateway.
Data preparation - Data Profiling in Query Editor (preview)
The Power Query Editor offers hundreds of data transformations for you to transform, filter and prepare your data for analysis. However, identifying quality issues such as errors, empty values and outliers can be quite difficult.
With this month’s release of Power BI Desktop, we’re adding Data Profiling capabilities into the Power Query Editor, allowing you to easily identify errors and empty values in your data previews. You can enable Data Profiling from the Preview features tab in the File -> Options dialog.
After enabling the feature, you should be able to see the quality bar below the column headers indicating whether there were any error values found or not.
Analytics - Explain the increase for non-additive measures
Power BI's ‘Explain the increase’ and ‘Explain the decrease’ insights questions are now available on all measure types, not just sums and counts! It works the same way as it did for sum and count measures, so from a visual, just right click on a point and select Analyze > Explain the increase.
The visuals you get back will depend on the type of measure you are using. You will continue to get the waterfall chart showing the breakdown for additive measures (sum and count). For measures that are averages or ratios, you will see a dot plot visual, and for everything else, you will see a clustered column chart. No matter what, they will all be geared to answering the question you asked: why did this measure’s value increase or decrease.
Complete list of October updates
Reporting
- Search in filter cards
- Improved accessible authoring experiences
- Performance improvements for ArcGIS Map
Modeling
- DAX editor improvements
Analytics
- Composite models & Aggregation support in the Power BI service (preview)
- Explain the increase for non-additive measures
Custom visuals
- Mapbox updates - 3D extrusion on fill maps & more
- Various bar & column chart visuals by Akvelon
- 3AG Systems – Column chart with small multiples
- 3AG Systems – Bar chart with absolute variance
- 3AG Systems – Column chart with relative variance
Data connectivity
- Web By Example connector is now generally available
- SAP BW Connector implementation v2 is now generally available
- SAP BW Message Server Connector is now generally available
- Vertica connector is now generally available
- Dynamics NAV and Dynamics 365 Business Central connectors are now generally available
- New Dynamics 365 Business Central On-premises connector
Data preparation
- Data Profiling in Query Editor (preview)
- Fuzzy Matching options for Merge Queries (preview)
Other
- Control export data options for your reports
- Transport layer security settings
Get PBIX here.
Thank you for reading...
