►
Description
Watch this short demo on a Naughty or Nice + Present Tracker using Power BI and Power Apps integration by Microsoft MVP, Jese Navaranjan (@JeseNav2)
For more information, visit https://powerapps.microsoft.com/
This demo was taken from the December Power Apps community call
https://youtu.be/VTqpi_izZ9Q
Stay connected
Twitter https://twitter.com/microsoft365dev
YouTube https://aka.ms/M365DevYouTube
Blogs https://aka.ms/M365DevBlog
A
I
am
going
to
go
and
look
at
how
we
can
track
all
this
in
power
bi
so
that
that's
going
to
be
the
start
and
then
I'm
going
to
show
the
power
up
visual
within
power
power
bi.
So
something
I
get
really
excited
about
is
like
the
integration
between
all
these
different
layers
and
then
using
power
automate
to
actually
refresh
that
power.
Bi
data
set.
B
A
So
I'm
in
my
workspace
here,
I've
just
put
it
into
my
workspace
and
I
have
a
report
here
called
santa's
present
tracker
and
on
here
we
see
a
timeline
of
events,
so
we
see
when
this
first
started.
So
can
you
imagine,
we've
been
working
on
this
in
september
and
so
back
in
september,
sharon
was
naughty.
We
had
myself
there
as
naughty
as
well,
and
then
you've
got
a
lot
of
today
where
you've
got
quite
a
few
of
these
different
events
here.
A
So
I'm
expecting
to
see
what
I've
got
it.
I've
got
it
open
here,
so
I'm
just
gonna
show
it
here.
Instead,
I
thought
that
was
published,
but
here
you
can
see
all
of
our
naughty
and
nice
people
on
our
timeline
and
then
we've
got
our
little
pie
chart
anyone
that
doesn't
like
a
pie
chart.
I
love
them.
I
think
they're
so
simple
to
use
so
you've
got
our
nice
people.
There.
We've
got
the
wow,
the
geographical
distribution.
Here,
we've
got
australia,
we've
got
europe,
we've
got
north
america
so
quickly.
A
We
can
have
a
look
at
who's,
naughty
and
nice
on
our
list
now.
The
other
page
here
is
essentially
our
elf
factories.
As
a
supervisor.
We
want
to
be
able
to
come
into
a
report
and
quickly
see
how
are
things
going,
so
you
can
see
our
inventory
very
quickly,
so
we've
got
our
cloth,
our
diamond
our
gold.
We've
got
our
metal.
That
clarissa
was
using
to
build
jamie's
present
there
and
we
can
see
everyone's
presents
that
that
have
come
through
here
and
I
think
the
elf
was
a
cara.
A
That
was
a
task
to
build
jamie's
present
there.
So
he
had
the
matchbox
car,
so
it's
been
manufactured,
so
we
can
see
that
and
cara
was
able
to
build
that.
If
I
take
off
our
filter
on
our
elves,
we
can
see
all
our
different
elves
that
we
have
here.
We
can
see
a
bit
of
information
about
them.
So
as
a
manager
and
supervisor,
I
can
quickly
see
who's
working,
so
you've
got
bob
there
cara,
elena
felix
you've
got
their
ages,
you've
got
their
height
and
their
favorite
color
and,
of
course,
power
bi.
A
Anything
that
I
kind
of
start
clicking
around
we'll
start
interacting.
Some
of
that,
so
jamie's
present
is
not
requested,
but
it's
in
the
manufactured
area
there.
So
I
can
see
that
now
what
I've
done
here
is
we've
got
this
little
elf
icon
up
here.
So
if
I
click
that
my
power
app
will
appear,
I'm
actually
going
to
go
back
to
my
web
page
and
see
if
that's
actually
loaded
now
I
think
it
just
didn't
refresh.
A
If
I
click
on
my
app,
my
power-up
appears
so
I
can
now
actually
go
into
the
the
elf
production
line
and
I
can
see
what
cara
is
doing.
For
example,
I
can
see
that
she's
got
jamie's
present,
which
is
resourced,
manufactured
wrapped
and
packed
and
clearest
precedent
is
resourced
and
manufactured.
So
how
did
I
actually
do
this?
Let's
have
a
look
at
that
back
in
the
desktop,
as
that's
opening
I've
essentially
pulled
in
all
the
extracts
from
dataverse.
A
A
So
I've
brought
in
this
app
here
and
what
it
will
ask
me
is
to
kind
of
put
in
some
data
fields.
So
I
know
that
that
app
that
clarissa
has
built
has
some
of
these
fields
in
there.
So
as
soon
as
I
do
that
it
will
allow
me
to
either
create
an
application
or
to
choose
an
existing
application,
so
I'm
going
to
go
for
an
existing
one
and
I've
chosen
the
present
production
line
and
that's
how
easy
it
is
to
bring
my
power
up
into
here.
A
So
I
guess
you
know
the
reason
I
wanted
to
kind
of
show.
This
is
that
you
know
a
lot
of
time.
This
is
obviously
a
santa
kind
of
made
up
kind
of
scenario,
but
a
lot
of
time
working
with
clients.
You
do
see
that
having
that
power
up
and
power
bi
integration
can
be
really
useful,
especially
when
you
want
to
make
decisions
on
the
power
bi
report
that
then
impact
data.
A
So
I
could,
you
know,
see
it
see,
trends
and
graphs,
and
I
might
want
to
create
actions,
but
I
don't
necessarily
want
to
come
out
of
my
power
bi
report
in
order
to
do
that
now.
The
other
thing
that's
happening
here
is,
of
course
we
want
our
power
bi
report
to
completely
stay
up
to
date,
as
we
go
through
this
process.
So
what
we
have
is
we
have
a
power
automate
in
the
background
that
actually
refreshes
that
data
set
as
soon
as
you
get
to
a
page
in
clarissa's
application.
A
Now
this
is
a
very
simple
flow
and
just
to
show
you
that
so
you've
got
your
first
step
there,
which
is
just
initializing
from
powerapps.
So
this
happens
when
you
click
a
button
and
then
we
refresh
our
data
set
and
it's
all
ui
driven.
So
I
can
click
the
my
workspace
and
then
I
can
go
to
santa's
present
tracker
and
then
I
can
save
that
and
whenever
that's
run,
it's
actually
going
to
refresh
the
power
bi
data
set
in
the
background.
A
So
that's
how
we
can
kind
of
bring
everything
together
so
just
to
point
out
kind
of
a
few
tips
here
when
we
do
use
that
refreshing
fabio
data
set
in
the
flow,
you
need
to
make
sure
that
you
are
signed
in
and
the
way
you
do.
That
is
you
go
to
your
workspace.
You
find
your
data
sets
that
santa's
present
tracker.
A
I
will
then
go
into
my
scheduled
refresh,
and
this
is
the
really
important
thing
you
need
to
make
sure
that
your
data
source
is
signed
in
here
and
that
all
of
your
data
sources
are
either
in
the
cloud
or
somewhere
on
the
web,
where
you
have
signed
in
so
really
important
to
kind
of
see
that
and
log
in,
because
when
you're
testing
you
might
find
that
you're
using
this
this
flow
and
it
doesn't
quite
refresh
the
data
set
straight
away.
A
So
that's
that's
that
power
bi
report
there
and
I
want
to
kind
of
talk
through
basically
everything
we've
spoken
about,
because
we
have,
as
the
three
of
us
essentially
brought
in
so
much
of
this
platform,
so
just
putting
that
on
the
screen
and
kind
of
talking
through
a
few
of
these
components,
and
so
we
have
cds,
I
should
have
renamed
it
as
dataverse.
I
hadn't
actually
done
that
yet,
but
this
is
the
data
store
for
the
output
of
the
pva.
A
A
We
have
our
naughty
or
nice
pva
over
here
and,
of
course,
we're
feeding
in
information
using
power
automate
into
our
cds.
We
then
have
our
power
bi
report
and
that's
taking
data
from
ces.
It's
also
using
power
automate
in
terms
of
when
you
click
a
button
within
our
power
app
within
our
power
bi,
and
we
also
have
our
two
apps
here.
So
we
have
our
model
driven
production
application
and
we
have
our
canvas
app
present
production
application.
A
B
B
I
noticed
in
jesse
when
you
showed
your
flow
that
did
the
refresh
for
the
power
bi
for
those
folks
on
the
call.
Who've,
never
seen
a
flow
before
we're
wondering
that
first
action
at
the
top,
it
said
power
bi,
that's
just
a
trigger.
Basically
that
means
this
flow
was
invoked
by
powerapps
and
jessie
pointed
out.
Is
it
a
button
and
so
that
button
that
she
puts
into
the
power
up
is
actually
what
kicks
that
flow
off?
B
I
just
wanted
to
point
that
out,
because
I
know
we
usually
have
people
on
the
call
who
haven't
seen
it
before
and
they
might
be
like
what
what
the
hell.
What's
that
thing,
all
about
very
fantastic-
and
you
know
what's
really
neat
about
your
report.
There,
too,
is
the
same
gentleman
who
who
spoke
up
and
said
he
made
the
app
that
I
mentioned
after
the
last
demo.
He
said
I'm
blown
away.
B
How
similar
the
real
life
usage
is
my
power,
be
I
dash
updated,
inventory
and
triggered
marketing
departments
to
be
able
to
speak
to
local
news
and
most
of
the
outlets
on
the
items
most
needed
and
so
like.
You
may
have
made
a
fun
little
santa
themed
thing
here,
but
it's
so
real
life
in
general
and
the
concepts
you're
talking
about
and
the
tools
that
you
we
would
use
to
build.
A
solution
like
that
very
well
done.