PARAMETER FOR END USERS WHEN THEY VIEW THE REPORT ON POWER BI SERVICE AND POWER BI MOBILE APP

[Lexi147]

Hello, 

I get data to create reports on Power BI desktop by Direct Query from a SQL store procedure 

My store procedure have 4 parameters  (from date - to date, type and level) 

How I can create 4 parameters on my reports on power bi desktop for the end - users can select or fill the value of parameter and then the result will be displayed on the report after the store procedure runned. 

Looking forward to receiving you guys reply,

thank you

[Lexi147]

Thank you for your prompt reply! 

I read multiple documents of microsoft for power BI and I saw two types of of queries which are 'kusto query' and 'dynamic M query', do you have any idea about the information related to two types of query such as the usage purpose or the structure, syntax, rules to work on these queries? 

thank you for your clarification 

[DataInsights]

@Lexi147,

I haven't used Kusto query, but I have used dynamic M query parameters with SQL Server. See if the solution below can be adapted to your scenario:

https://community.powerbi.com/t5/Desktop/Passing-user-selected-values-to-a-query-to-another-query/m-... 

[DataInsights · Accepted solution]

@Lexi147,

You could try Dynamic M Query Parameters:

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters