Skip to content
Advertisement

SQL reporting invalid syntax when run in Power BI

I have written an SQL script which runs fine when executed directly in SQL Management Studio. However, when entering it into Power BI as a source, it reports that it has an incorrect syntax.

This is the query:

            EXEC "dbo"."p_get_bank_balance" '2'

However, the syntax is apparently incorrect? See Picture:

enter image description here

Any help is much appreciated.

EDIT ***

When the double quotes are removed (as per Tab Alleman’s suggestion):

enter image description here

Advertisement

Answer

I found time ago the same problem online on power bi site:

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.

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement