Forum Discussion

patilpoonam21's avatar
patilpoonam21
Icon for Helper I rankHelper I
2 years ago
Solved

Dynamically change the URL link for different Environment in Power BI

Hi,   Currently in my 'Global' PBI file, I have a table and when I click on the column in the table 'PBICustLink' , it redirects me to the another PBI 'Customer' which has customer level informatio...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi patilpoonam21 ,
    Based on your description and the example data provided, I think you can dynamically change the URL links for different environments (development, test, and production) in Power BI by setting parameters.
    Here some steps that I want to share, you can check them if they suitable for your requirement.
    Here is my test data:

    1.Open power query and create a parameter and enter the values you want for your test environment or other dynamically changing values

    2.Right click the parameter and choose enable load to apply parameter

     

    3.Create a measure

     

    PBICustLink = 
    CONCATENATE(
        SELECTEDVALUE('Environment URL'[Environment URL]), 
        "/reports/&filter=OpenInv%2F" & SELECTEDVALUE('Table'[Customer]) & " eq " & "%" & 27 
    )

     

    4.Final output

    Replace any value in the measure as you see fit.

    You can refer to these documents to learn more about parameter settings:
    Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI
    Use parameters to visualize variables - Power BI | Microsoft Learn

     

    Best regards,

    Albert He

     

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





Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi patilpoonam21 ,
Based on your description and the example data provided, I think you can dynamically change the URL links for different environments (development, test, and production) in Power BI by setting parameters.
Here some steps that I want to share, you can check them if they suitable for your requirement.
Here is my test data:

1.Open power query and create a parameter and enter the values you want for your test environment or other dynamically changing values

2.Right click the parameter and choose enable load to apply parameter

 

3.Create a measure

 

PBICustLink = 
    CONCATENATE(
        SELECTEDVALUE('Environment URL'[Environment URL]), 
        "/reports/&filter=OpenInv%2F" & SELECTEDVALUE('Table'[Customer]) & " eq " & "%" & 27 
    )

 

4.Final output

Replace any value in the measure as you see fit.

You can refer to these documents to learn more about parameter settings:
Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI
Use parameters to visualize variables - Power BI | Microsoft Learn

 

Best regards,

Albert He

 

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





  • patilpoonam21's avatar
    patilpoonam21
    Icon for Helper I rankHelper I
    2 years ago

    Thank you Anonymous for the reply. 

    I tried the the solution suggested by you and changing the parameter value on cloud under parameter setting. However, for UAT environment it is still redirecing to the Dev url. Am I missing something?

     

    Thanks,

    Rinku

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi patilpoonam21 ,
      According to your description, you can follow the above steps to set the parameters to a more refined level, for example not only on your environment variables, but also your back redirection parameters, or you can check the following whether the redirected url address is restricted to external links that can only be clicked on to go to the developer's page or that the administrator is prohibiting jumping from external links.

      Best regards,

      Albert He

       

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

      • patilpoonam21's avatar
        patilpoonam21
        Icon for Helper I rankHelper I
        2 years ago

        Hi Anonymous ,

         

        As you specified, to change the parameter dynamically I need to change the URL in Cloud server under parameter setting so I changed it customer report UAT environment URL.

        Also, in Power BI desktop, I changed the measure as below:

         

         

        Still it is redirecting to the Dev URL. Is there anything else I need to change? 

         

         

        Thanks,

        Rinku