Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Welcome to the February 2022 update. We are thrilled to announce a variety of new and highly anticipated features such as new mobile formatting options, Dynamic M Query Parameters support for more data sources, deployment pipeline enhancements and improvements to downloading a PBIX file. There is more to explore, please continue to read on.
Over the past several months weโve been working to make it possible for you to format visuals in mobile layout, and to have those formatting changes affect only the mobile-optimized view. Today as part of Power BI Desktopโs February update we are thrilled to announce the public preview of this major improvement to the mobile-optimized report authoring experience.
To enjoy the new mobile formatting experience, please switch on the โModify visuals settings for mobile layoutโ preview feature (File > Options and settings > Options > Preview features > Modify visuals settings for mobile layout).
For more details about the new capabilities, check out the full blog post here.
Power_BI_February_2022_Feature_Summary
Screenshot_of_lineage_view_illustrating_downstream_inheritance
For example, when a label is applied to the dataset โCustomer profitabilityโ, that label gets applied to the datasetโs downstream content.
Sensitivity label downstream inheritance in Power BI - Power BI | Microsoft Docs
Default labeling applies when you create a new file in Power BI Desktop or a new dataset or report in the Power BI service. The default label is set automatically on the new file or artifact, without interfering with your workflow.
Power_BI_February_2022_Feature_Summary
Default label policy in Power BI - Power BI | Microsoft Docs
Power_BI_February_2022_Feature_Summary
Power_BI_February_2022_Feature_Summary
If you need to turn this preview off, you can find the preview switch from: File > Options and settings > Options > Preview Features > New format pane. Please submit your feedback directly in the comments of this blog post or add to the discussion via our new โshare feedbackโ link next to the preview switch so we can continue to improve!
Power_BI_February_2022_Feature_Summary
Improvements added this month include:
You can now select rows in your multi row card to cross highlight and cross filter the other visuals in your report! Unselected rows will dim to help you identify which rows you have selected, and you can ctrl or shift click to select multiple rows at once. This brings interactivity in multi row cards closer to parity with our other visual offerings.
UPDATE: This feature did not ship in the February 2022 release. It will be coming in the March release instead.
To learn more about the feature, check out our documentation or video demo.
Amazon OpenSearch Service now supports integrating with Microsoft Power BI, a business analytics service that delivers insights to enable fast, informed decisions. Powered by the OpenSearch ODBC Driver you can now integrate your Microsoft Power BI environment with your Amazon OpenSearch Service domains using the OpenSearch SQL Engine.
The OpenSearch SQL Engine uses Structured Query Language (SQL) to manifest search results in a tabular format. One of the key features of this engine is the Open Database Connectivity (ODBC) driver which enables you to integrate various business intelligence (BI) and analytics applications with OpenSearch. You can now connect Amazon OpenSearch Service with Microsoft PowerBI to create sophisticated and intelligent data visualizations on top of the search results obtained from Amazon OpenSearch Service by leveraging the PowerBI Integration, to provide data insights.
Amazon OpenSearch Service PowerBI integration is powered by OpenSearch, an Apache 2.0-licensed project.
OpenSearch project now supports integrating with Microsoft Power BI, a business analytics service that delivers insights to enable fast, informed decisions. Powered by the OpenSearch ODBC Driver you can now integrate your Microsoft Power BI environment with your OpenSearch project using the OpenSearch SQL Engine.
The OpenSearch SQL Engine uses Structured Query Language (SQL) to manifest search results in a tabular format. One of the key features of this engine is the Open Database Connectivity (ODBC) driver which enables you to integrate various business intelligence (BI) and analytics applications with OpenSearch. You can now connect OpenSearch with Microsoft PowerBI to create sophisticated and intelligent data visualizations on top of the search results obtained from OpenSearch by leveraging the PowerBI Integration, to provide data insights.
OpenSearch project PowerBI integration is powered by OpenSearch, an Apache 2.0-licensed project.
We are very excited to release the first version of the Digital Construction Works (DCW) PowerBi Data Connector! This connector works with data from your DCW Integrations Platform Organizational and Project Data Warehouses. It enables you to query all of your project data via one single source and build impressive visuals and reports. Hereโs how:
Power_BI_February_2022_Feature_Summary
The DCW Insights connector works using a standard OData V4 connection to your DCW Platform API subscription. This connector allows you to query your project data via one single source. Simply enter the project URL in the connectors configuration screen and click OK.
Power_BI_February_2022_Feature_Summary
Secondarily, enter in your unique platform project API key to securely connect to your project. Data will be returned, and you will be able to build impressive visualizations and reports at your leisure. Refresh your reports automatically, keeping your construction and project scheduling dashboards up to date. We hope you enjoy using the connector and value any feedback! Please visit our website for more information on the DCW Integrations Platform.
What's new in BQE CORE Connector 3.0?
Access to the budgetId field in Projects, which allows you to identify the budget linked to a project.
Connector version: 2.4.5 Bug fixes/improvements:
Added support for OIDC authentication
Fixed issue with path detection on Power Bi online when โ/โ was not added at the end of MicroStrategy REST API URL.
Broken catalogs are ignored when connecting to SEP or Starburst Galaxy. Previously, if any catalogs were broken the whole connection would fail.
Goal assignment notifications
Goal assignment notifications are sent when an owner is assigned or changed for a goal. The goal owner receives a Teams notification from the user assigning the goal if they have the Power BI app for Teams installed. Theyโll get a notification right in the activity feed and as a banner (toast card). When they click the notification, the scorecard opens and the Details pane for the goal is shown. This notification will help users be aware of the goals that are assigned to them immediately, without relying on someone to tell them what scorecard their goals are on.
Power_BI_February_2022_Feature_Summary
Power_BI_February_2022_Feature_Summary
Notifications for mentions
These notifications help users get someoneโs attention on a goal without having to leave the scorecard by tagging them in a note. When a user is @mentioned in a note on a new or existing check-in, they get an activity feed notification from the note creator, which opens the Details pane showing the note.
Power_BI_February_2022_Feature_Summary
Status update notifications
This notification helps users get an immediate notification when the status of the goal gets updated by an automated status rule, so they donโt have to rely on checking their goals in the scorecards. The owner of the goal gets an activity feed notification from the user who configured the data connection in the case of connected goals or the user who edited the value in the case of manual goals.
Power_BI_February_2022_Feature_Summary
Note that you need to have the Power BI app for Microsoft Teams and the recipient needs to have access to the scorecards to get these notifications. Read the documentation to learn more. We are working on other Teams notifications as well as emails and Power BI mobile notifications. If you have any requests for specific notifications youโd like to see, please share in the comments below.
One common request we got from our users is the ability to add multiple owners to a single goal. You will now be able to do just that by typing additional names in the owner field of a goal. You can add up to five owners. These additional owners will also work seamlessly with notifications and Power Automate integrations.
You will now be able to create scorecards in My Workspace in Power BI, making it easier than ever to create and keep personal scorecards and share them out when theyโre ready. Free users can author scorecards in My workspace, but a Pro license is required to share them.
Previously, you were not able to download a .pbix file for reports when the report connected to a single dataset and that dataset was configured for large models, incremental refresh or had been modified by using the XMLA endpoint. Starting with this release, that limitation has been partially removed and we plan to make more improvements in the future.
Specifically, starting with this release you can download a .pbix file for reports, that meet the following requirements:
Please refer to our documentation for more information and an up-to-date overview of considerations and limitations. We have more improvements planned, so stay tuned for more updates in this space.
Power_BI_February_2022_Feature_Summary
You can choose between the light and dark themes in the appโs appearance settings, or you can leave the setting as โSystem defaultโ, in which case the app will use whatever theme your operating system is using.
Power_BI_February_2022_Feature_Summary
Power_BI_February_2022_Feature_Summary
Until now, Power BI dataset was not supported as a datasource for those scenarios, and now weโre enabling it.
When embedding a paginated report with a Power BI dataset as a datasource for the embed for your customers scenario, you need a service principal and a multi-resource embed token, that contains a new parameter called โXMLA permissionsโ. Using this parameter, ISVs and customers can control the access to XMLA endpoints with the embed token. For allowing embedding of paginated report with a Power BI dataset as a datasource a "Read Onlyโ value is required.
Power BI datasets with datasources that require single sign-on (SSO) are not supported yet, but thatโs coming soon.
Self-service purchase of A7 and A8 in sovereign cloud will be enabled later this year.
The APIs that are currently supported are PUT and POST.
The POST API allows you to grant new permissions to a dataset. It requires having read and reshare permissions for the dataset, and all the permissions you wish to grant. Keep in mind that the POST API cannot be used for deleting permissions, and that calling the API with permissions which the target already has will have no effect.
The PUT API lets you update the targetโs permissions to a given dataset. It requires having read, write and reshare permissions for the dataset, and all the permissions you wish to update. The PUT API cannot be used for changing write permissions or any folder level inherited permissions. This API also supports removing all permissions for a dataset for a given target.
Click here for more information, examples, and limitations.
With this new configuration, all you need to do is provide the token generating function, and the rest will be taken care of automatically so that your users will get a fluent and continuous experience.
Learn more about this here.
Please note that you can tag a visual with up to two categories from the list. If your visual was previously tagged with a category that has been removed, update your visual with a new one.
The new categories are:
"objects": {
"general": {
"properties": {
"formatString": {
"type": {
"formatting": {
"formatString": true
}
}
}
}
},The sample report demonstrates what the visual looks like and how it can be used. It can also include useful comments, tips, and tricks from the publisher.
Graphical_user_interface_text_application_Description_automatically_generated
Drill Down Graph PRO keeps the bar high for custom visuals by ZoomCharts through being mobile friendly and supporting interactions, selections, custom and native tooltips, filtering, fetching more data, bookmarks, and context menu.
Main features include:
https://vimeo.com/665504240/a8db1ef3de
Learn More about our Drill Down Graph Pro.
Power_BI_February_2022_Feature_Summary
If you aren't familiar with the tool or Plotly graphing library you can learn by using official documentation of plotly or tutorials of Chart Studio.
https://www.youtube.com/watch?v=YjdTQME9DGc
What makes the HTML Text Styler so powerful?
With the combination of DAX and HTML it is possible to create all kind of dynamic and cool elements in Power BI. It can be used for custom KPI cards, fully formatted tables, dynamic text, animated GIFs and much more.
In this video, we walk you through our sample report which contains just a couple of examples of elements that can be created with the visual.
To get started, we recommend downloading the sample report and taking a look at the online knowledge base. For users that prefer a private one-on-one session, free demo sessions can be scheduled here.
To learn more about the visual, visit kteam.ch/text-styler.
1. Combo Chart menu
Now you can add a line plus column chart or a double line chart as a micro chart (sparkline). If you choose โChart Typeโ as โDouble Lineโ you can also conditionally color the area between them.
Power_BI_February_2022_Feature_Summary
2. Conditional coloring
Power_BI_February_2022_Feature_Summary
3. Waterfall Chart
You can insert a vertical waterfall sparkline. You can set a bar as โpillarโ or โvarianceโ by right clicking the cell as shown in the image below.
Power_BI_February_2022_Feature_Summary
4. Dumbell Chart
Dumbbell or Range Bar graph is useful for illustrating change and comparing the distance between two groups of data points. You can create this chart just like a bullet chart. You need to have 2 columns (start values and end values) against each category.
Power_BI_February_2022_Feature_Summary
5. Waffle Chart and Ratings Chart
Power_BI_February_2022_Feature_Summary
Power_BI_February_2022_Feature_Summary
6. Customized headings
Now you can add customized heading for โCombo chartโ and โBullet Chartsโ
Power_BI_February_2022_Feature_Summary
Download this visual from APPSOURCE
For more information visit https://www.excelnaccess.com/sparklines/
Power_BI_February_2022_Feature_Summary
Based on your excellent feedback we have added several exciting features to this visual:
Try the Merged Bar Chart now by downloading it from the AppSource. All features are available for free to evaluate this visual within Power BI Desktop.
Please visit us: https://visuals.novasilva.com for questions or remarks.
This is particularly useful if you want to ensure consistency across multiple reports with the same layout.
JSON allows you to centrally control reports across your organization:
After the groundwork is done using JSON, you are still free to build on top of that using the full flexibility of the Financial Reporting Matrix:
The Inforiver premium edition includes everything available in Standard and Professional editions (such as number formatting, calculated rows & columns, notes & annotations, conditional formatting and in-cell visualizations), and additional new capabilities such as manual data capture / inputs for budgets/forecasts, advanced what-if simulations, formatted & paginated exports to PDF & excel, blended measures, and more.
These additional capabilities go beyond reporting, visualization & analysis, and unlock new use cases such as sales planning, financial budgeting, operations forecasting and more.
For additional information see the blog on Inforiver and the feature preview video.
With Multiforecast and Multiplan functionality of Zebra BI Tables 5.2, you can simply add up to three measures for Forecast and/or Plan and compare several values against your performance to always stay flexible and agile.
From now on, you can select the settings you want to bookmark and save the view to make it easier for the report viewers to check the report page most relevant to them. Apply this to different chart settings, layouts, titles, data labels, and design options.
Power_BI_February_2022_Feature_Summary
For other important new features and improvements in the Zebra BI Tables visual, visit Zebra BI for Power BI โ 5.2. and watch the video to learn about new functionality in details.
Please refer to this blog post to learn more about how to install WebView2 if you have not done so already.
Also, please refer to the troubleshooting information available here in case you are having any issues.
The Power BI Release Plan app visualizes features from the Dynamics 365 and Microsoft Power Platform release plans, making it easy for organizations to track monthly releases and to stay up to date with upcoming features! With searchable text and direct links to feature details, organizations can now easily share the excitement of each Power BI release!
Power_BI_Release_Plan_Report_report
The Power BI Release Plan app is brought to you by the Power BI team and is available on AppSource.
Learn more about the appโs functionality in our documentation.
Learn More about how to Optimize your Processes and Gain Deep Insights with Process Mining.
This release aligns the behaviors between Desktop and Service. When a user is signed in on Power BI Desktop, the Map and Filled Map visuals will be enabled or disabled based on their organizationโs Admin settings. If a user on Power BI Desktop attempts to view a Map visual when their tenant has not enabled the feature, they will be prompted to ask their admin to enable it:
Power_BI_February_2022_Feature_Summary
When a user is not signed in, the visuals will be enabled based on a new setting in File -> Options and Settings -> Options -> Global -> Security named โUse Map and Filled Map Visuals.โ
Power_BI_February_2022_Feature_Summary
Just like with new tenants, new Power BI users will need to explicitly opt in to using these visuals. Otherwise, attempting to create a map visual will prompt users to enable them in their settings.
Power_BI_February_2022_Feature_Summary
That is all for this month! Please continue sending us your feedback and do not forget to vote for other features that you would like to see in Power BI! We hope that you enjoy the update! If you installed Power BI Desktop from the Microsoft Store, please leave us a review.
Also, don't forget to vote on your favorite feature this month over on our community website.
As always, keep voting on Ideas to help us determine what to build next.
We are looking forward to hearing from you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.