Aaron Rogers

Aaron Rogers

  • 2.1k
  • 6
  • 234

Passing text as arguments from a sql Stored Procedure

Jul 5 2022 10:38 PM

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