Connecting to stored procedure with date parameters

[saundr3]

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

[Anonymous · Accepted solution]

@saundr3,

Please check my reply in the following similar thread. If you still have questions, please post the SQL statement you input in Power BI Desktop.

https://community.powerbi.com/t5/Integrations-with-Files-and/parameters-to-SP-or-Sql-query/td-p/5773...

Regards,
Lydia