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?

gluizqueiroz's avatar
gluizqueiroz
Icon for Resolver I rankResolver I
6 years ago

Could you try "Import" type and use "EXEC procedure" instead "EXECUTE procedure"?
(I use Power BI in Portuguese)

Return:

 

jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

gluizqueiroz is correct, it only works with import mode, not direct query.