Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Subscription with validation

Hi all,

My goal is to share schedulated update to users with updated PBI report, via email with link and picture (of report page). Curently I use PBI scheduled subscription, but the downside is that it doesn't check if report was actualy updated correctly. 
I can create an alert that checks if report was updated and then use PowerAutomate to create a flow that sends an email, the problem here is that i can't put an image of the report page in the email.

 

Both features (update check and picture) are crucial.

 

Any suggestions?

1 ACCEPTED SOLUTION

Yes, @Anonymous 

 

IF you want to add an image from the Power BI report into the mail what you can do is to take a screenshot of the image and then put it in the Power Automate just like the email from Power BI. which you received!

 

Have a look at this too what if it might help you

https://medium.com/analytics-vidhya/setting-up-power-bi-subscriptions-for-external-users-using-outlook-free-5ab5bd7a85d9

 

IF YOU LIKE MY ANSWER PLEASE ACCEPT IT AS A SOLUTION AND GIVE KUDOS

 

Regrads,

Nimai

View solution in original post

15 REPLIES 15
Nimai123
Post Patron
Post Patron

Hello @Anonymous 

You can try this!

 

What we can do is while creating a flow for the Email subscriptions we can add an image over there and the link of the report, so as the data will be updated the Flow will be triggered and mail will be sent with the Link and the Image!

 

And yes, as you said Power BI email subscriptions doesn't check for the update before sending the emails.

 

If you like my solution give it a Kudos!

And if it solves your problem accept it as a solution.

 

Regards,

Anonymous
Not applicable

Hi @Nimai123 ,

 

Indeed it seems like a possible solution. Could you plese elaborate on how do you add an image of selected report page to the body of email generated in the Flow?

 

Thank you

Anonymous
Not applicable

Hi @Nimai123  , I tried your solution dut it doesn't work. I think the problem is that I want to add an image of the web page from PBI report, so my input is a link to powerbi report, not an image. Do you have a solution for this scenario? Thanks

Yes, @Anonymous 

 

IF you want to add an image from the Power BI report into the mail what you can do is to take a screenshot of the image and then put it in the Power Automate just like the email from Power BI. which you received!

 

Have a look at this too what if it might help you

https://medium.com/analytics-vidhya/setting-up-power-bi-subscriptions-for-external-users-using-outlook-free-5ab5bd7a85d9

 

IF YOU LIKE MY ANSWER PLEASE ACCEPT IT AS A SOLUTION AND GIVE KUDOS

 

Regrads,

Nimai

Anonymous
Not applicable

Hi @Nimai123  ,

Can I take a screenshot of my Power BI report in Power Automate?

Thanks

Daniel

hello @Anonymous 

 

We cannot take a screenshot from the automate but we can attach a screenshot in the body of the mail manually in Power Automate.

 

Regards,

Anonymous
Not applicable

Hi @Nimai123 ,

By doing that the flow in power automate will not be automate , 

there is another way to make a PBI report to a IMG?

or to make the flow fully automate?

thanks

Daniel

Hello @Anonymous 

 

I understand your concern you have to do it manually once, and for the future, it will be automated!!

 

Because we are working on a Workaround so we have to manage certain things.

 

Regrads,

Anonymous
Not applicable

I'm sorry @Nimai123  , but i lost you.

Can you please explain the whole process ?

1)Taking a screenshot of my report.

2)saving in my dextop

3)putting as a image to the automate.

4)running the process?

but whan i will refreshe the report how the screenshot will refresh?

Thanks 

Daniel

Anonymous
Not applicable

Thank you @Nimai123 

 

I will try it and let you know

AllisonKennedy
Super User
Super User

What do you mean by 'report was updated'? Does the data not change every day or are there errors happening in the report refresh?

Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Anonymous
Not applicable

Sometimes refresh doesn't succeed due to errrors or due to premium capacity overload

Hi there

For report subscriptions is this Power BI reports or Paginated reports?

It would appear to be paginated reports? If so I would look at either scheduling them at a time when you have more resources available. Or to to increase the memory allocated to Paginated reports.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Hi @GilbertQ ,

 

For PBI reports and errors not always are caused by refresh, the data itself can be incorrect and thus I need to run few checks before releasing

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors