Forum Discussion

Frequent Visitor

5 years ago

Solved

Dynamically calls M query parameters from Powerbi kusto Explorer

Hi Folks,

I have some kusto function like below

FactPSDynamic(dynamic("D159E05261")). this function calling from kusto.

I want to call this function in powerbi desktop and want to pass parameter dynamically in M query. We tried like below

Deviceid: Created parameter that in Mquery level.

Problem statement: My pblm is, we dont know how to pass the dynamic variable in kusto function instead of static value

like that

FactPSDynamic(dynamic([""D1639E052661""])).

need to pass deviceid dynamically in m query which is higlighted in yellow color above.

Any one please help me on this?

Samba777ravuri
5 years ago
I have followed the below article and its resolved my issue.
Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

3 Replies

Samba777ravuri
Frequent Visitor
5 years ago
I have followed the below article and its resolved my issue.
Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs
- v-kelly-msft
  Community Support
  5 years ago
  Hi Samba777ravuri ，
  
  Could you pls mark the reply as answered to let more people find the solution?
  
  Best Regards,
  Kelly
  
  Did I answer your question? Mark my post as a solution!
v-kelly-msft
Community Support
5 years ago
Hi Samba777ravuri ,

You need to use query parameter, make the dynamic values as parameters,see below reference:

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Related content