Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.