Passing text as arguments from a sql Stored Procedure

Aaron Rogers

Hello,

I reviewed your article regarding "Execute SQL Server Stored Procedure With User Parameter In Power BI". Thanks for sharing it. I have a question regarding passing parameters in "m" that are text. I run the follwing "M" code which is largely based on the pattern you supplied in your example:

When I run this code only the headers return.

Is the declaration of the "Clientname" correct by using "Text"? Am I using Text.from correctly? I hope this is clear. Please help!

AMR

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amira Bedhiafi3y ago
```
let
    Clientname = "ABC Corp", // Replace with the actual parameter value
    Source = Sql.Database("server", "database"),
    Query = Value.NativeQuery(Source, "EXEC dbo.MyStoredProcedure @Clientname = @Clientname", [
        Clientname = Text.From(Clientname)
    ]),
    Result = Query{0}
in
    Result
```
In the "M" code you provided, I see that you are trying to pass a parameter named "Clientname" to a SQL Server stored procedure. However, it appears that there may be an issue with the way you are declaring and passing it.

The "Text" type you used for the parameter declaration is incorrect. In Power Query the correct type for text is "Text.Type" to convert the value to text.