Dynamically change the URL link for different Environment in Power BI

[patilpoonam21]

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

I am providing the Web url of the 'customer' pbi and filtering it to the customer level to get the record of each customer.

Customer	PBICuslink	0-31 Past Due
A	Customer - Power BI&filter=OpenInv%2FA eq %27	10
B	Customer - Power BI&filter=OpenInv%2FB eq %27	12
C	Customer - Power BI&filter=OpenInv%2FC eq %27	13
D	Customer - Power BI&filter=OpenInv%2FD eq %27	14
E	Customer - Power BI&filter=OpenInv%2FE eq %27	16

I want to dynamically change the PBICustLink based on the enironment Dev, Test and Prod. Can anyone please help?

Thanks,

Rinku

[Anonymous · Accepted solution]

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

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]

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]

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

[patilpoonam21]

Sorry for the confusion. I got an error while refreshing the dashboard so the changes couldn't reflect.

Thank you again for the detailed instructions.