SQL reporting invalid syntax when run in Power BI

Question

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 incorrect syntax. This is the query: EXEC "dbo"."p_get_bank_balance" '2' However, the syntax is apparently incorrect? See Picture: Any help is much appreciated. EDIT *** When the double quotes are removed: Select the correct answer from above options

Answer 1

We must use DirectQuery mode where we cannot connect to data with stored procedures. Moreover, we can make use of the import mode or simply we can SELECT the statement directly. Want to become a Business Analyst? Then have a look at Power BI online training course from Intellipaat!