cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

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

3 REPLIES 3
Highlighted
Regular Visitor

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

 

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

)

Microsoft
Microsoft

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

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

Highlighted
Regular Visitor

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

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.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Solution Authors
Top Kudoed Authors