We have some really cool features to announce this month, including data driven alerts that let you receive notifications when the data you care about the most goes beyond the range you set. The Power BI service team is always listening to your feedback and improving our product based on what we hear. Here’s a look at what we’ve introduced in the past month:
- Set, receive, and manage alerts on your data
- The definition of RLS rules and rows is now moved to Desktop
- You can use the Analyze in Excel feature on RLS-enabled data
- Select a risk classification for the business data presented in a specific dashboard
- Analyze your on-premises AS data in Excel
- We’ve improved the experience around installing Excel updates
- Added an admin setting to control Analyze in Excel functionality for on-premises AS data models
Sometimes knowing about changes to important metrics quickly can give you an advantage or stave off disaster. With data driven alerts in Power BI, you can now get notifications when a metric you care about on your dashboard exceeds a set threshold. Alert notifications will be sent to you as an email, and appear in your notification center on the web and in mobile apps.
You can set alerts for your numeric tiles featuring cards and gauges. You have control over how often you want to be notified about your data, and whether you want to receive an email when your data goes beyond the limits you set.
Note that only the person who set up the alerts can see them. Even when you share dashboards with others, your alerts are not shared.
Read more about setting data alerts.
Row-level security (RLS) lets you restrict data access based on who is accessing it. We introduced RLS for Power BI datasets in March, and have been listening to your feedback ever since. Recently we streamlined the process of configuring RLS by exposing roles and rules in Power BI Desktop. Today, we are excited to announce that RLS has graduated from preview and is now generally available for all Power BI Pro users. Additionally, we have extended our Analyze in Excel feature to support datasets that use RLS too. You can also analyze RLS-enabled data in Excel using Analyze in Excel feature.
Many organizations have policies for data handling that vary depending on the source of data and how it is used. Some dashboards should never be shared with those outside your company, while others can be shared freely. By using the new dashboard data classification, you will be able to raise the awareness of those viewing your dashboards about what level of security should be used. You can tag your dashboards with classifications defined by your company’s IT department, so everyone viewing the content will have the same level of understanding around the sensitivity of data. You can even link to policy information, so users can learn about proper procedures for handling information.
When data classification is turned on, the tags show up next to the dashboard name to let anyone viewing it know the level of security that should be applied to the dashboard and the data it contains.
It will also show up next to the dashboard tile in your Favorites list.
When data classification is turned on, all dashboards start out with a default classification type. As a dashboard owner you can change the classification to match your dashboard’s specific security needs.
To change the classification type, go the dashboard settings by selecting the ellipsis next to the dashboard name, and click Settings.
Under Dashboard settings, you will be able to see what your dashboard is currently classified as and use the drop-down menu to change the classification type.
After you apply the change, anyone you shared the dashboard with will see the update the next time they reload the dashboard.
To learn more about dashboard data classification please see our documentation page.
Analyze in Excel has become one of our most popular features! We have been working on extending the functionality and experiences around this feature. Here are some we enabled recently:
Analyze your on-premises data in Excel
You can now analyze your on-premises AS data in Excel. When you click on Analyze in Excel for your on-premises AS data, we establish a secure and direct connection that enables you view and analyze it in Excel.
Admin setting to control Analyze in Excel for on-premises AS data
Are you an admin who wants control over whether or not the users in your tenant can analyze your on-premises AS data in Excel? You got it! We provide an admin level setting where you can toggle “Analyze in Excel” functionality within your tenant. Note that the feature is on by default. If you don’t want people in your organization to analyze on-premises AS data in Excel, we recommend you go to your admin portal and turn it off.
Experience around installing Excel updates
One thing you said in your feedback was that the flow of downloading Excel updates while using the Analyze in Excel feature is confusing. We heard you, and made some changes so getting to Analyze in Excel is more smooth.
When you select Analyze in Excel, if updates are necessary we will take you to an experience to download Excel.
After you finish that step, you will be directed to the step to analyze your data in Excel.
That’s all the news for the Power BI service in July. We hope that you find these features valuable and continue sending us feedback on how to make the service even better.