Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ramawatar
Frequent Visitor

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

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.

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
jdm-q
Regular Visitor

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

ramawatar
Frequent Visitor

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.

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

v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors