Forum Discussion
Solved
Parameter 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
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
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Super, Thanks for the quick solution. it is working