Power BI Update - August 2024

Summary

The August Power BI Monthly Update introduces new features and enhancements. Highlights include the ability to query entire semantic models with Power BI Copilot, visual level format strings in preview for advanced formatting, and dynamic per recipient subscriptions now generally available. Other updates include delivering subscriptions to OneDrive and SharePoint, an updated save and upload flow to OneDrive, and the introduction of data limit capabilities for performance management. The video also showcases DAX query view in the web, narrative visuals with Copilot for SAS embed, and celebrates community member Jennifer Ratten for her contributions.

Takeaways

• 📈 Power BI has introduced a new feature allowing users to ask Copilot for data from the entire semantic model in Power BI Desktop, enhancing the AI capabilities of the platform.
• 🎨 Visual level format strings are now in preview, offering more formatting options for visual calculations and other visual elements, providing greater control over the presentation of data.
• 📬 Dynamic per recipient subscriptions are generally available, simplifying the distribution of personalized copies of reports to each email subscription recipient with specific filters applied.
• 🗂 Delivering subscriptions to OneDrive and SharePoint is now generally available, offering a solution for reports too large for email delivery and enhancing data management.
• 🔄 An updated save and upload to OneDrive flow in Power BI has been introduced, improving the experience of uploading new Power BI files and making background updates easier.
• 🚀 The data limit capability has been rolled out, giving users more control over visuals by setting a maximum data load per session, which can help manage performance issues.
• 📊 Visuals, shapes, and line enhancements have been fine-tuned, with updates to legends and tool tips to reflect style enhancements consistently across reports.
• 📝 DAX query view is now available on the web, allowing users to write DAX queries directly on published semantic models, enhancing accessibility and flexibility for data analysis.
• 📑 Narrative visual with Copilot is available in SAS embed, marking the first step in integrating Copilot into embedded analytics solutions for user-owned data scenarios.
• 🌟 The Power BI team highlighted editor's picks of the quarter and new visuals in the app source, encouraging users to explore and utilize these visualization tools for data representation.
• 🏆 Community member Jennifer Ratten was recognized for her contributions to the Power BI community, including authoring solutions, participating in presentations, and volunteering at events.

Q & A

Who is presenting the August edition of the Power BI Monthly Update?

The August edition of the Power BI Monthly Update is presented by Jason Himmelstein, Principal PM Manager for Content Strategy in Microsoft Fabric.

What is the new feature in Power BI Desktop that allows querying of the entire semantic model using Copilot?

The new feature in Power BI Desktop is the ability to ask Copilot for data from the entire semantic model, which will then query the model and answer questions with a visual representation.

What is required to use the new Copilot feature for querying the semantic model in Power BI Desktop?

To use the new Copilot feature for querying the semantic model, you need to have the preview feature for the Copilot chat pane in report view turned on.

What is the purpose of visual level format strings in Power BI reporting?

Visual level format strings in Power BI reporting provide more options to configure formatting, allowing users to format visual calculations and other elements within a visual, enhancing customization and presentation.

What does the dynamic per recipient subscriptions feature in Power BI do?

Dynamic per recipient subscriptions in Power BI simplifies the distribution of personalized copies of each report to each recipient of an email subscription by allowing the definition of which view of the report an individual receives based on specific filters applied to their version of the report.

How can Power BI and paginated report subscriptions be delivered to OneDrive or SharePoint?

Power BI and paginated report subscriptions can be delivered to OneDrive or SharePoint by scheduling and sending full report attachments to these locations, which is useful for reports that are too large to be delivered by email or are affecting the email quota.

What is the updated save and upload to OneDrive flow feature in Power BI Desktop?

The updated save and upload to OneDrive flow feature in Power BI Desktop allows users to save new reports to OneDrive and easily upload changes in the background, improving the experience of uploading new Power BI files and updating existing ones.

What is the data limit capability introduced in Power BI and how does it help?

The data limit capability in Power BI allows users to set the maximum data load for a single session per visual, helping to manage performance issues by ensuring visuals only load an optimal amount of data, thus enhancing performance and preventing overload.

How have the visual enhancements in Power BI been improved with the latest update?

The visual enhancements in Power BI have been fine-tuned for columns, bars, ribbons, and lines, giving users more control over the visual presentation. Additionally, legends and tool tips have been updated to reflect style enhancements, ensuring a consistent and stylish presentation.

What is the DAX query view in the web and how does it benefit Power BI users?

The DAX query view in the web allows Power BI users to write DAX queries directly on their published semantic models through the web interface. This feature provides accessibility and convenience for users to interact with their data models and perform data analysis without the need for Power BI Desktop.

What is the significance of the narrative visual with Copilot being available in SAS embed?

The availability of the narrative visual with Copilot in SAS embed signifies that users can now refresh the visual with their data in embedded solutions where users must sign in, enhancing the interactivity and real-time data reflection in secure embedded scenarios.

How can users get involved and contribute to the Power BI community?

Users can get involved and contribute to the Power BI community by joining the Power BI community forums at aka.ms/pbicommunity, where they can connect with others, get questions answered, and share their knowledge and solutions.

Outlines

00:00

📈 Power BI Monthly Update Introduction

The script opens with the August edition of the Power BI Monthly Update video, hosted by Jason Himmelstein, Principal PM Manager at Microsoft Fabric. The introduction highlights the ongoing efforts to enhance the video's engagement through new features like intro bumpers and updated slides. The team is actively seeking feedback to improve the video further. Viewers are directed to the updates blog for more information on the topics discussed in the video.

05:01

🔍 Enhanced Power BI Features and Capabilities

This paragraph introduces several new and updated features in Power BI. The first is the ability to query the entire semantic model in Power BI Desktop using Power BI Copilot, which can now answer questions with visuals. The feature is available in preview mode. Next, visual level format strings are introduced, offering more formatting options, especially for visual calculations. Dynamic per recipient subscriptions are now generally available, allowing for personalized report distribution. Additionally, subscriptions can now be delivered to OneDrive or SharePoint, and an updated save and upload flow to OneDrive is previewed. Lastly, a new data limit capability is introduced to manage visual performance with large data sets, and visual enhancements for shapes and lines are discussed.

10:03

🎨 Visual Level Format Strings and Subscriptions Demo

Jeroen ter Heerdt demonstrates the new visual level format strings feature, which allows for formatting visual calculations and other visual elements directly within the visual, without converting them to text. He explains the three levels of format strings: model, visual, and element level, each offering different scopes of formatting control. The demo also covers dynamic per recipient subscriptions, showcasing how to set up personalized report deliveries based on recipient data and filters.

15:04

📑 Delivering Subscriptions to OneDrive and SharePoint

Nirupama Srinivasan presents a demo on how to deliver Power BI and paginated report subscriptions to OneDrive or SharePoint, addressing the issue of large reports overwhelming email inboxes. The process involves creating a subscription, selecting the report, choosing the delivery format and location, and setting a schedule for the subscription. The feature is now generally available, offering a solution for managing large report deliveries.

20:05

🔄 Updated Save and Upload to OneDrive in Power BI

Anita Ambalavanan demonstrates the updated save and upload process to OneDrive in Power BI. The new feature streamlines the process of saving a report to OneDrive and uploading changes in the background. After saving a new report for the first time, subsequent saves automatically update the report in OneDrive without additional user input. This improvement enhances the efficiency of working with Power BI files in OneDrive.

📊 DAX Query View in the Web and Embedded Analytics

Zoe Douglas showcases the DAX query view feature now available on the web for Power BI, allowing users to write DAX queries directly on published semantic models. The demo includes creating and editing measures using DAX and adding new measures to the model. Additionally, Carly discusses the narrative visual with Copilot now being available for SAS embed scenarios, where users own the data, and in secure embed scenarios, requiring some setup in Azure's Entra ID for proper functionality.

🌟 Community Spotlight and Visualization Updates

The script concludes by highlighting community member Jennifer Ratten for her contributions to the Power BI community, including authoring solutions and volunteering at events. The video also mentions editor's picks of new visualizations in the AppSource and other visuals to explore. The team encourages community engagement through the Power BI community forums and looks forward to future updates and events, including FabCon Europe.

Keywords

💡Power BI

Power BI is a suite of business analytics tools developed by Microsoft. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create, share, and consume insights. In the video, Power BI is the central theme, with updates and new features being discussed, such as Power BI Copilot and AI enhancements.

💡Power BI Copilot

Power BI Copilot is an AI-driven feature within Power BI that allows users to interact with their data using natural language queries. It's designed to simplify data analysis by enabling users to ask questions and receive visual responses. The script mentions that users can now ask Copilot for data from their entire semantic model in Power BI Desktop.

💡Semantic Model

In the context of Power BI, a semantic model represents the structure of the data, including relationships and calculations, which can be queried and visualized. The script discusses the ability to query this model using Power BI Copilot to answer user questions with visuals.

💡Visual Level Format Strings

Visual level format strings are a feature in Power BI that allow users to apply specific formatting to visuals, such as charts and graphs, independently of the underlying data model. The script explains that this feature, now in preview, provides more formatting options and can be used even without visual calculations.

💡Dynamic Per Recipient Subscriptions

This feature in Power BI allows for the distribution of personalized copies of reports to each recipient of an email subscription. The script highlights that it simplifies the process by letting users define which view of the report an individual receives, by specifying filters for their version of the report.

💡Deliver Subscriptions to OneDrive and SharePoint

The script introduces a feature that enables users to deliver Power BI and paginated report subscriptions to OneDrive or SharePoint locations. This is particularly useful for reports too large to be sent by email or for managing email quota usage effectively.

💡DAX Query View

DAX (Data Analysis Expressions) Query View is a feature that allows users to write and evaluate DAX queries directly on published semantic models. The script mentions that this feature is now available on the web, in addition to Power BI Desktop, enhancing the ability to perform data analysis and create measures.

💡Narrative Visual with Copilot

The Narrative Visual with Copilot is a feature that integrates storytelling capabilities with AI assistance in Power BI visuals. The script notes its availability in SAS embed, allowing users to refresh the visual with their data in secure and user-owned data scenarios.

💡Editor's Picks of the Quarter

This term refers to a selection of the most notable or recommended visualizations chosen by the Power BI team for a specific period. The script mentions that the video will highlight these picks, indicating new and noteworthy visuals in the Power BI app source.

💡Community Member

The script acknowledges a community member, Jennifer Ratten, who has made a significant positive impact within the Power BI community. She is recognized for her contributions, such as authoring solutions, providing replies, and volunteering at events like FabCon 2024.

Highlights

Introduction of the August edition of the Power BI Monthly Update by Jason Himmelstein.

Changes to monthly videos to make them more engaging, including new intro bumpers and slide designs.

Power BI Copilot's new capability to query the entire semantic model in Power BI Desktop.

Visual level format strings are now in preview, offering more formatting options.

Dynamic per recipient subscriptions are now generally available for personalized report distribution.

Delivering subscriptions to OneDrive and SharePoint is now generally available for large reports.

Updated save and upload to OneDrive flow in Power BI for improved file uploading experience.

Introduction of data limit capability to manage performance issues with visuals.

Enhancements to visual shapes and lines with new style options and consistency in legends and tool tips.

Demo of visual level format strings by Jeroen ter Heerdt, showcasing formatting options for visual calculations and measures.

General availability of dynamic per recipient subscriptions demo by Nirupama Srinivasan.

Delivery of subscriptions to OneDrive and SharePoint feature demo by Nirupama Srinivasan.

Updated save and upload to OneDrive flow demo in Power BI by Anita Ambalavanan.

DAX query view in the web for writing DAX queries directly on published semantic models.

Demo of DAX query view in the web by Zoe Douglas, including creating and editing measures.

Narrative visual with Copilot available in SAS embed for user-owned data scenarios.

Setup process for narrative visual with Copilot in embed for your organization scenarios.

Highlighting of new visualizations, editor's picks, and visuals in app source.

Community member Jennifer Ratten's recognition for her contributions to the Power BI community.

Invitation to the Power BI community forums for connection and question answering.

Notice of the next month's video release aligning with FabCon Europe announcements.

Transcripts

(upbeat music)

- Hello, Power BI community.

This is the August edition of the Power BI Monthly Update.

I'm Jason Himmelstein, Principal PM Manager

for Content Strategy in Microsoft Fabric.

Hopefully you've been enjoying the changes

that we've been making to these monthly videos.

From adding new intro bumpers

to giving a different look to the slides

and many more demos,

we're looking for ways to make this video more engaging.

And most importantly, we're working hard

to answer questions you have in the comments.

Keep the suggestions coming

and we'll do our best to implement more positive changes.

As always, for more information

about the topics in this video,

check out the updates blog.

The link is in the video description below.

Let's go ahead and get into it.

Power BI Copilot and AI.

You can now ask Copilot for data

from your entire semantic model in Power BI Desktop.

Just tell Copilot what you're looking for

and Copilot will query your model

to answer your questions with a visual.

To use this new capability,

you have to have the preview feature

for Copilot chat pane in report view turned on.

If you've already done this,

then there's nothing else you need to do

to utilize this new capability.

Just go out and give it a try.

Power BI reporting.

Visual level format strings now in preview.

Visual level format strings are here,

providing you with more options to configure formatting.

Originally built for visual calcs,

the core ability that visual level format strings provide

is the ability to format visual calcs.

Since visual calcs are not in the model,

you could not format them

unless you were using them in data labels

or in specific parts of the new card and new slicer visuals.

Now with visual level format strings, you can.

Visual level format strings, however,

are useful even without any visual calcs.

Dynamic per recipient subscriptions

now generally available.

Dynamic per recipient subscriptions for Power BI

and paginated reports are now generally available.

They are designed to simplify distribution

of a personalized copy of each report

to each recipient of an email subscription.

You define which view of the report an individual receives

by specifying which filters are applied

to their version of the report.

The feature is now available in sovereign clouds as well.

Deliver subscriptions to OneDrive and SharePoint

is now generally available.

Do you have reports that are too large

to be delivered by email or eating into your email quota

in a short period of time

that need to be moved to a different location?

You can now deliver Power BI

and paginated report subscriptions

to OneDrive or SharePoint.

With this capability, you can schedule

and send full report attachments

to OneDrive and SharePoint locations.

Updated save and upload to OneDrive flow in Power BI.

Beginning in the first week of August,

desktop users should see a preview

to turn on the updated save and upload

to OneDrive experience in Power BI.

To enable this, navigate to the preview features section

of options in Power BI desktop.

Users will then need to select

saving to OneDrive and SharePoint

uploads the file in the background.

With these updates, we've improved the experience

of uploading new Power BI files to OneDrive

and easily upload new changes in the background.

Data limit.

We're excited to roll out a great update

that will give you more control over your visuals.

We are introducing the data limit capability.

Your new best friend for managing performance hiccups.

Have you ever had a visual that could just not handle

the heat with too much data?

Well, those days are over.

With data limits, you set the maximum data load

for a single session per visual.

It's like putting your visuals on a diet,

ensuring that they stay fit and perform at their best.

Visuals, shapes and line enhancements.

We've been fine tuning the visual enhancement

of your reports, columns, bars, ribbons and lines,

and have given you the reins

to craft those Cartesians with precision.

With our latest update,

we are bringing the legends and tool tips up to speed.

Now they will reflect the style enhancements

you have applied to your visual shapes and lines,

just as you intended.

No more mismatched presentations,

just seamless, stylish consistency.

All right, time for some demos.

First one is visual level format strings,

now in preview by Jeroen ter Heerdt.

- [Jeroen] If you've used visual calculations,

you will have noticed that there was no way

of formatting these calculations.

So for example, I have a visual calculation here

that calculates the profit percentage

by dividing the profit by the sales amount.

Notice how, even though it's clearly a percentage,

it's shown as a decimal number.

And of course we have the format function index,

which I can use to format this.

But this has the downside

that it turns the output into text.

So if I apply this,

even though it looks fine on the visual matrix,

you'll notice that the visual no longer works

because now it's not a numerical value anymore, it's a text.

So let's undo this real quick.

There is however good news.

We are introducing visual level format strings,

which allow you to format values on a visual.

We're introducing these

as part of the visual calculations preview.

So you will need to enable that first

before you can use them.

You can use these visual level format strings, however,

to format not just visual calculations,

but anything while you're visual.

So I'm going to format the visual calculation

from before as a percentage.

So I'm going to enter the format name,

switch to the general sections,

and here's a new category called data format.

In here, I can now select my profit percentage

visual calculation,

and I'm entering the same visual,

the same format string as before.

And now notice it is now formatted as a percentage,

as well as the visual still works

and is showing the visual as before

because it's a numerical value still,

and it's now nicely formatted in a percentage.

This is great, but we don't stop there

because as I said,

this doesn't just work for visual calculations,

it also works for anything in the model.

So it works for anything on the visual.

So let's format the measure

that is on this visuals here.

So I have a profit measure in my model.

Let me just open that up,

and we can see it's formatted in the model

as a whole number.

Okay, that's why this is now shown as a whole number

on this table visual over here,

as well as here on this column chart.

Now let's say that for this column chart specifically,

I would like to format that number as a currency,

including the dollar sign,

but I don't want to change the format in the model.

I can do that now,

thanks to these visual level format strings

that we've just seen.

So with the visual selected,

I'll go into formatting pane again,

general data format.

And now let me select the profit

and then say,

indicate I want to format this by as a currency.

So now notice that the data label,

as well as the tool tips in this visual

have updated to reflect these new settings.

But again, the table visual on the right hasn't

because that is using the model level format string.

So far so good, but we're not done yet

because I've shown you two levels of format string.

The lowest level is the model level.

This of course applies to anything in the model,

which means columns, measures,

but it also means that visual calculations

cannot have a format string on the model level

since they are not stored in the model.

So the next level up is the visual level.

We just use this to change the profit measure format

to a currency in this specific visual.

We also use that to format a visual calculation before.

Now there's another level,

the third level called element level format strings.

And this level controls the format for your fields,

measures, visual calculations

for the exact element in the visual.

And a format string set on a higher level

overrides any lower level format string.

So a visual level format string

overrides a model level format string.

While an element level format string

overrides both the visual as well as the model level.

This element level format string

is currently only available

for a limited number of visuals and elements,

but it will be expanded in the near future.

And the most prominent place you can use this today

is in the data labels.

So let's set a different format string

for the profit measure in the data label here on this visual

without changing the model nor visual level format string.

Remember, what we're expecting to see

is an unchanged format in the table visual

because that's using the model level format string,

which is set to a whole number.

We also don't want to change the format of the tool tip

because we want to keep that as formatted as a currency,

but we only want to change the data label.

So that's where we will use the element level format string

for the data label to override the format

for just the data label.

So to do that, let's get into the format settings again,

go to visual data labels, find value,

and then indicate I want to work with profits

and then set the display units to custom.

Now I can enter a custom format code in here.

So I'm formatting now as a currency,

but then without any decimals.

As you can see, the data labels have changed.

Notice that it doesn't show any amounts

and any decimals anymore.

However, the tool tip shows the decimals as before

because that isn't using the visual level format string.

And finally, the model level format string

is set to a whole number.

So that's why the table here on the right hasn't updated.

To get started with these visual level format strings,

you first need to enable the visual calculations

preview feature in your desktop settings.

And then afterwards, you can use these three levels

of format strings, model, visual, and element level

to provide you with the maximum flexibility

to get the formatting exactly as you want it.

- [Jason] Our next demo

is dynamic per recipient subscriptions

that is now generally available by Nirupama Srinivasan.

- [Nirupama] Extremely excited to announce

the general availability

of dynamic per recipient subscriptions.

Let's get started with a quick demo.

So here I have a sales overview report

to which I'm going to subscribe.

So I go ahead, click on subscribe on my report,

then create a subscription,

dynamic per recipient subscriptions.

Now here, I can go ahead and pick the dataset

that has the recipient data.

So here I'm going to select the employee training data,

click on next.

I'm going to pick all of the information I need

for the delivery of this subscription.

So I pick the employee name,

I'm going to pick their manager's name,

I'm going to pick the email that

we want this to be delivered to.

I only want this to be delivered to employees

who have completed the work that was assigned to them.

And so I'm going to go ahead and pick status

and I'll define the filter there.

And I'm also going to pick category.

I'll show you why in a minute.

So first is I'm going to filter by status.

I want to only send this to employees

who have completed the task assigned to them.

So I'm going to go ahead, click on completed.

As you can see, I'm going to minimize the filter.

You can only see those employees

who have completed the training here.

So I go ahead, filter the dataset, go next.

I'm going to email this.

So I'm going to go ahead and pick subscription name

to be whatever the sales overview.

I want the recipients to be picked from my dataset

that I picked.

So I'm going to go ahead and say, pick the email.

I'm going to just have,

I'm not going to add a specific email subject,

it'll pick whatever is default.

All of this looks fine.

Go ahead, click next.

I'm going to map my data.

I'm going to go ahead and say my industry

is the same as category.

So that mapping, something that I want to do here.

And then I want to be able to send this every day

at 8:45 PM is what I want to do.

Okay, go ahead, review your subscription.

All of this looks fine.

I'm going to go ahead and say save and close.

Once you've done that, the subscription should fire.

I'll just show you a sample subscription

as I'm demoing this.

This is what it would look like.

And then the report gets delivered

to those who have the status as complete.

Thank you.

- [Jason] The next demo is deliver subscriptions

to OneDrive and SharePoint is now generally available.

Welcome back Nirupama.

- [Nirupama] Do you have really large reports

that you send on a regular basis to your email

and you want to solve the problem

of extremely large inboxes?

Look no further than our new feature

where you can now subscribe to reports

and send them to your OneDrive or SharePoint locations.

Let's get started and learn how to do this.

So I've used a sales and marketing report for this demo.

Go ahead and click on subscribe.

Once you do that, create a subscription

and say standard subscriptions.

Over here, I've named the subscription.

I've left it as the default executive overview.

I'm sending it to myself.

I'm going to attach it as a full report.

You have to if you need to send it to a SharePoint

or a OneDrive location.

I'm going to go ahead and click on PDF.

I'm going to send it to the OneDrive location.

I'm going to go ahead and pick my subscriptions folder.

I have a folder called ODSP already created

and I'm going to make sure it lands in this location.

This feature is now generally available

for you to use.

Go ahead and pick the schedule here as well.

So start date is just today.

I want this to be sent only monthly

and say I want to send it on the first of every month

at 9 a.m.

Same time zone.

Then I want to also make sure

I'm not getting a lot of these.

So I'm just going to say 26th is the last day.

Go ahead, save this subscription.

So it's going to executive overview.

It's going to my OneDrive SharePoint.

You can now see that the report has been delivered.

- [Jason] Our next demo is updated save and upload

to OneDrive flow in Power BI by Anita Ambalavanan.

- [Anita] With our new Power BI file,

we're going to go and save it into OneDrive.

We're going to locate the correct location

in the OneDrive recent folder,

rename our file and hit save.

From there, since we're saving a new report

for the first time, a dialog box will open

indicating that the file is getting saved to OneDrive.

Once the file has been saved,

we can edit and modify the report.

Once we make these changes, we can hit the save button

and the report will automatically upload

in the background to OneDrive

in the original location we saved it at.

Once the file has been uploaded in the background,

we can click on the toolbar

and get a link to the file in OneDrive.

- [Jason] Power BI modeling.

DAX query view in the web.

Write DAX queries directly on your published semantic models

with DAX query view for the web.

DAX query view is no longer only available

in Power BI Desktop, but easily accessible

when you're in the workspace

or semantic model details page.

Let's go ahead and see a demo of this by Zoe Douglas.

- [Zoe] DAX query view already available in Power BI Desktop

is now available in the web.

From your workspace, you can right click

on a published semantic model you have permission to edit

and simply choose write DAX queries.

This will work with semantic models in import,

direct query or direct link storage mode.

Here I have a semantic model in direct link mode

built from a lake house getting data from OneLake.

So this DAX query is really creating the OneLake.

The sample query shows me the top 100 rows of my date table

and I can use other quick queries

to get data from other tables and columns in my model

using generated DAX queries.

And I can quickly find out how

many rows are in my fact table

by writing the DAX query.

Here I want to evaluate a scalar value

so I put my DAX formula in curly braces

to return it as a table for the results query.

Using the format DAX function allows me

to see the value a little nicer

and I can even format the query to make it nicer to read.

And here I see I have 1 billion rows in this table.

In addition to typing DAX queries,

you can add or change measures.

Let's create a new measure

to show the average cost per order.

I already have a measure similar to this

called average profit per order.

So let's save some time and use that as a template.

I use quick queries to define with references

and evaluate this measure.

Now I see the DAX formula for it,

but also the fax formula is used

in the reference measures.

This way I can see the entire calculation flow.

Not only can I see them, but I can edit any of them

and then rerun the query to see how the results will change.

Changes to the query scope measures

do not change the model measures automatically.

And I can hover over the measures in the DAX query

to see which DAX formula is which.

To speed up the measure creating process,

let's first copy the average profit by order.

I know there's a shortcut to copy selected lines.

I can use the command palette to quickly find it

and then use it.

Now two quick changes to the measure and I'm done.

I can use the same trick in the evaluate block

so that I can see the new measure in action

and simply click run.

This looks to be the expected results.

The new measure is not in my model,

but there is a code lens action

available to add new measure.

But first let's clean up the change I made

to the orders measure and format all these measures.

Now I can see a button next to run

shows I can update the model

with all of these changes at once.

Now I see my new measure is added to the model.

Microsoft Fabric customers can not only run DAX queries

with Direct Lake Power BI semantic models,

but also use Fabric Copilot to help write

and explain DAX queries in DAX query view.

So take your data analytics to the next step today

by writing DAX queries.

- [Jason] Power BI embedded analytics.

Narrative visual with Copilot available in SAS embed.

The narrative visual with Copilot

is available for user owned data scenarios or SAS

and secure embed.

This means when a user embeds a report,

the narrative visual in a solution where users must sign in,

they'll now be able to refresh the visual with their data.

This is the first step on our Copilot embed journey.

- [Carly] The narrative visual with Copilot is now supported

in embed for your organization scenarios

where the user owns the data and in secure embed scenarios.

Now there is a little bit of setup required

for the embed your organization scenarios to work properly.

So let's go over to Microsoft Azure

and check it out in Entra ID.

Let's go to your registered application.

And once we're here, we can go down to API permissions

where we can see all of the permissions

that your application already has.

And we're going to add a new one that will allow Copilot

to make sure that it's working properly

within your application.

Under APIs my organization uses, search for Power BI service

and click delegated permissions.

Here we can search for our specific permission

under ML models.

If you expand the options here,

we can click this first one MLModel

and we'll execute all.

This is the one we need to make sure

that Copilot works properly in our embedded solutions.

This is all we need to do for this setup here.

So let's go ahead and refresh the embedded solution

that I already have.

It's very simple.

It does not look as good as the ones that you will create,

I am sure.

Let's go ahead and refresh this.

I already have a report loaded here

that has a narrative visual

and you can see that I am not getting an error here.

It is loading properly.

And here I'll see my narrative load.

And it of course is going to work perfectly with my slicers

and all of the filters that I have on the page

so that my end users and myself can stay up to date

with all of the data in real time

right here in my embedded solution.

We can't wait to hear all the ways that you use it as well.

- Visualizations.

This month we're highlighting

a whole bunch of visualizations for you.

We have editor's picks of the quarter,

new visuals in app source

and another list of visuals for you to take a look at.

Please enjoy.

That's it for the updates.

Each month we highlight a community member

that's making a positive impact in our community.

Meet Jennifer Ratten.

Jennifer has been a Power BI community member since 2020.

She's received over 300 kudos,

authored over 180 solutions and has over 670 replies.

Jennifer is a Learn Together series presenter

and generously volunteered her time

at FabCon 2024 in Las Vegas.

Thank you for all you do Jennifer

and thanks for being a part of our community.

Well, that's all for this month.

Please visit our Power BI community forums

at aka.ms/pbicommunity.

It's the best place for you to get connected with others

and get your questions answered.

Please continue to tell us

how we can do better in the comments.

We are listening.

Like, comment, subscribe and thanks for watching.

Next month's edition of this video

will drop a little bit later in the month

to align with our announcements at FabCon Europe.

We look forward to sharing more with you at that time

and hope to see you in person in Stockholm.