Help with Parameter

Hi,

Thanks for the solution TomMartens  offered, and i want to offer some more information for user to refer to.

hello jim_hubbardUIHS , based on your descriotion, you need to add'exec .....' in your code.

e.g 

let
Source = Sql.Database("uih-sql1", "uihs_datawarehouse",[Query="EXEC Power_BI_Get_NIRS_QTR @FiscalQTREnd ="""& NIRS_QTR & """"]),
....
in
.....

And you can refer to the following link.

Power Query - Function to Execute an SQL Procedure - Hat Full of Data

Solved: Help Needed: Passing Dynamic Parameters to SQL Sto... - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.