Use a Conditional Preview Image in Paginated Reports subscriptions in Power BI

Recently in Power BI, a new feature was added for Paginated Reports e-mail subscriptions where you could optionally add a preview image in the body of your e-mail message.  By default, this is the first page of your report.  However, it doesn’t have to be.  For example, in my e-mail subscription, I see the following preview image –

image  

But when I view the report in the PDF attachment or in the web, I see the following report links as my first page –

image

How is this possible?

Well, one of the cool things you can do with Paginated Reports is set the visibility of items in your report to be conditional.  You do this by adding an expression that sets the condition for when it should be shown or hidden.  Since the preview image in your e-mail subscription uses the “IMAGE” output format, all I did was set the visibility of an item to be conditional based on that.  So I took all of the items you see in that preview image and added them to a tablix, then made that conditionally visible based on the following expression –
=ucase(Globals!RenderFormat.Name) <> “IMAGE”   

Now, the report renderer knows to hide that part of the report whenever the renderer is something other than the “IMAGE” output format.  I’ve attached the sample report below so you can try this out yourself.  You can test this in the Power BI service (if you have Premium) by setting up a new e-mail subscription with it, or in Power BI Report Builder by exporting it to a TIFF file.

Download Sample Report

Thanks for reading!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s