Executing SQL Server Stored Procedure With User Parameter(s) In Power BI

[Anonymous]

Hello  @amitchandak
@v-yuta-msft
@v-yulgu-msft
@V-lianl-msft
@Anonymous,

I have connected power BI with a stored procedure from a SQL Server database. I get results returned when I run the Stored Procedure in SQL Server but when I invoke a function after entering my parameters in Power Query I only get column headers and an empty table.

I have used the following URL resources to get to this point but still no positive results:

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow....

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

I will supply pictures to help bring my issue into context:

1. This is my "M" Code: 

2. These are the parameters I enter:

3. This is the returned result set in PowerBI after the  function in invoked:

Any help or insight would be appreciated!

Thanks!

Aaron

[Anonymous]

Yes! Data was returned. Thanks You! What is the reason behind the importance of spacing with the quotes?

Aaron

[otravers]

There was space that ended up being part of the parameter passed to the stored procedure.

[Anonymous]

Got it, thanks again!

[otravers · Accepted solution]

I'd try removing the spaces between the double quotes and single quotes and I'd doublecheck the data types of the parameters in the stored procedure.