(upbeat music)
NARRATOR: And so, in this final demonstration,
let's finish off our report development work
beyond report development,
by taking a look at URL parameters and subscriptions.
So this is where we left off earlier,
having rented our report,
that we published up to the surface.
And so when I come to the file menu here,
I can open up generate link.
And here is a link to the report,
including the parameter selection that's been made.
CHRIS: Yes, it will be at the end of the URL.
NARRATOR: All right, let's copy this.
And I'm just gonna paste it into notepad,
so it's a little easier to see.
All right, there's a bit of encoding going on here.
But the parameter, see here,
report parameter named date fiscal year,
is here to here.
Because it's mdx,
it's actually a hierarchical path to get to it.
But, let's take a look at this.
FY2019.
So what I'm gonna do is modify that to the previous year,
2018,
and I'm going to append to the query string
with the ampersand,
idl colon format
equals
PDF.
So now here's a request in a single URL,
to download the PDF of the 2018 sales performance.
So in a new web session, I'll just paste that URL in.
And there it is.
What does it mean for our expand and collapse drill down?
(both laugh)
So here's an example where toggling visibility
isn't a good choice, if you intend to render it as PDF.
Or if you do, I've done this enough before.
Because,
we want the same report to work for different formats.
So, I would add a report parameter that says,
expand all, yes or no.
CHRIS: Yep.
NARRATOR: And if you then set that to
no,
then
that would be the default.
In HTML, well then would expand as we need it.
But if my intention is to print it or output to PDF,
I'd set that parameter to Yes.
An expression would be assigned
to the toggling visibility
and then we would see all data.
Right.
The second part of this demonstration then
is to explore subscriptions.
I would like to have this sent to myself
or to others on a schedule basis.
So up on the menu, I simply open up subscribe,
and it's here,
where I'm gonna go ahead and click to add a subscription.
CHRIS: You already are adding a subscription.
NARRATOR: And now that I've added to the subscription,
thanks, Chris,
then, we can choose format.
Here's where we wanna be careful with parameters.
If we intend to use defaults, what are we gonna do, Chris?
CHRIS: If you wanna use the default parameters,
then you wanna use the default parameter option.
If you've entered values,
or if you choose use current and haven't typed anything,
you will end up using the defaults as well.
NARRATOR: Okay.
This is where you can enter email addresses,
the subject and the message for the email,
the frequency from annually to monthly,
the start date to the end date.
CHRIS: Yes.
NARRATOR: Do you think we need a link?
CHRIS: Normally, you want to include a link
so people can go back to the report, if they so choose.
However, there are customers who would prefer
just to send an attachment,
so you can hide that optionally.
NARRATOR: What about if we send the subscription
to someone that's never internal,
and so they could never open it anyway?
CHRIS: Well, actually,
that's a feature that is being rolled out
here in the coming weeks,
depending on when you're watching this.
It may be already available,
and the idea there is,
if you include a link and include access to the report,
they'll actually have a workflow to come back
and be edited as a user in the Active Directory there
for the tenant, so it goes to the b2b workflow,
and they would then be able to view it in the surface.
NARRATOR: So it's still relevant
to the link CHRIS: Yes.
Exactly.
NARRATOR: Cause they can be granted guest privileges.
CHRIS: Yep.
NARRATOR: And then the preview image.
What does that look like? I've not seen it.
CHRIS: So,this is actually a different scroll,
a little bit different than what we do with SSRS.
With Power BI reports today,
when you go and set up a subscription,
it gives you an image of the page that you've chosen.
One of the things we added here is,
wouldn't it be nice to still give people that nice preview
of the first page of their report
directly in the mail itself?
So we give you that preview image there.
You can choose to have it or not,
but you'll still get the report attached.
NARRATOR: Is it like a thumbnail? Or it's a lot?
CHRIS: No, it's a full size picture.
NARRATOR: Right.
So, we will save and close
and then Power BI will look after that for you.
You do have the ability to run immediately,
if you want to test it
or this is where you could choose to disable
or when you're done about enough, delete the subscription.
CHRIS: Yep.
NARRATOR: Awesome.
I think that brings us to the end of our story, Chris
and paginated report there.
CHRIS: Thanks.
NARRATOR: Alright, thanks for watching.
Stay tuned for some bonus content
that rounds up, the rest for this course.
Thank you.