Forum Discussion
MokaSatya
Microsoft Employee
Microsoft EmployeeParameter to M Query
Hello Experts , I have a requirement to pass the parameter to M Query , below is the M Query generated by KUSTO, i have created a Date parameter in the Power Query , my requirement is to pass th...
Hi MokaSatya
You can use " & parameterName & ", this parameter needs to return text or you can use Text.From() function around it.
db=MYDATABASE0&csl=.show version",[Query=[#"csl"="let startTime = datetime(" & ParamiterName & ");Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
Community Champion
Community ChampionHi MokaSatya
You can use " & parameterName & ", this parameter needs to return text or you can use Text.From() function around it.
db=MYDATABASE0&csl=.show version",[Query=[#"csl"="let startTime = datetime(" & ParamiterName & ");
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
MokaSatyaSuper, Thanks for the quick solution. it is working