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 Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.