Update parameter value dynamically in power bi desktop dataset using c# code

[ramawatar]

Is there any option to update parameter value in power bi. Parameter may such as update connection string of date parmeter to filter data and reports accordingly parameter usin c# code while embedded report.

[jdm-q]

Any news on this case ? I would really need to be able dynamically change other parameters based on 1 defined parameter. 

[ramawatar]

I have a power bi report, in which i have multiple parameter. Is there is option to update parameter value dynamically using c# code.

I also used power bi rest api which allows manipulation on table and parameter which was created from Power BI REST API.

[zoloturu]

Hi @ramawatar,

Let me know sense behind your parameter. For which purpose you need it? There are no ability to change parameter, but maybe I can give you an alternative.

You can vote for it at the forum There are some similar ideas posted. Once Microsoft approve it then it can be added to functionality.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15356220-change-parameters-from-t...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32764327-report-parameter-like-ss...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17849464-enable-parameters-on-pow...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18735895-parameters

[Anonymous · Accepted solution]

HI @ramawatar,

No, you can only manually modify query parameters. 

For your requirement, I'd like to suggest you use other source as parameters, then you can modify the source to achieve dynamic change result.

For e.g:

Parameters are stored in csv file, then use csv connector to get data.
Create new query use above records(as parameters).

Regards,
Xiaoxin Sheng