Forum Discussion
Executing Stored PRocedure with Direct Query Mode
Has anyone been able to get around this, yet. I have tried: let SQLStoredProc = () => SQL.database("Server","Database",[Query="EXEC dbo.RPT_Report"]) in SQLStoredProc Result - Details: "Mi...
Hi derektd
Please check if the workarounds in below posts could help you.
https://community.powerbi.com/t5/Desktop/Why-is-DECLARE-not-supported-Error/td-p/40983/page/2
Regards,
v-cherch-msft No Luck: I tried...
let
SQLSource = () =>
let
Source = Sql.Database("hrc-testssql", "test_ods", [Query="Exec dbo.RPT_Report"])
in
Source
in
SQLSource
And I keep getting the message "Incorrect syntax near "=".