Forum Discussion

UPF1KOR's avatar
UPF1KOR
Frequent Visitor
3 years ago
Solved

Dynamic changing URL Link in Power BI

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?
Need Help

5 Replies

  • andy808's avatar
    andy808
    Resolver I
    2 years ago

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

    Thanks!

    • UPF1KOR's avatar
      UPF1KOR
      Frequent Visitor
      2 years ago

      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's avatar
        andy808
        Resolver I
        2 years ago

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