Executing Stored PRocedure with Direct Query Mode

[derektd]

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 ')'.

[v-cherch-msft]

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,

[derektd]

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