Forum Discussion

Razorbx13's avatar
Razorbx13
Icon for Post Patron rankPost Patron
5 years ago
Solved

Parameters in Service

I have created a parameter in Power Query, applied it to tables, published to the service and confirmed the parameters in the dataset settings.  How does a user, accessing a report, modify the parame...
Show and Tell
  • Razorbx13's avatar
    Razorbx13
    5 years ago

    So yes, it is imported data.  So you are saying there is no way to create parameters that a user can enter in the service?  Basically have to use a filter?  

  • Fowmy's avatar
    Fowmy
    5 years ago

    Razorbx13 

    Yes, you are right. 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 years ago

If you are using an Import option for your data source then you cannot modify values of the parameters in the service at run time.

If you are using a Direct Query, you can leverage the Dynamic M query parameters in Power BI Desktop option to allow the user to change the values.




Razorbx13's avatar
Razorbx13
Icon for Post Patron rankPost Patron
5 years ago

Well that kind of sucks.  Hopefully they will fix that.  Or at least I assume this is something people would like.