Custom URL on Dashboard Tile does not come thru Alert data as Tile URL

[michowl]

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...)

[michowl]

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...

)

[michowl]

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...

)

[Eric_Zhang]

@michowl

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.

[michowl]

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.