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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
cottrera
Post Prodigy
Post Prodigy

Power Bi & Power Automate question

Hi

 

I have a power bi report. On one of my report pages I have a card visual with a DAX count measure and a visual table of addresses. The report is conncted to a power automate flow that emails a group of people if the visual card is >1

I have added a hyper link to the body of the text. which allows the email group to navigate to the report.

 

The end users have request that I add the visual table with the addresses into the body of the email alert. Can anyone advise me how to do this or point me to a resorce that can.

 

I want this to be automatic based on my card visual threshold and not by manually pushing a button

 

Thanks

 

Richard

 

1 ACCEPTED SOLUTION
AllisonKennedy
Super User
Super User

@cottrera  It's been a while since I've worked with the Power BI connector in a flow, but at that time you could only get limited info from the Power BI dataset. 

AllisonKennedy_0-1646687315068.png

 

Looking at it now, the  Get Scorecards or Export To File for Power BI Reports might help?


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

View solution in original post

2 REPLIES 2
cottrera
Post Prodigy
Post Prodigy

Hi Alison , thank you for your quick response. I did check all the new connectors and I could only export the table to email via a button that has to be manually pushed.  I might have to wait until there are additional connectors.  regards  RIchard

AllisonKennedy
Super User
Super User

@cottrera  It's been a while since I've worked with the Power BI connector in a flow, but at that time you could only get limited info from the Power BI dataset. 

AllisonKennedy_0-1646687315068.png

 

Looking at it now, the  Get Scorecards or Export To File for Power BI Reports might help?


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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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