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?

jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

I found the following that might help.

https://intellipaat.com/community/3763/how-to-use-sql-server-stored-procedures-in-microsoft-powerbi

In order to execute stored procedure in Power BI:

  • Go to SQL Server “right-click” on stored procedure and select “Execute”. After execution of your cod, a new query window opens up which was responsible for execution. Copy that Query.

  • Go to Power BI Query Editor, Click on New Source and select SQL Server. After giving the server and database, click on "Advanced Options", paste the query in the "SQL Statement" . Navigate using full hierarchy  and click ok.

  • You will see data for the parameters you passed in Stored procedures only.

Remember that this works on "Import Query" option.

jondufault's avatar
jondufault
Frequent Visitor
3 years ago

This is too clever. Thank you so much!!!!!