Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello,
I was trying to use the Stored procedure using Direct Query in Power BI on Prem OCT Version
I am getting the below error message while loading the data into Power BI desktop itself
"Incorrect Syntax near the Keyword EXEC. Incorrect Syntax near )".
Steps:
Connected source using GetData-> SQL Server-> DirectQuery ->Advance Option-> EXEC SPName
Power BI Desktop Version: 2.51.4885.1423 64-bit (October, 2017)
http://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269
You must be using DirectQuery mode, in which you cannot connect to data with stored procedures. Try again using Import mode or just use a SELECT statement directly.
Hi @arun_1047
I have played a bit with your scenario. Using just 'exec sp_proc' does not work indeed, the statement sent to the SQL Server is not syntactically correct:
select * from (exec sp_test) SourceQuery where 1 = 2
You can use OPENQUERY as mentioned here, however you'll need your SQL Server setup for data access.
Regards,
Maria
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.