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.
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
Solved! Go to Solution.
@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.
Looking at it now, the Get Scorecards or Export To File for Power BI Reports might help?
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
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
@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.
Looking at it now, the Get Scorecards or Export To File for Power BI Reports might help?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |