Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to use a SQL Server Stored Proc (with no parameters) as a datasource ?

Ran into an issue while trying to use a SQL Server Stored Procedure as a data-source in Power BI desktop. I get the error "Microsoft SQL: Incorrect syntax near the keyword 'EXEC'.". Kind of ironic th...
Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    In SQL can you create a view that calls the stored proc then hit the view from Power BI?

Dharmendharan_L's avatar
Dharmendharan_L
Icon for Helper I rankHelper I
3 years ago

Hi All,
Is there any update regarding this issue ?. Im finding the same problem, Stored procedures can not be used in Direct Query but works with Import mode. 
If anyone found a solution regarding this issue, please share your idea to overcome this.
Thanks

Dharmendran