>> Hello everyone. I
hope that you hear me.
My name is Renato Fajdiga.
Today, together with Steven Renders,
we'll show you how you can create
reports in Power BI based
on the Business Central.
Then use these Power BI reports
inside the bit in Central.
So for example, how you can embed
these reports inside the
Dynamics 365 Business Central.
Regarding our agenda for today,
we will talk about
Power BI in general,
just some few bullets.
What is Power BI?
How we can use Power BI
with Business Central?
What other applications
and possibilities we
can use with Power BI
and Business Central,
and combine these to get
really powerful reports in
the BI base on the Dynamics 365
Business Central [inaudible].
So when speaking about the Power BI,
we have the Power BI Desktop.
So free application which you can
download from the Power BI website,
and then there you'll install
this application on your laptop,
or on your server, or whatever
you want, on your PC.
Here, you can easily create
connection between Power BI,
and Dynamic 365 Business Central.
So for example, you can
use OData connection,
you can use SqlConnection,
or you can use out-of-the-box
Dynamics 365 Business
Central connector,
which is available for Business
Central, and Power BI.
When you get the data
inside the Power BI,
there you can transform your
data, extract the data,
or for example, load the data,
and then use various combinations
to modify your data
and data structures.
When you are satisfied with
your data inside the Power BI,
what you can do next is
to create some measures.
So for example, you can
calculate your inventory,
you can calculate your inventory
per location and so on.
Then use this measure inside
your Power BI report
and without any coding.
So you can create measure
inside a Power BI,
and you don't need to code anything
inside the Business Central.
Also, you can do some
integrations of the data.
So for example, you can combine
your data from the CRM,
or from customer engagement
with the data from
the Business Central
or for example, if you
have the data about
the employees in Dynamic
365 Human Resource,
then you can combine this data with
the data from the Business Central.
Because we have employee table
inside the Business Central.
Then you can also do a data modeling,
where you can model your data,
change the format, for
example, and so on.
When you are done and when you are
satisfied with your Power BI report,
how it looks like, you can
upload this report inside.
You can upload this to
the Power BI service.
There we have some other
different possibilities
which we can use to get
our reports into Power BI.
So for example, I can pin my
reports through dashboards.
Then this dashboard I
can share with my users,
I can share this dashboard
as applications, and so on.
So I'm sharing the Power Flows
inside the Power Automate,
or how I'm sharing the applications
inside the Power Apps,
I can easily also share my
reports inside the Power BI.
Also, if I want to connect
my on-premise data to power
based service directly,
I have On-Premise data gateway,
where I will connect
my on-premise data inside
my Power BI service.
Which brings us to another point,
where we will help Power
BI to create reports.
So where we reach reports
to create charts,
we can also create customize charts,
or our own charts, and so on.
Also, we have very
rich security because
Power BI is also part
of the Power Platform,
which is part of the Azure
Office 365 Security,
we can use benefits of all
this security policies.
We can use filters inside
the Power BI reports,
bookmark our favorite reports,
or we can ask questions inside
the Power BI so you will get the
data from our Power BI report.
Speaking about Power BI and
Dynamics 365 Business Central,
here we don't need to focus
ourself only on on-premise data,
but we can also use Power BI
as BI tool for our Dynamics
365 Cloud solution
or SaaS environment.
So easily, you can connect
your On-Prem data with
your data in the Cloud,
and then use it in the
Power BI on same way.
Then we have our data in Power BI.
Here we can use for example,
report templates which are
predefined for our Cloud solution.
So for example, when I
deploy Power BI service,
and when I have the Dynamics 365
Business Central SaaS environment,
I can easily create application
inside the Power BI,
which will be one kind of
the predefine reports,
which will use my data from my
tenant from my environment.
So in Power BI out here
interactive reports,
and real time analysis.
So for example, when I do
some slicing and dicing
inside the one report it
automatically update other reports.
What is the benefit
of Power BI is one of
the benefits is the
common language queries,
where I can ask in my
Power BI dashboard show me
the inventory for the
location New York,
and the Power BI will show me
the inventory for that location.
I can also integrate Power BI
inside a Power Apps for
example, and so on.
Can I have all these reports
inside my Power BI service?
So in my Cloud,
I can easily embed this
report inside my web.
For example, I could put this
report and embed it to my website,
or I can embed this into Excel
or show it on the
mobile for my users.
I can also share with another users,
or I can embed this Power BI
report inside the Dynamics.
Today, we will see how
you can embed Power BI
reports inside the Dynamics
365 Business Central,
and how you can use it within
the Dynamic 365 Business Central
without going to the Power BI.
To be able to start
developing the reports for
the Dynamics 365 Business
Central inside Power BI,
you have to do some small coding,
or you can use queries
so you can use pages,
and to show you how this works on,
it will be the best to
create some examples.
So Steven will now continue
with examples how you can
create Power BI report
based on the Business Central
data from the scratch.
Steven, stage clear.
>> Thank you, Renato.
Let me share my desktop.
All right. So let me demo.
First question, you
can see my desktop?
>> Yes, I can see.
>> All right. Perfect. So let
me do a small demonstration
on how you can get
started using a Power BI,
for example, to create a report
that looks like this one.
So that's my goal.
The end goal is to
create this report.
The data is coming from a
Business Central tenants.
In Business Central, we
have, for example, items.
The items in Business
Central have an inventory.
But besides the
inventory of the item,
I'm also interested to
know the availability.
The availability of
an item is the part
of the inventory that I
have available to sell.
That will depend, for example,
on the availability,
the inventory of that item
within Business Central.
I need to subtract whatever I have
already promised on my sales lines.
I also need to add whatever I have on
my purchase or manufacturing order.
So the availability
will be a little bit
different from the inventory.
That's exactly what I'm
showing here in this report.
I can compare availability and
inventory for each of my items.
It's going to be visualized in
many different ways with
the possibilities to
add filters and to look at the data
from different points of view.
Now to be able to create
this report or a dashboard,
how do we need to start?
The first thing that you
need is Power BI Desktop.
But you can download for free from
the Microsoft Power BI websites.
Before we can then get started
within Power BI Desktop
to create a reports,
we of course need to create a
small extension that would expose
the data and that you would like to
import within our Power BI report.
I'm going to do that by
making use of a query object.
So here you can see
a small example of
an extension that contains a query.
You can very easily
get started to create
this by using the query
snippets within Visual Studio,
go to that or development
environments.
It will generate a
skeleton of a query.
Then we might need to make
some small modifications.
So what am I doing right here,
I am actually explaining
that the query will
be fetching information that
comes from the item table.
I'm going to do that in
a very efficient way.
I'm only going to fetch
the fields which are
of interest for my Power BI reports.
So I'm fetching the item number,
I'm fetching the item description.
If I dropped down a little bit,
I'm also going to fetch
the inventory fields.
Of course, because I would like to be
able to calculate the availability,
I might also be interested to
fetch quantity on sales order,
quantity on purchase
order, and so on.
You very slowly start to
create the query objects.
The query object is going
to be used to expose
the data later on to
be able to import.
A query object is also a very
efficient way because it's going to
generate very fast statements
on the SQL database.
So I'm going to create
this query object.
I'm going to put in the fields
that I would like to use.
Then I'm also going to save it.
The query has the advantages
of being very fast.
But one thing a query cannot do
is do a calculation on the fly.
So we cannot really program
anything in the query itself.
If you require to do that,
in that case, now, you
can create a page.
What you can see right here is
a page that I have created,
which is the
ItemAvailability list page.
This page also has some fields
that come from the item
table or but in this case,
I'm going to use that as
damped table to make it fast.
I'm going to select from
fields and I'm also going to
include the availability.
But to be able to calculate
that availability,
I'm going to write a
little bit of code.
This is actually a function
that I have added.
This is going to calculate
the availability.
It comes from a table extension.
In this case, I'm very quickly
going to calculate the flow fields.
The flow field is
actually the inventory,
the quantity on purchase,
the quantity on sales.
I'm going to return whatever
I have on inventory
plus the quantity on purchases
minus the quantity on sales.
This little function, and
then also going to call
that from the page.
This page I'm also going to
expose it as a web service.
So you have two examples, a query,
you can use that for
Power BI and the page
which will include some
small calculations.
Once we have created the two objects,
we need to make sure that they
are going to be available in
Business Central as web
services or in the API.
To be able to do that,
we need to add a small XML file.
This XML file is actually
TenantsWebServiceCollection.
This will publish my two objects,
the page and the query
as a web services to my
Business Central tenants.
So I'm actually
publishing the two ids.
I'm going to give them
a web service name.
When you create this project
and you publish the project,
then within Business Central,
everything is going to
become available in,
for example, the web services page.
So if I quickly go to that
with App Service page,
what you will notice when the page
opens is that I have my
web services available.
Let me change the sorting
order a little bit and you see
that I have my page and
my query available.
I have actually done something
similar for other Power BI reports.
So typically, whenever I
create a Power BI report,
I will add some app services in here,
make me DC for Power BI
to retrieve the data.
Then actually, I will start
to create a Power BI reports.
From within Power BI,
I would like to be able to import
data from Business Central.
Basically, there are two
easy ways to do that.
Within Power BI Desktop,
you go to the "Get
Data" pane and then
you can select the Business
Central connector.
This will connect to your Business
Central instance in the Clouds.
You can choose your
environment and you
will be able to see all
of the web services.
The other way to do that is
by selecting the OData feeds.
This OData feed will also allow me to
connect to whatever web
service that I have.
To be able to do that,
we actually need to go into the
Query Editor and we can actually
create a small parameter that will
link to the OData web services.
To create this parameter,
all I need to know is the URL
of these web services and I
can copy that very easily
from that web services page.
That's exactly what I have done.
I copied the URL,
I have dropped it into a parameter.
Then actually I connected
the OData feeds to
import my data from my query
and from my page web service,
and that's what you
see here, FD Items.
Here I am actually connecting
to my items query.
I have the ItemAvailability where I
am connecting to the
page that I published.
What you notice is that
within Power BI Desktop,
I'm then able to import
all of the fields that
I would like to have.
You can do some transformations,
you can do some calculations,
you can see some graphics about
the distribution of your data.
We have many possibilities.
Once we are ready in
the query editor,
I can then load the data into
Power BI Desktop and where I can
see the tables start coming in.
If you would like to, you can even
combine the tables into a data model.
If you're going to be creating
complex reports or recommendation is
to try to use the
star schema to do so.
So one table will be the
table in the middle,
which is the fact table,
surrounded by dimensional
tables that contain
attributes you would like to
use for slicing and dicing.
Well, in this case it's
a very small reports,
only two tables that I imports,
will create a small relationship.
This gives me the possibility
to start to create a report.
That means that I have the
capability of selecting
some fields from this tables
and putting them into visuals.
I can see that I have the
inventory for an item,
I have the availability for
an item, the description.
By making use of the fields that I'm
importing from both of my credit,
I have the possibility
to create these visuals.
That is actually
already very powerful,
but you can even go a step further.
Like Renato also already explained,
Power BI gives you the possibility to
also calculate certain measures.
That's what I have done here in
the item availability table.
Because they're not
only interested to
visualize the data
from Business Central,
I also would like to
learn from my data.
To be more precise,
I am actually interested to know
how many items I have in
Business Central that have
a negative availability.
Because for those items,
I might need to take action.
I might need to start up some
protection or some purchase orders.
Power BI is able to calculate that.
To be able to do that,
I have created a measure.
In this case, with a
small DAX formula.
So basically, I am
saying here in Power BI,
that I need to count
how many items I have in the
item availability table,
where the availability
is smaller than zero.
So this will do a quick
calculation in the table.
This is my measure.
The measure will become
available like any
of the other fields in a table,
and I then have the possibility
to also put it in my report.
So I can immediately see
how many items have a
negative availability.
I can also slice and
dice this, for example,
by item attributes
or the type of item.
That's actually extremely powerful.
At the moment that I
have this Power BI
reports ready within
Power BI Desktop,
the next thing then to do
would be to publish it,
so that the Power BI report will also
become available here
in Power BI Online.
Here I have the same
reports actually available.
That's actually the first
step on getting started.
So let's summarize this quickly.
I started to create
a couple of queries,
a page and a query in
Visual Studio Codes,
I added the XML file,
that allows me to publish them
automatically as web services.
You import the data
into Power BI Desktop,
you create a report
containing a measure,
and you publish the report.
So you have it available
on Power BI itself.
Later, I will continue
with the demo with
some more advanced features.
But now am giving it back to Renato.
>> Thank you, Steven. Just a
second to switch to my screen.
Let's now continue with some
other features which are
available with integration of
Power BI and Dynamics
365 Business Central.
First of them is Power BI
Applications with Dynamics
365 Business Central.
When you start with Dynamics
365 Business Central,
you will get three predefined
Power BI Applications
which are available for
you out-of-the-box.
So this Power BI Applications
are actually the collection
of the reports based on some modules
inside the Business Central.
So for example, we have Dynamics
365 Business Central Sales,
Power BI Application,
which will give you
the overview and insight
in your sales and so on.
We also have the Dynamics
365 Business Central Finance
which is Power BI Application,
which will provide your
finance information and so on.
Also, you are not
stuck with only these three
Power BI Applications,
you can create your own application
in the Power BI service,
easily by creating the
workspace and then
publishing this workspace
as an application.
To see how this is working
inside the Power BI,
let's take a demo and see how
this looks like in Power BI.
So here, I'm in my Business Central,
and now, I will switch to Power BI.
So this is my Power BI environment.
To start with the applications,
I have here apps on my home screen.
Here, I will see all my
available applications
inside my Power BI license.
I will click on "Get apps".
Here inside the apps,
I can type Dynamics
365 Business Central.
Here, I will see,
predefined applications for
the Business Central
inside the Power BI.
So let's take a look at
this one called Sales.
Hopefully, I can get it now.
I will say that I
want to, for example,
overwrite the existing version or I
can install to a new workspace,
if I want to create a new workspace.
Let's say that I want to overwrite
an existing version and I
will click on "Install".
After a few minutes,
now application is
being installing into
my Power BI service and I
can now go to my workspace
to see this application.
Here for now, my application
is not connected to the data,
we can connect your data.
Here I need to specify
my company name,
which is the company name
from the Business Central,
or you can find it
here in the Gearbox.
Inside of my Settings,
here I will see my
Cronus BE as a company,
so this is the company name.
My environment name.
Here if I see that I need to
enter the environment name,
I need to specify what
is my environment.
I will see it here in my URL.
Next step is to click on the "Next",
and to sign in to my application.
In a few moments, I will
have my data inside
Power BI Application
which is one application,
which is predefined
inside the Power BI.
I will try to refresh my dataset.
Now, if I see on the
left side of my screen,
I have Microsoft Dynamics Workspace
and inside the Microsoft Dynamics,
I have information from
my Dynamics 365 Business
Central in my Power BI.
I have some reports,
for example, item sales,
item sales dashboard where
I can see information
about my sales of my
item sales and so on.
I can easily navigate
through all these reports.
I can share this with my
users or I can export,
or even if this is
Microsoft developed,
I can edit this report
and do customize reports.
So I can create new page
here and then create
some custom report page and so on,
or I can just easily edit this one,
for example, I can change the color,
for example, to be in the color
of my company, for example,
to this color, then
I can save this to
existing report or I can Save As
another page inside my reports.
I save this and now, this is
available inside my Power BI.
I also have dashboards where I can
track my information
about my data and so on.
This is what you get when you
have Power BI out of the box.
Sometimes you want to create
your customized
applications which you will
then share with your colleagues
inside the organization and so on.
To do this, you need to
create the workspace.
So you see that our
application is also
one workspace inside
my Power BI service,
and I'll create a new
workspace, and I will call it,
for example, sales workspace.
I'll enter some
description application
for sales department,
and I will save this workspace.
You'll be immediately transferred
to this new workspace
and here I can see that the
workspace is selected and it's open.
Here, now, I can easily just
import one of my Power BI files.
So for example, I have
this orders intake,
Power BI, and in a few seconds,
I will get my report inside
my Power BI service.
So I see my page is inside
my Power BI report inside
my Power BI reports.
When I go back, I see this
is my report and I'll say,
for example, rename these two sales.
Then I'll delete this dashboard,
now create one dashboard
from the scratch.
So for example, I am interested in,
let's say, this one and I want
to pin this to my dashboard.
So for example, I will pin this,
in here I will get my
new sale dashboard
and what I can also do
when I go to workspace,
I can be in another graph.
So for example, another chart to
this dashboard and have
it on my dashboard.
When I click on it, it'll
open my Power BI page,
but what is now interesting for me,
that I want to create
this as an application.
So I will go to
my workspace and here I see
now all my component
of this workspace.
So for example, I have one dashboard,
I have one report.
There is no workbooks.
I have my dataset,
and I don't have any data
flow inside my application.
What I will now do,
I will click on "Publish this
application," I will
enter applications,
so for example, sales
is an inscription.
I'll write sales location.
I can upload some custom logo
or choose some other color.
For example, I like this color.
I can specify the navigation,
what will be the name of the
dashboard, dashboard link,
and so on, or I can change
this inside my navigation.
I can also grant the permission
to the applications and so on.
What is important then when
you are using applications,
you need to have Power BI Pro
license for all the users who
are using this application.
Now, I will publish
this application and my application
will be published successfully.
I can copy this link or go
straight to this application.
This is my workspace,
which now becomes the application.
So for example, I can navigate to
my sales reports and I
can do another slice and
dice or choose some of
the filters and so on.
So this is how you can easily
create the application,
which is based on Power BI data
and being based on Dynamics
365 Business Central data,
and then publish this
application to your end-users.
Now, when I navigate
to the Power BI back,
if I click on "Applications"
I will see my application,
which is here and I can edit it
if I want or I can pin it
as favorites and so on.
If I take a look at my workspace,
I see that this is only my workspace.
When I go to the workspaces,
I'll find myself workspace,
which is the source for
my sales application.
So this is application,
so easily you can combine your data,
combine your reports and
dashboards in one application,
and then share it with your users.
So now, when I have my application
and I have my reports,
I can easily embed
these reports inside Dynamics
365 Business Central.
I can embed these reports
inside the Role Center on
my home screen or I can embed
this Power BI reports
on my List Pages.
For example, customer
lists or item list,
vendor lists and so on.
When I upload and embed
this Power BI report inside my
Dynamics 365 Business Central,
I can modify the report,
I can switch between one
report to another or I
can create another report inside
the Business Central
using the Power BI.
How to do this.
Let's go straight to the Demo.
So here, I will show you how you
can embed Power BI report inside
the Dynamics 365 Business
Central and what are
the possibilities inside the
Dynamics 365 Business Central.
So I'll go to my Business Central
and this is my home screen.
If I navigate to below,
so here I have a section
called Power BI reports.
When I click on this "Drop Down",
I have possibility to
select the report,
to refresh this page or for
example, to upload report,
which will upload report
from the Power BI file.
Because I have my report
already in Power BI,
I will just use my option,
Select the Report.
In here you can see, that I have
report name, item availability,
orders intake, all my sales report,
which is the parts of my application.
These two are part of
my workspace and here we
can see these two reports.
If I open my sales application,
I will see the sales report
in my sales application.
I will go back to Dynamics
365 Business Central.
In here, I can choose
this to enable it
or I can click on "Enable"
and I'll click on "Okay."
In a few moments, I will
get the Power BI reports
embedded inside my Dynamics
365 Business Central.
So these are my reports which are
part of the sales application.
Here, I can easily now use
all the functionality
which I have in Power BI,
reports such as filtering
or editing and so on.
To show you another possibilities,
I can for example, expand
this report to carry it
in some bigger view.
I can expand this,
then I will have something similar
to what I see inside the Power BI.
If I go to the Power BI here,
orders intake by amount,
I will see the same
view which I have also
here inside the Power BI.
It's the same what I have here inside
the Business Central, Power BI
embedded into Business Central.
I can navigate to the
Power BI report pages,
so everything will be the same.
This is how you can expand and
navigate to Power BI report.
Here, also, everything
works on the same way.
I can open this in a new page.
So for example, I need to open
the new window inside my
Dynamics 365 Business Central.
What I can also do, for
example, manage the reports.
Business Central will open
Power BI editor inside
the Business Central.
Here I can, for example,
go to the file,
save this report or I can click "Edit
Mode" and then edit applications or I
can create some new reports
based on the data and
dataset which I have
inside my Power BI report.
I can also fit to page and I can
use some other advanced features.
I can also select multiple
reports to be shown
on the Business Central homepage.
So for example, item
availability, if I enable this,
click on "Okay," I'll get
another report and for example,
one of them, I can navigate from
one to another very easily
from the home screen.
So this is how you can
embed on your home screen.
But sometimes you want to have
the data near your customers,
near your vendors, near your
items and you want to have
this Power BI report near your data.
To have the Power BI
inside the, for example,
customer list or vendor list,
we need to go to the Actions,
Display, Show/Hide Power BI Reports.
So we will just enable or disable
the Power BI books and here you
can also select the report.
If you don't see any power BI report,
this is because on the customers,
vendors and items, there is a filter,
predefined filter based
on the report name.
So for example, if
we take a look here,
you'll see that here we are
filtering all vendor reports,
which has the customers
inside their name.
So for example, if I go to
my sales report and I go
to home screen and for example,
I will say that, save a copy of this,
now, let's now call it customers.
I'll get the customer sales
report inside the Power BI.
If I click on "Drop-down,"
select "Reports," now, I will
see my customer sales report
inside Power BI selection,
I will enable it and
a Power BI report will be
embedded in this customer lists.
But from here, you have
all the possibilities
except uploading the Power BI
file to manage your reports.
So for example, I can also go
to the Manage and for example,
edit this report,
save as this report.
So for example, I can save as
to another name and then do
the modification to leave
this default version as is.
This is how you can
easily use Power BI
inside the Business Central
with the Business Central data.
But also, you can use,
inside the Business Central Power BI,
which is based on, for example,
the Dynamics 365
customer engagement data
or on your On-Premise data,
Excel SharePoint data,
if this Power BI,
doesn't matter on which data
this Power BI report is created,
you'll be able to embed this
inside Business Central.
So let's continue
with advanced feature of
Dynamics 365 Business Central
and Power BI. Steven.
>> All right. So we
have seen how we can
create reports and you have
also seen how you can create,
for example, a dashboard.
But a Power BI also has
many more capabilities.
So you can connect
your reports with data
coming from Business Central
but also other Dynamics
365 Applications
or you can use data
coming from the CDM,
the Common Data Model, the CDS,
the ECCN extent with some log
on in using Power automates,
which can also help you to
automate your decision processes.
So let me continue with
a small example and I
will jump over to a small demo and
for which I will also share
my desktop. Again, voila.
So here we are, and I
am back to Power BI.
You might remember that I created
this small report a
couple of moments ago,
where we see our Item Availability,
and in the report when
I created the report,
I also have here the number of
items with a negative availability.
That number of items with
a negative availability,
or something that I added
in Power BI Desktop,
and on purpose to be able
to show that fields,
I actually used this Card
visual from Power BI Desktop,
and the Card visual is
actually quite simple.
It allows you to display one value,
but the Card visual at the same
moment is also extremely powerful,
because if you have a Card visual
in your Power BI Desktop file,
and you publish the file,
so becomes available
online, and of course,
you also have the possibility
to pin this to your dashboard.
I have already created
a dashboard similar to
how Renato has done it,
and I've named my
dashboard Stock Overview.
So I use some of these visuals
from my reports to pin them,
to create a new dashboard,
which I've given the
name Stock Overview.
So as you can see here,
all my three numbers,
the item availability,
number of items with a
negative availability,
and my inventory and some visuals.
The interesting thing is that
if I click on one of these,
I will be redirected to
the underlying report.
What I've also done is I
have included some tile.
So you have the possibility
here to add a tile,
and this tile can, for example,
also link to an external website,
an image, or video, and so on.
But to be more interesting is that,
we not only would like
to learn from the data,
but we also would like
the system to take
action if something goes wrong.
That's where the power of
these Card visual come in,
and what you notice is that,
whenever I have a Card
visual on my dashboard,
I also have the possibility
actually to manage alerts.
So I can click on, "Manage Alerts",
and I can create an
alert for my tile.
I have already done that,
and in this alert,
I've actually told Power BI
that I would love to get
a notification whenever the value
of this tile is above zero,
and I would like to be notified,
for example, one time a day,
or one time an hour,
depending on the refresh of my data.
What will happen is
that if the number of
items with a negative
availability increases,
I will get notifications
within Power BI itself.
Now, Power BI can take care of that,
I can see the notifications in
the notification window
whenever it happens,
and if I go back to the
management of the alerts,
I also have a possibility to
send me an e-mail and save it,
but the e-mail will be
a pretty basic e-mail.
So the power of the
Power Suite and Power BI
is that I can also combine
that with Power Automate,
the application
formerly known as Flow,
or Power Automate is also a
part of the Office 365 suites.
So I have the possibility
to go to Power Automate,
and there I can create a new flow.
I have, of course,
already done that for
the purpose of this demonstration.
So let me go into the
Edit Mode of this flow.
Now, when you create a flow,
there are actually many steps
that you can choose from.
If you choose, for example,
the Power BI connector,
what you'll notice is that,
we have the possibility to take
action whenever something
in Power BI happens,
and what I have done is I
have added a step in here.
Whenever a data-driven alert
is triggered in Power BI,
I would like flow to take action,
and I'm using this
alert that I created in
Power BI for the number of items
with a negative availability.
So they go back to my report here.
For this tile, I have an alert,
and then whenever the
alert is triggered,
Power Automate can take over,
and the next step could be,
for example, send an
e-mail to someone.
But I would also change
this step, for example,
and look for a Business
Central connector,
and take action within
Business Central itself.
So within Business Central,
I can create a record,
for example, in the
user tasks, a table.
So I can warn a Business Central
user and the purchase department,
telling them you need to
buy some of these items,
or in production, you need to
start some production order.
So I also have these capabilities
all based on that alert,
and whenever you create
this flow in Power
Automate and you save it,
and whenever the alert
will be triggered,
then Power Automate can take over,
and automate the number of
processes that need to get started.
Now, you can even go a step further.
You can also combine, for example,
technology from Power Apps.
What I have done actually here,
is I have created an
app in Power Apps,
so within your Office 365,
you simply go to "Power Apps".
If you go to Power Apps,
and you've used Business
Central before, now,
what you'll notice is that
Business Central will
be a part of your connectors,
and you can very
quickly build an app.
So what I have done
here in Power Apps,
is I have created
a small app which is able to
connect to Business Central,
and it's also showing me my items,
and the inventory of these items.
I have an overview screen,
I have a detail screen,
I even have an added
screen that I can use.
Then this Power App, I published it,
and I made it available for
everyone within my organization.
Next step I'm back to
my reports in Power BI,
and you might have noticed
that within Power BI desktop,
there is also a Power App
visual that you can choose,
and I used that visual to embed
the Power App within
my Power BI report.
So also from within
the Power BI report,
I should be able to see the same app.
Depending on the added screen,
and that you provide for your app,
you even have the
possibility to change
some data with the
Power App, save it,
and then visualize it again
in the Power BI reports,
for example, to make the
circle completely round.
So I've done that, I can then
republish this reports to Power BI,
where it will also become available.
For example, if I go back here to
my reports, let's have a look.
This is the one, I also here have
that second page where
the Power App is
available in the report
within Power BI online.
Of course, once the report
is in Power BI online,
of course I have the
possibility then to
go back to Business Central,
and like Renato has explained
whenever you, for example,
embed the reports within
Business Central, of course,
the report can also
contain that Power App.
So you're able to combine all of
these technologies like
you would like to combine.
That you can create
your Power BI reports,
embed them in Business Central,
that you can create a
Power Automate to take
action based on alerts that happen,
and you can even include
Power Apps to communicate.
Behind the scenes,
Power BI of course,
is using the Power BI connector,
which is based on a
query and page objects.
Right now, you can publish
these query and page
objects as Web services,
but of course,
you can also create API
pages and API query,
so we got Power Automate,
and Power Apps can
also make use of that.
That's actually quite interesting
because it gives us the possibility
to embed that extra smartness
inside Business Central.
Giving the word back to Renato,
and this concludes my demo.
>> Thank you, Steven.
Very powerful demo
about how you can embed Power
BI inside the Business Central,
how you can use Power Automate
to automate your decision,
and then the last,
how you can, for example, edit
the data from the BI tool.
Usually we use the Power BI and
the BI tools to get the
insights to our data.
But now, you can also manipulate with
your data from the Power BI tool.
With this complete story,
we come to an end of this webinar,
an overview how you can use
Power BI with Dynamics
365 Business Central.
Now, we are here to answer
your questions if there
is any questions,
and if there is no questions,
we would like to thank
you for your attention.
Steven, maybe there is a
questions inside the chatbox.
>> Renato, we don't
see any questions.
>> Okay.
>> On the list.
>> That is right.
I hope that we demonstrate
all the capabilities
that you will use
later in your everyday business.
>> Yes. So since we don't
have the external audience,
so that should be one of
the reasons we're not getting
much questions on it,
but once we publish on the YouTube,
we might be getting more
questions over there.
>> Okay. Feel free to
reach Steven and me,
and we'll try to answer
all the questions.
>> All right. Thank you so much.
>> Thank you.
>> Thank you.
>> Thank you.
>> Goodbye.
