Usage Metrics: URL to actual report in PBI service?

[sasdfasdfsad]

From inside the usage metrics data model, is it possible to build a URL that takes you to the actual report whose metrics are being shown?

If I get my top 5 used reports in the usage metrics, is there a way to make a URL link so I can click the link to see the actual report whose metrics are being shown?

[Jai-Rathinavel · Accepted solution]

@sasdfasdfsad It is possible to create dynamic URLs using a Measure and don't forget to format it as Web Url

1. Create a DAX Measure like below

Report_URL = 
VAR WorkspaceId = SELECTEDVALUE('Table'[WorkspaceID])
VAR ReportId    = SELECTEDVALUE('Table'[ReportID])

RETURN 
IF(
    NOT ISBLANK(WorkspaceId) && NOT ISBLANK(ReportId),
    "https://app.fabric.microsoft.com/groups/" 
        & WorkspaceId 
        & "/reports/" 
        & ReportId 
    BLANK()
)

2. Format the measure as Web url and drag the measure to a table visual. 

[v-saisrao-msft]

Hi @sasdfasdfsad,

Have you had a chance to review the solution we shared by @Jai-Rathinavel ,@vojtechsima ? If the issue persists, feel free to reply so we can help further.

Thank You.

[vojtechsima · Accepted solution]

Hey, @sasdfasdfsad ,

if you want to reuse original Usage Report semantic model, you can't directly add stuff to it, but you can create your own custom report linked to it.

In fresh Power BI Desktop connect to the model:

Then create a new measure like this:

URL = 
var base = "https://app.powerbi.com/groups/"
var report_id = MAX(Reports[ReportGuid])
var group_id = MAX(Reports[OwnerGroupGuid])
var link = base & LOWER(group_id) & "/reports/" & LOWER(report_id)

return link

Set it as Text and WebUrl.

and then you can build your own report with the link as a column.

[Jai-Rathinavel · Accepted solution]

@sasdfasdfsad It is possible to create dynamic URLs using a Measure and don't forget to format it as Web Url

1. Create a DAX Measure like below

Report_URL = 
VAR WorkspaceId = SELECTEDVALUE('Table'[WorkspaceID])
VAR ReportId    = SELECTEDVALUE('Table'[ReportID])

RETURN 
IF(
    NOT ISBLANK(WorkspaceId) && NOT ISBLANK(ReportId),
    "https://app.fabric.microsoft.com/groups/" 
        & WorkspaceId 
        & "/reports/" 
        & ReportId 
    BLANK()
)

2. Format the measure as Web url and drag the measure to a table visual.