The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have set up Flows to trigger on Dashboard Alerts. The flows create work items and alert emails.
Since I cannot retrieve the row data from Power BI table, I need a link in the work item to link back to a filtered table (different filters for each alert).
Since Alerts can only be used on numeric data types, I have the filtered tables pinned on the dashboard as well as row counts for each table. I copied the URL of each filtered table while in focus view and set the Custom URL of each count tile to link to the focus view of its respective focused filter table.
In my flow, I want to use the Tile URL to link back to the filtered table (the Custom URL that I set), but the Url that is sent goes to the focus view of the Count Tile.
Custom URL for Count Tile (upon which the alert is set):
https://---.powerbi.com/groups/---/dashboards/---/tiles/53232313---/infocus
Url recieved by flow:
https://---.powerbi.com/MobileRedirect.html?action=OpenTile&groupObjectId=---&dashboardObjectId=---&...e2efa521---&OpenAppFromWindowsPCAndTablet=false&context=Flow
Final destination:
https://---.powerbi.com/groups/---/dashboards/---/tiles/e2efa521---/infocus
53... is the url of the filtered table in focus
e2... is the url of the count tile in focus
How can I send my users back to the filtered report table without copying and pasting 11 urls into 11 flows (i have 11 filtered tables on the dash)? Why is the custom Url not being sent to flow?
(Update: Cross posted to the ideas forum: http://community.powerbi.com/t5/Issues/Custom-URL-on-Dashboard-Tile-does-not-come-thru-Alert-data-as...)
I have set up Flows to trigger on Dashboard Alerts. The flows create work items and alert emails.
Since I cannot retrieve the row data from Power BI table, I need a link in the work item to link back to a filtered table (different filters for each alert).
Since Alerts can only be used on numeric data types, I have the filtered tables pinned on the dashboard as well as row counts for each table. I copied the URL of each filtered table while in focus view and set the Custom URL of each count tile to link to the focus view of its respective focused filter table.
In my flow, I want to use the Tile URL to link back to the filtered table (the Custom URL that I set), but the Url that is sent goes to the focus view of the Count Tile.
Custom URL for Count Tile (upon which the alert is set):
https://---.powerbi.com/groups/---/dashboards/---/tiles/53232313---/infocus
Url recieved by flow:
https://---.powerbi.com/MobileRedirect.html?action=OpenTile&groupObjectId=---&dashboardObjectId=---&...e2efa521---&OpenAppFromWindowsPCAndTablet=false&context=Flow
Final destination:
https://---.powerbi.com/groups/---/dashboards/---/tiles/e2efa521---/infocus
53... is the url of the filtered table in focus
e2... is the url of the count tile in focus
How can I send my users back to the filtered report table without copying and pasting 11 urls into 11 flows (i have 11 filtered tables on the dash)? Why is the custom Url not being sent to flow?
(copied post from Service Forum, as this is an issue that may need to be implemented for release. Original Post: http://community.powerbi.com/t5/Service/Custom-URL-on-Dashboard-Tile-does-not-come-thru-Alert-data-a...
)
The count tile and filtered table tile in a dashboard are independent from each other, when the count tile triggers alert, it won't send the filtered table tile information, though those two tiles are from the same report. Let's suppose if there're 3,4,5 or more tiles from a report, when count tile triggers alert, shall they all be sent in the mail? So I think it is by design and you'll have to copy and paste the custom URL at this moment.
I think you can submit your request at Power BI Ideas.
I think you're misunderstanding what I'm asking to do.
The count tile already has a setting for custom URL. I have set the custom URL of the tile to open one filtered table in focus. If I click on the count tile in the dashboard, it does this.
So when the alert fires for the count tile, it should send the custom URL, not it's default URL.
However, after thinking about the default behavior of clicking on the tile, it is to go to the report that generated the tile, not to focus on the count tile. So I will submit this as an idea.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
24 | |
14 | |
14 | |
12 |
User | Count |
---|---|
106 | |
39 | |
28 | |
22 | |
22 |