Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Using Web URL as Bookmarks while Publishing report to different workspaces

Hi All,   I have 4 different PBI Workspaces 1. Dev 2. Test 3. UAT and 4. Prod     and 3 reports in each Workspace (Report 1, Report 2 and Report 3)   I have a 2 Buttons  in Report 1 where I have...
General Comment
Interesting Links
Need Help
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Anonymous ,

     

    There is no way to dynamically change the report link, but we can manually switch the Group ID and report ID in the link.

    Please refer to my .pbix file.

    //Measure
Report URL = 
VAR x = "https://app.powerbi.com/groups/"
VAR y = SELECTEDVALUE('Table'[Group ID])
VAR z = "/reports/"
VAR a = SELECTEDVALUE('Table'[Report ID])
VAR b = "/ReportSection"
RETURN
x & y & z & a & b

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-lionel-msft's avatar
v-lionel-msft
Community Support
5 years ago

Hi Anonymous ,

 

There is no way to dynamically change the report link, but we can manually switch the Group ID and report ID in the link.

Please refer to my .pbix file.

//Measure
Report URL = 
VAR x = "https://app.powerbi.com/groups/"
VAR y = SELECTEDVALUE('Table'[Group ID])
VAR z = "/reports/"
VAR a = SELECTEDVALUE('Table'[Report ID])
VAR b = "/ReportSection"
RETURN
x & y & z & a & b

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.