Forum Discussion
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
- Anonymous8 years ago
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/57734
Regards,
Lydia
1 Reply
- AnonymousNot applicable
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/57734
Regards,
Lydia