Forum Discussion
Helper IDynamically 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 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.
I want to dynamically change the PBICustLink based on the enironment Dev, Test and Prod. Can anyone please help?
Thanks,
Rinku
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 LearnBest regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
5 Replies
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 LearnBest regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
patilpoonam21Thank 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
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