Forum Discussion

PowerrrBrrr's avatar
PowerrrBrrr
Helper III
5 years ago
Solved

How to create a template which takes a parameter

I have an api which I use in my power Bi desktop file to fetch my data. I have this filter http://..... ?Filter = 'Project' eq 'Abc' for one user and for other users there are other Project values wh...
Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi PowerrrBrrr 

     

    Agree that you can create a query parameter for project names in Power Query Editor. When you connect to your api with Web connector, select Advanced option and split the url into several parts. For project name part, select the parameter for it. 

     

    Or you can also connect to your api with a fixed project name to create a query first. Then open its Advanced Editor, use the parameter to replace the fixed project value part in Source step. Use & to join them. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

parry2k's avatar
parry2k
Super User
5 years ago

PowerrrBrrr yes you can surely do this, create two parameters in power query, use these parameters in URI instead of fixed value, save file as power bi template. Next time whenever a user will open the pbit file, it will ask for the parameter value and then URI will get updated based on the parameter value. Read more here on parameters Parameters | Microsoft Docs

 

✨ Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡