Forum Discussion

saundr3's avatar
saundr3
New Member
8 years ago
Solved

Connecting to stored procedure with date parameters

Hi,

 

I am new to Power BI.

 

I have a stored procedure which I connect to through Excel.  I am trying to do the same in BI but I get the below error message:

 

Details: "Microsoft SQL: Incorrect syntax near '?'."

 

The stored procedure needs the date parameter to run, so I understand the error, however how do I set the date parameters in BI?

 

I am hoping you can help.

 

Many thanks

Rory