This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
Welcome to the November 2024 update.
We’re thrilled to introduce Copilot in Power BI Mobile apps, bringing AI to your fingertips for a smarter, faster way to explore data on the go. This month’s update also includes a new Path layer for the Azure Map visual, making geospatial analysis even more powerful by helping you easily map connections between multiple locations. We're also introducing the OneLake catalog, the latest evolution of the OneLake data hub, offers a unified platform for data engineers, data scientists, analysts, and decision-makers to browse, manage, and govern data seamlessly—all from one intuitive interface.
There is a lot more to explore, please continue to read on.
Join us for Ignite 2024 Chicago
Join us online, November 19-21st for Ignite 2024 to learn about the latest innovations in Data & AI. The sessions will cover solutions that help modernize and manage intelligent applications, safeguard data, and accelerate productivity while connecting with partners and the Data & AI community. To attend online, register here.Register for FabCon Las Vegas 2025
Join us at FabCon Las Vegas from March 31 to April 2, 2025, for the ultimate Microsoft Fabric, Power BI, SQL, and AI community-led event. With more than 144 sessions, 18 pre- and post-conference workshops, unique community experiences, a dedicated pre-day for partners, all-day Ask-The-Experts hours, 20+ expo booths, plus after-hours events and socials you don't want to miss, FabCon has it all! Register today to grab the early bird discount and use code MSCUST for $150 off registration.Get certified in Microsoft Fabric - for free!
Get ready to fast-track your career by earning your Microsoft Certified: Fabric Analytics Engineer Associate certification. For a limited time, we will be offering 5,000 free DP-600 exam vouchers to eligible Fabric Community members. Complete your exam by the end of the year and join the ranks of certified experts. Don’t miss this opportunity to get certified.Explore the newest Fabric certification for Data Engineers
We are excited to announce a brand-new certification for data engineers. The new Microsoft Certified: Fabric Data Engineer Associate certification will help you demonstrate your skills with data ingestion, transformation, administration, monitoring, and performance optimization in Fabric. To earn this Certification, pass Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric, currently in beta.A_yellow_sign_with_black_text_Description_automatically_generated
Contents
https://youtu.be/4MmIZEwVGbc
With Copilot in Power BI mobile apps, you no longer need to analyze data by yourself. Copilot provides report summaries and insights, allowing you to make informed decisions anytime and anywhere. Imagine a sales manager effortlessly pulling up an executive summary of the latest sales report with a single tap, or a maintenance technician asking for real-time machine-performance insights while on the factory floor.
To start using Copilot on your mobile app, simply tap the Copilot button located in the report header (that meets Copilot requirements in Power BI) and choose whether you want to get a summary or to look into insights. Copilot will deliver a response based on your request. You can then copy and share the response or keep interacting with Copilot by choosing from the suggestions at the bottom. These suggestions can help you tweak the response or create new requests.
For more details about Copilot in Power BI mobile apps, check out our full blog post.
A_screenshot_of_a_smartphone_Description_automatically_generated
Learn more about using Copilot in Power BI and Fabric.
Set up the copilot summaries for Power BI reports that you subscribe to as follows:
1. Select the ‘Subscribe’ option from the ribbon for the Power BI report that you are interested in.Add_Copilot_Summaries_to_Power_BI_email_subscriptions_Preview2. Select ‘Standard Subscription’.
Power_BI_November_2024_Feature_Summary
3. You can subscribe to the report.
A_screenshot_of_a_computer_Description_automatically_generated
Learn more about creating report subscriptions
4. Add a copilot summary to the email delivered by the subscription. If you are eligible, your subscription will receive the Copilot summary by default.
Power_BI_November_2024_Feature_Summary5. You can ‘Preview summary’ to view a sample of what the summary might look like.
A_screenshot_of_a_computer_Description_automatically_generated6. Test your subscription by selecting ‘Send Now’ after you Save the subscription
Note: ‘Send Now’ will deliver the email with the copilot summary to all recipients.
Email Sample:
A_screenshot_of_a_computer_Description_automatically_generated
This feature will roll out gradually over the next few weeks and is not available in Gov clouds.
The Path layer is ideal for several key scenarios, for example:
Network Analysis: For industries like telecommunications, the Path Layer enables you to map intricate network connections. It helps identify inefficiencies, monitor data flow, and strengthen critical infrastructure.
Flight Path Analysis: Airlines can leverage the Path Layer to visualize and analyze flight routes, improving air traffic management. It helps identify new route opportunities and enhances the overall passenger experience by optimizing existing routes.
To get started, add the location for each point using either a geocoded location field, such as city names, or latitude and longitude. Then, differentiate between the paths by adding a field to the Path ID field well and indicate the order of connection through the Point Order field well.
For example, you could create a map showing the path of two ships with the latitude and longitude of their positions for each point, a path field with a unique identifier for each ship, and a timestamp for each location to make sure the points are connected in the correct order.
A_map_with_a_route_Description_automatically_generated
You can also format the visual by controlling the color, transparency and width of the lines, and even turning off the bubble markers for each point. If you turn off the bubble layer, you’ll only see a bubble on hover showing you the closest point to your pointer location. Paths are interactive as well, so you’ll get tooltips on hover and be able to cross-highlight other visuals by clicking on points of the lines.
A_screenshot_of_a_map_Description_automatically_generated
There are a couple of unique behaviors to be aware of with this new layer. First, when using a drill hierarchy with the path layer, the visual will automatically drill down to the lowest level and will not allow you to drill up, as points in the path would be aggregated at higher drill levels.
Next, if you have a location that’s part of multiple paths, the bubbles for that location show up on top of each other. If you want to click on the bubbles underneath, just hover on the line associated with its path, and it will float to the top and be selectable. Lastly, you can further break down the paths by adding a legend, which will create unique lines for each legend value of a given path ID.
A_map_with_a_blue_line_Description_automatically_generated
An additional point to consider: Currently, the path layer operates mainly in conjunction with the bubble layer. Once you add a path to your map, you’ll see that the filled, cluster bubbles, heat map, and 3D column layers are all disabled. Additionally, while you can use the path layer in conjunction with reference layers, the reference layer will be static. It’s currently unsupported to mix data bound reference layers with the path layer.
The path layer is still actively rolling out to all regions. Depending on what region your tenant is in, you might not see the path layer in the Power BI service through the weekend. Be sure to check the report after publishing, and if you don't see the layer, it should be accessible within a week.
We’re excited to see what you create with this new path layer. Give it a try and let us know what features you’d like to see next!
If you export data, hidden fields on a visual are not included in the export, unless you export the underlying data. The results of visual calculations are always included in the export, except when exporting underlying data, since visual calculations are not part of the underlying data as they only exist on the visual.
Learn more about visual calculations in our documentation.
This new feature is currently in preview with the new Card visual, offering an excellent opportunity to experience the capabilities of the feature.
Small multiples are a series of similar card tiles displayed together in a grid format, each representing a different category or dimension of data, allowing for easy OKR comparison and analysis across multiple fields.
This newly added feature enhances data organization, visual clarity, and performance, making it easier to analyze and present data effectively. To try it, navigate to Options and settings > Options > Preview features > New card visual, and make sure it’s enabled.
Another advantage of the new Small multiples feature is the extensive customization it offers, including:
Power_BI_November_2024_Feature_Summary
To categorize your cards using small multiples, choose a data field from the data model and add it to the Small multiples data field well.
A_screenshot_of_a_computer_Description_automatically_generated
This new feature provides extensive customization options, such as layout, advanced formatting options, conditional formatting, borders and gridlines, overflow style, and customizable headers.
Small multiples for the Card visual in Power BI offer another great enhancement that significantly improves data organization, visual clarity, and performance.
The Core Visuals team continues to add new features and greater functionality, and we’re committed to improving our capabilities. We invite you to explore this new feature and share your feedback with us in the comment section below as we continue to improve our Card visual capabilities.
We understand your eagerness to delve deeper into Small multiples and grasp how these enhancements fulfill the highly requested features by our community. Find out more and join the conversation in our dedicated blog, where we unravel the details and share the community-driven vision behind these improvements.
This month brings the arrival of the new text slicer in Power BI offering new possibilities for both users and the organization.
Enable the new text slicer by navigating to Options and settings > Options > Preview features > text slicer visual to ensure its selected, and restart Power BI.
The text slicer works by allowing users to input specific text that acts as a filter, targeting a designated data field. By entering the desired text in the slicer’s input box, the slicer effectively narrows down the dataset to display only the relevant information that contains the entered text. This functionality is particularly useful for handling large datasets, where quick and precise filtering is essential for efficient data analysis and presentation.
To create a text slicer visual, select the text slicer icon from the visual gallery on the Build visual tab in the Visualizations pane. This adds a visual placeholder to the report canvas.
Power_BI_November_2024_Feature_Summary
To filter a dataset, add a text field from the data model to the Field well to establish the text slicer's functionality, allowing it to filter the dataset based on user input. Simply add text to the slicer’s input box, select the apply icon, or press enter, and the slicer immediately filters the dataset, displaying results on the visual.
A_screenshot_of_a_computer_Description_automatically_generated
As shown here, the new text slicer introduces a powerful and customizable filtering tool in Power BI:
We know you’re excited to learn more about the Text slicer and other new enhancements tailored to our community’s needs. Discover the specifics and join the discussion on our dedicated blog, where we break down the details and share the community-inspired vision driving these updates.
A_screenshot_of_a_computer_Description_automatically_generated
This will create a new query table with the syntax started for you to create a query-scoped measure DAX formula ready for you to add your own DAX formula and then run when ready.
Learn more about DAX query view and the other quick queries available at DAX query view - Power BI | Microsoft Learn.
A_screenshot_of_a_computer_Description_automatically_generated
The Fabric Metric Layer’s home base is the Metrics Hub in Power BI and brings powerful capabilities to streamline metric management, ensure consistency, and foster trust in data across your organization.
Metric sets will be available for both consumers to browse, and creators to use in reporting. A service experience consisting of visualized metrics and data exploration will allow end users to answer their data questions. The desktop experience will allow creators to connect to the most authoritative metrics to visualize in reports.
Key Features:
Learn more about Metric Sets here.
Stay tuned for the upcoming milestones and get ready to transform your metric management experience with Metrics Hub!
The latest changes should greatly improve the performance and reliability of operations in Analyze in Excel on models that include one or both of:
When Purview compliance admins configure DLP policies for Fabric, they now have the option to decide if upon detecting sensitive information they would like to block access to the data. They have the option to prevent guest users from accessing the data or to restrict access for all users except the data administrator.
A_screenshot_of_a_computer_Description_automatically_generated
In Fabric, data admins will see an indication that their data is restricted, and can act, such as reporting an issue to the compliance admin or override the policy rule.
A_screenshot_of_a_computer_Description_automatically_generated
Consumers, such as guest users who have been now restricted from seeing this information, also see an indication letting them know that an organization policy revoked their access, and if they attempt to see its content, they will not be able to.
A_screenshot_of_a_computer_Description_automatically_generated
With restrict access action, compliance admins get further control and enforcement when uncovering sensitive data in their Fabric tenant.
A_screenshot_of_a_computer_program_Description_automatically_generated
The Tabular Model Definition Language (TMDL) is designed to make model representations readable, editable, collaborative, and reusable. The TMDL Extension builds on these strengths of TMDL with several key features that create a rich development experience:
By working in Visual Studio Code, you can also take advantage of other fantastic tools on the platform such as:
Due to its folder representation and readable format, TMDL offers a significantly improved source control experience. This enhancement facilitates tracking commit history and simplifies the resolution of merge conflicts, particularly when compared with TMSL.
Power_BI_November_2024_Feature_Summary
If necessary, you can continue to obtain the TMSL representation of your semantic model by using the Get Semantic Model Definition REST API or XMLA Endpoint.
You may need to update your firewall rules. See the troubleshooting document for details.
Please ensure that you are using the latest Analysis Services client libraries for optimal performance when connecting to Power BI semantic models.
Key Features:
100+ Prebuilt KPI templates within visual and option to create own templates.
Design:
Categorical: Compare values across categories.
Comparison: Analyze differences between values.
Composition: Show parts of a whole.
Progression: Display trends over time.
Actual vs Target: Compare actual against targets.
Business Use Cases:
Sales Performance, Financial Health, Customer Satisfaction.
A_screenshot_of_a_computer_Description_automatically_generated
By emphasizing what’s important and explaining why it matters, you guide your audience towards critical information and promote clarity and understanding. This clarity is crucial in any business environment, where time is often limited, and strategic decisions must be made swiftly. Effective comments reduce the time and effort required to generate actionable insights, which ultimately improves report quality and effectiveness.
Incorporating thoughtful commentary can transform a standard report into a powerful tool for decision-making. With Zebra BI Tables, enhancing your reports with meaningful comments has never been easier -- all so you can communicate your message more effectively and engage your audience better.
Power_BI_November_2024_Feature_Summary
Check out our video example of the rich text editor in Zebra BI Tables 7.3.
Main Features:
Power_BI_November_2024_Feature_Summary
A_screenshot_of_a_graph_Description_automatically_generated
In our latest Lollipop Bar Chart release for Power BI, we’ve added a much-requested feature: secondary markers. This allows you to display not only the primary value but also add context by including a secondary value marker.
A_screenshot_of_a_graph_Description_automatically_generated
This new feature integrates seamlessly with all other Lollipop Bar Chart functionalities, such as transforming the Lollipop Bar Chart into a dot plot by removing the connecting bars, as shown in the second image. This also removes the requirement to start your numeric scale at 0, allowing you to have a closer look at the values and their differences.
While standard bar charts are great for comparing a single measure across categories, they can become cluttered with larger datasets (>10 categories). The colored bars may fill too much of the chart space. To address this, the Lollipop Bar Chart offers a cleaner, more efficient alternative, minimizing clutter without sacrificing clarity.
Try the Lollipop Bar Chart for FREE now on your own data by downloading it from the AppSource.
Questions or remarks? Visit us at: https://visuals.novasilva.com/.
Key Features:
For more information, visit our website.
Watch a short video here.
Read this Sales Velocity Chart documentation.
For any queries, questions, or requests, please write to us.
A_screenshot_of_a_computer_Description_automatically_generated
A_screenshot_of_a_computer_Description_automatically_generated
Enhance your data visualization effortlessly with this versatile tool.
Key Features:
Download Decomposition Tree by JTA for free: AppSource
Try Decomposition Tree by JTA: Demo
Learn more about us: JTA The Data Scientists
Power_BI_November_2024_Feature_Summary
The book is suitable for non-technical professionals as well as for experienced data analysts. It consists of 3 parts:
The book is now available on Amazon.
A_screenshot_of_a_computer_Description_automatically_generated
Learn more about viewing localized paginated reports on the Power BI service.
That’s all for this month!
We hope that you enjoy the update! If you installed Power BI Desktop from the Microsoft Store, please leave us a review.
As always, keep voting on Ideas to help us determine what to build next. We are looking forward to hearing from you!
A_yellow_sign_with_black_text_Description_automatically_generated
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.