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 given the Web URL of report 2 and report 3 as bookmarks, so that when the user clicks on any of the button, it will take them to the corresponding report in a different tab.

 

My concern is , once development is done  , I have to migrate these reports to Test, UAT and then to Prod.  So, do I  need to go to the report and chnage the URL each time when I deploy these reports to any of the higher workspaces . (I beleive URL will be different in each workspace).

 

Is there a dynamic way throgh which we can achieve this .? Like when I migrate the report from Dev workspace to Test Workspace, the  the button changes to its correspodning workspace URL.

 

requesting help

 

 

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.

1 Reply

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