Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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!

Related questions

0 votes
1 answer
asked Jul 4, 2019 in BI by Vaibhav Ameta (17.6k points)
0 votes
1 answer
asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.2k users

Browse Categories

...