cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
derektd Frequent Visitor
Frequent Visitor

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: "Microsoft SQL: Incorrect syntax near '='."

 

Tried:

let SQLStoredProc = () => SQL.database("Server","Database",[Query="EXEC [dbo].[RPT_FlashReport]"])
in SQLStoredProc

 

Result - Details: "Microsoft SQL: Incorrect syntax near '='. Unclosed quotation mark after the character string '])
in SQLStoredProc'."

 

Tried:

DECLARE @sqlCommand varchar(1000)

SET @sqlCommand = 'dbo.Testproc'
EXEC (@sqlCommand)

 

This one gets past the initial load and will bring me into query editor, but when I try to apply and close the result below occurs.

Result - Microsoft SQL: Incorrect syntax near the keyword 'DECLARE'. Incorrect syntax near ')'.

2 REPLIES 2
Community Support Team
Community Support Team

Re: Executing Stored PRocedure with Direct Query Mode

Hi @derektd 

Please check if the workarounds in below posts could help you.

https://community.powerbi.com/t5/Integrations-with-Files-and/parameters-to-SP-or-Sql-query/m-p/58337...

https://community.powerbi.com/t5/Desktop/Why-is-DECLARE-not-supported-Error/td-p/40983/page/2

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
derektd Frequent Visitor
Frequent Visitor

Re: Executing Stored PRocedure with Direct Query Mode

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