RYAN MAJIDIMEHR: Hello.
My name is Ryan Majidimehr,
and welcome to the July 2023 Power BI update.
We got a lot of exciting updates for you this month.
If you want to see a full list of
all the updates, big descriptions,
links to docs, that kind of stuff,
I highly recommend you check out the monthly blog.
Find a link to the blog in the description of this video.
Also before we get started,
I want to point out that at
the end of this video we will have
our monthly community spotlight,
that's something exciting for you.
I highly recommend you watch
all the way through to the end of the video.
Also, if that's the kind of thing you like,
the Power BI community that is,
I highly recommend you check out the Power BI community.
You can find it at aka.MSweckPBIcommunity.
Also if you like community in
general or perhaps fabric products in general,
you should check out the fabric community,
has all things like the PowerBI community as
well as the synapse and Data Factory communities.
That's all I'll say for now.
But, if you want to find that you can
find it at aka.MSweckfabriccommunity.
Now, let's get started.
For reporting we have some updates to
the on-object interaction in preview.
This month we added
some new functionality and fixed a few bugs.
You can now customize
the pane switcher by quickly adding new panes
directly from the pane switcher
without having to go to the "View Ribbon".
You can now also open
multiple panes and the panes
switcher using Control-click.
Treemap sub-selections are now supported.
We're going to hand it over to
Roseanne for a demonstration.
ROSEANNE LEVASSEUR: We're excited to bring
you even more improvements
this month for an object.
We've now added a new plus button
to quickly add new panes directly from the pane switcher.
This menu also gives you a brief description of
what panes are available and what their functions are.
Even better, the panes added to
the switcher are saved across reports,
configure once and you're done.
In addition to the right-click option
to open a new pane,
it is now even easier to open
multiple panes by using "Control-click".
Now I can simply hold down the control
key and click on the pane I wish to open side-by-side.
We've also added support for the Treemap
visual to be able to format specific selections
RYAN MAJIDIMEHR: Thanks, Roseanne.
Moving on to modeling.
We've added relationship validation
to the data model editing
in the service featured to mimic
the functionality in Power BI desktop.
We need to find the properties of your relationship,
the system will automatically validate it and offer
appropriate choices for
cardinality and cross-filter selections.
Next up is data connectivity.
We have some connector updates for you this month.
The Google Analytics connector has been updated to
support Google Analytics Data API, Google Analytics 4.
To use this new functionality use
implementations 2.0 when connecting.
The Oracle connector has been updated to
enable Azure AD-based single
sign-on functionality
through the on-premises data gateway.
This will require the July release
of the on-premises data gateway.
The Azure Databricks and
Databricks connectors have been updated.
We've added a new DSR handler to
the Databricks multicloud and fixed a UC not
enabled and catalog spark
not found error in
legacy code path using Databricks contents.
The Denodo connector has been updated.
This new version adds graphical support for
the specificification of native SQL queries
at Data Source creation time.
The EQulS connector has a few updates.
The Beta attribute has been removed.
You can now retrieve report content as CSV to remove
the row limitation of dot XLS X-Files.
We've optimized handling of facilitating
groups in the navigation tree and you can now
show Report Location folders in
navigation tree even if one or the other is empty.
Lastly, the Anaplan connector has been updated.
This version of Power BI connector for Anaplan concludes
back-end changes for compatibility
with ongoing Ana plan infrastructure updates.
There is no change to the user facing Connector features.
Moving on to updates in service,
we are happy to announce
the revamp of our datasets detail page.
Now when you click on
a data set item in
the one lake data hub and workspace view,
you will be directed to redesign page
that not only enhances the look and feel,
but also introduces new capabilities
for an improved user experience.
Additionally, we have made
significant improvements to the related items list.
It now showcases
all the downstream and
upstream dependencies for the data set.
This enhancement allows you to easily
identify the sources of that data set,
composite model relations reports,
and dashboards associated with it.
In mobile we're adding
a long-awaited feature that will help data set
owners and report creators to manage
their data set directly from their phone.
We'll hand it over to Michal for a demo.
MICHAL: We're
excited to announce that
the Power BI mobile app now supports datasets.
This long-awaited feature allows data set
owners to refresh the datasets
directly from the mobile app.
To access your data set simply go to
a workspace and select "Datasets Bill" at the top.
You will get a list of datasets
that you have access to in that workspace.
Tapping on a data set will
bring up a data set info drawer,
which includes, the name, owner,
sensitivity label, and the latest refreshed status.
From this pane,
you can also trigger
a data set refresh directly from your mobile app.
If data set refresh is in progress,
the "Refresh Now" button will be disabled.
Indicate that you don't need to trigger another one.
In addition, to make sure
you will never miss a bit when you're on the go,
we added the support for push notifications
that will be sent to you if a scheduled refresh fails.
Tapping on the notification will
take you directly to the data set
info drawer where you will be able to see
the arrow and trigger the refresh again.
The push notifications are sent to
the same users that are receiving mail notifications.
These include the data set owner and any other recipient
that the owner defined in the data set
settings page in the Power BI online service.
With this new ability the data
set owner will be able to immediately respond
to failures and unlock
their users who need fresh data in the report.
AMIT CHANDOK: Thanks, Michal. Next up
in, developers,
check out our latest article that focuses on
techniques to improve the performance of custom visuals.
In this article we discussed
the performance improvements we've made
in visual rendering and load times.
You'll find a link to the article in the blog.
In the other section,
you'll find that WebView2 is now GA.
Finally, we have some exciting new updates
for you in the visualization section.
New visuals available for you on AppSource this month
include spider chart for PowerBI by Visio chart,
HTML content light,
stacked lipstick bar chart standard,
stacked lipstick column chart standard,
100 percent stacked column chart with
values instead of percent standard,
Dual Axis scatter chart standard,
category comparison Barger stacked
comb with percentage and total in label standard,
Likert scale chart for PowerBI by chart Expo.
Updated visuals for this month are drilled on
Mac Pro and multitarget KPI card.
RYAN MAJIDIMEHR: Now we're here
the moment you've all been waiting
for the community members spotlight.
Each month we'll be selecting
a community member who has gone above and beyond
and this month it is Amit Chandok.
Amit has gone way above and beyond.
He is a super user.
He's got an overwhelming abundance of kudos,
excepted solutions, replies, posts.
He's a contributor to the community blog.
He's been on the PowerBI Community Show
and above all else,
he gets the overwhelming support
from the community and he
supports the rest of the community.
That is something that obviously is
very important for us and something that we
loved to see so congratulations to Amit.
If you're wondering who will
be in the spotlight next month, could it be you?
Possibly. But if you want it to be you.
You probably want to head over to
aka.MSweckPBIcommunity to the Power BI community.
Well, that wraps up our video for today.
Tell us in the comments what
your favorite feature was and
also give us some feedback on these videos,
the blog itself,
I would love to hear about it.
I eagerly await the feedback each month.
Please keep sending feedback on these videos.
I do indeed read all the comments.
Getting attacked by a moth here
and as exciting as that moth is,
like, comment, subscribe.
Thanks for watching. Will catch you up in the next one