Forum Discussion

derektd's avatar
derektd
Frequent Visitor
7 years ago

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...
Need Help
  • derektd's avatar
    derektd
    Frequent Visitor
    7 years ago

    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 "=".