Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

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:

1 Answer

0 votes
by (47.2k points)

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!

Browse Categories