Executed Stored Procedure in Direct Query with parameters ,After binding Parameter, its not working?

[ArunKumarRp]

I have connected Stored Procedure in Direct Query. I have used parameters and executed. It's showing data in Power Query. While loading data into data modeling in PBI Desktop, it shows a Error.
"Microsoft SQL: Incorrect syntax near the keyword 'Exec'. Incorrect syntax near ')'." .

Please help me on this issue.

[Anonymous]

Hi @ArunKumarRp ,

Check the document below to see if you do the right thing.

Execute SQL Server Stored Procedure With User Parameter In Power BI (c-sharpcorner.com)

I have also found a similar post, please refer to it to see id it helps you.

Solved: Direct Query using Stored Procedure from Azure SQL... - Microsoft Power BI Community

If it does not help, please provide more details .

Best Regards
Community Support Team _ Rongtie

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