Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I want to link a stored procedure to a Power BI report. Initially it was built as an SSRS report. It has 2 parameters (month and year) and a return parameter.
DECLARE @return_value INT;
EXEC @return_value = [dbo].[sales] @month = '',
@year = '';
SELECT 'Return Value' = @return_value;
This is the advanced editor on Power BI (below). I have made 2 parameters in Power BI. How can I pass these in ...
let
Source = Sql.Database("example", "sales", [Query="DECLARE @return_value INT;#(lf)#(lf)EXEC @return_value = [dbo].[sales] @month = '',#(lf) @year = '';#(lf)SELECT 'Return Value' = @return_value;", HierarchicalNavigation=true])
in
Source
my attempt (that doesn't work)
let
Source = Sql.Database("example", "sales", [Query="DECLARE @return_value INT;#(lf)#(lf)EXEC @return_value = [dbo].[sales] "&month = '',#(lf) @&year = '';#(lf)SELECT 'Return Value' = @return_value;", HierarchicalNavigation=true])
in
Source
Solved! Go to Solution.
You may change it as follows.
Query="DECLARE @return_value INT;#(lf)#(lf)EXEC @return_value = [dbo].[sales] @month = '" & Text.From(month) & "',#(lf)@year = '" & Text.From(year) & "';#(lf)SELECT 'Return Value' = @return_value;"
You may change it as follows.
Query="DECLARE @return_value INT;#(lf)#(lf)EXEC @return_value = [dbo].[sales] @month = '" & Text.From(month) & "',#(lf)@year = '" & Text.From(year) & "';#(lf)SELECT 'Return Value' = @return_value;"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |