cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SaaM
Helper II
Helper II

PBI Premium - Subscriptions - Send the whole report (hidden and shown pages)

Hi guys,

 

I have a report with 18 pages (15 hidden and 3 shown).

I want to receive the whole report (18 pages) in PDF every day.

So I did this:

I created a mail subscription with selecting the options:

  • Screenshot of a page
  • Enclosure of the report as PDF.

SaaM_0-1619010305870.png

But the PDF contains only the show pages (3 pages) and does not include the remaining 15 pages.

 

Does anyone know if we can exclude/include pages for a subscritpion like mine, without unhidden the pages in the original report ?

 

Thanks in advance

 

Kind regards

Saam

 

1 ACCEPTED SOLUTION
selimovd
Community Champion
Community Champion

Hey @SaaM ,

 

as far as I know this doesn't work with the subscription.

You can activate to show hidden sheets with Power Automate and the creation of a PDF in there. But this need Premium or Premium per User. Would that work for you?

 

The "low cost" alternative is to duplicate the report for the subscription and make all the pages visible.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

3 REPLIES 3
selimovd
Community Champion
Community Champion

Hey @SaaM ,

 

as far as I know this doesn't work with the subscription.

You can activate to show hidden sheets with Power Automate and the creation of a PDF in there. But this need Premium or Premium per User. Would that work for you?

 

The "low cost" alternative is to duplicate the report for the subscription and make all the pages visible.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

Hi @selimovd ,

Actually, I have an account Premium per user but i don t know how to use it with Power Automate, do you have any resources about that point ?

Thanks in advance

selimovd
Community Champion
Community Champion

Hey @SaaM ,

 

sure, check the following tutorial:

Export and email a report with Power Automate - Power BI | Microsoft Docs

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates