Forum Discussion
Executed Stored Procedure in Direct Query with parameters ,After binding Parameter, its not working?
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.
1 Reply
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
