Forum Discussion

Truthahn195's avatar
Truthahn195
Frequent Visitor
3 years ago
Solved

Power Bi and Python - Interactive user input with parameter

Hello everyone,   I have a python code simulating several scenarios, for which I want to display the results in Power Bi. Since the user should be able to change values of the scenarios, I created ...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Truthahn195 

    According to your description, do you want to change the value of the parameter on the dashboard?

    The parameters created in Power Query are generally used to modify the data source path. And the parameters created in Power Query are currently published to Power Bi Service, and only support modification in "Paramter".

    And the parameter modification in Power Query generally involves the refresh of the dataset after modification. At present, it is not possible to modify it on the report page.

    For more information, you can refer to :
    Parameters - Power Query | Microsoft Learn

     

    Secondly, the what-if parameter in Power BI Desktop is generally used for slicers, which is equivalent to a fixed table imported into our report, and you can refer to the specific usage steps:

    Power BI Parameters | How to Create and Use Parameters in Power BI? (wallstreetmojo.com)

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , Truthahn195 

According to your description, you create a parameter in Power Query Editor and use it in the Python code.

For this ,it works , and the parameter can be updated in Power BI Service too.

We can go to the "Parameters" setting in the dataset configuration :

And it have the limitation:

Grayed-out fields aren't editable. Any and Binary type parameters work in Power BI Desktop. The Power BI service doesn't currently support them for security reasons.

 

For more information, you can refer to :
Edit parameter settings in the Power BI service - Power BI | Microsoft Learn

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly