Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change parameter from query URL

I have a PowerBI report that pulls data from Azure DevOps using an OData query. In my dekstop data I created a parameter called 'Project' This parameter is used in my odata query: https://analytics....
Need Help
  • SteveCampbell's avatar
    SteveCampbell
    6 years ago

    You cannot pass a value from the user. The only option would be to load all the parameter into the file, then you can have a slicer to select one. Otherwise you would need some custom visual coding.

     

    You change the parameter in the app settings.,Go to the DATASETS, go to the dataset settings and look under "Parameters". It's in the same place you can schedule refresh.

     

    Note: If using parameters in a URL using Web.Contents function, you will need to separate to the parameter and add to relative path. See:

    https://blog.crossjoin.co.uk/2019/04/25/skip-test-connection-power-bi-refresh-failures/

     

    Appreciate your Kudos
    Connect with me!

    Stay up to date on  
    Read my blogs on  

SteveCampbell's avatar
SteveCampbell
Memorable Member
6 years ago

You cannot pass a value from the user. The only option would be to load all the parameter into the file, then you can have a slicer to select one. Otherwise you would need some custom visual coding.

 

You change the parameter in the app settings.,Go to the DATASETS, go to the dataset settings and look under "Parameters". It's in the same place you can schedule refresh.

 

Note: If using parameters in a URL using Web.Contents function, you will need to separate to the parameter and add to relative path. See:

https://blog.crossjoin.co.uk/2019/04/25/skip-test-connection-power-bi-refresh-failures/

 

Appreciate your Kudos
Connect with me!

Stay up to date on  
Read my blogs on