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.
Hi,
I need to pass a parameter to be sent to a stored proc in SQL. I have created a parameter on an excel sheet looking at a field called date_parameter. This is showing up as a parameter in power query, the @asatdate works if i put in a date instead of the parameter (example = Sql.Database("IP_Address", "DB_NAME", [Query="execute UDEF_BI_DEF_AGED_DEBTORS_EXTENDED @ASATDATE = '06/08/2021'"])
I have tried various mmethods of passing this across and i cant seem to get the styntax correct.
Any ideas?
= Sql.Database("IP_Address", "DB_NAME", [Query="execute UDEF_BI_DEF_AGED_DEBTORS_EXTENDED @ASATDATE = Parameter[Date_Parameter]{0}"])
This is my latest try!
Solved! Go to Solution.
Hi @the606 ,
You can create a custom function in power query then use it as parameter to execute a Stored Procedure.
Check the reference below:
https://docs.microsoft.com/en-us/power-query/custom-function
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Hi @the606 ,
You can create a custom function in power query then use it as parameter to execute a Stored Procedure.
Check the reference below:
https://docs.microsoft.com/en-us/power-query/custom-function
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Value.NativeQuery comes to your rescue,
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
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 |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |