Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a query related to parameter; need to execute SQL Stored procedure
EXEC proc_StockSummary 1,'5',
How can I implement multiple parameter instead of hardcoded 1 and '5' in Power Query
Solved! Go to Solution.
Hi @soumyendunew,
Based on my test, we can take the following steps to meet your requirement.
1. Import the table from desktop, in the SQL statement, here I entered the code as below.
EXEC proc_StockSummary 1, '5'
2. Create two parameters in power query
3.Then we can change the code in the advanced editor and get the result we need. And here is the code for your reference.
let Source = Sql.Database("localhost", "Power_BI_Test", [Query="EXEC proc_StockSummary '"& Number.ToText(P1) & "' , '"& P2 & "'"]) in Source
Regards,
Frank
Hi @soumyendunew,
Based on my test, we can take the following steps to meet your requirement.
1. Import the table from desktop, in the SQL statement, here I entered the code as below.
EXEC proc_StockSummary 1, '5'
2. Create two parameters in power query
3.Then we can change the code in the advanced editor and get the result we need. And here is the code for your reference.
let Source = Sql.Database("localhost", "Power_BI_Test", [Query="EXEC proc_StockSummary '"& Number.ToText(P1) & "' , '"& P2 & "'"]) in Source
Regards,
Frank
Hi @soumyendunew,
Does that make sense? If so , kindly mark the answer as a solution to close the case, thanks in advance.
Regards,
Frank
User | Count |
---|---|
84 | |
79 | |
69 | |
46 | |
43 |
User | Count |
---|---|
106 | |
50 | |
49 | |
40 | |
39 |