Dynamic changing URL Link in Power BI

[UPF1KOR]

Hi All,

I am using Deployment Pipelines for deploying in Dev, Test and Production.

I have a requirement where user needs a button which has a URL. Trick here is, there are 3 URL's for each environment i.e. Dev, Test and Production.

I need to embed the url in such a way that, the dashboard in Dev should direct to Dev URL; and dashboard in Test should direct to Test and so

Option 1: Dirty way:

I have a table with only one row. The table in D contains url of D; Table in Q contains url of Q and so on.

Problem is: Its bad for deployment.

So, what can be best way to do this?

[andy808]

Hi there, did you ever solve this? I have the same requirement.

Thanks!

[UPF1KOR]

Hi @andy808 ,

As suggested by @amitchandak , I was able to solve this.

What I did was:

1. Created a simple table with 2 columns and 3 rows. First column mentions environment like Development, Testing, Production and the 3 rows contains the URL's.

2. Created a parameter and defaulted it to Development.

3. Filter the table (created in step 1) by parameter.

4. Deploy on Power BI Service/ Cloud.

5. Go to Setting-> Parameter.

6. You would find Development there. Modify that to Testing and SAVE.

7. Done, URL will change as per parameter selected.

[andy808]

Great, thank you so much for responding - that detail is helpful!

[amitchandak · Accepted solution]

@UPF1KOR , For that you can create a parameter with a list and use that in connection

refer video from Guyinacube: https://www.youtube.com/watch?v=XIq5vN5oPf8