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.

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.

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.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.