Forum Discussion

PowerrrBrrr's avatar
PowerrrBrrr
Icon for Helper III rankHelper 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.

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
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.