Can we run a batch file form Power BI or Power BI service ? if so how can we do that ?

[ramshoney1225]

Hi 

Can we run a batch file form Power BI or Power BI service ? if so how can we do that ?

The requirement is i will pass a value from slicer , lets assume that slicer hold ( 5, 10, 15, 20, 25 ) values.

When i select the value 25 and Click on Submit,  The submit button ( need to hold the batch script ) that should take the value 25 and need to pass it some other location where it will pass the value in some optimization rule and will generate some table output and that table output need to displayed in Power BI Table report.

If required, will provide more information.

at this point of time, do we have an option to run a batch file / script from Power bi desktop / Power BI service through gateway ?, if so please provide the help document.

Thanks,

Ramesh Konda.

[v-yingjl]

Hi @ramshoney1225 ,

I'm afraid there is no option about batch file in power bi desktop and power bi service currently. If you want to pass value, you can try to set a parameter from power queries in power bi desktop and you can also use it after publishing to service under dataset settings.

You can refer the following microsoft blog and document that could also help you:

1. https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
2. https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Best Regards,
Yingjie Li

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

[Greg_Deckler]

Best you are going to do is PowerAutomate but this does not really sound like an application for Power BI. Sounds like you are trying to fit a square peg in a round hole.

[bheepatel]

Hi @ramshoney1225 

One possible option I can think of is using Parameters. 

Parameters are something you can define in the Query Editor and use it within your queries in the query editor.

When you publish from Desktop to Service, you can change the Parameters by going to the Settings option for a dataset. When you change it, it will refresh the queries that use that Parameter.

Hope this helps!