Passing Numeric paramerts to a Store Procedure (DirectQuery)

[Rigolleto]

Hi,

I'm passing two parameters to a store procedure, as the fig 1 shown but, I am getting an error message, the SP the first parameter of the SP in Integer and I have setup the first parameter from the Power BI as numeric, can I send a numeric atribute parameter to an Intergar and/or I only can pass text values as parameters?

[Rigolleto · Accepted solution]

This issue has been solved

Thanks!!!

Basically the issue was related with the attribute field used as parameter, I did format the fields as text and everything worked as my request

---

@Rigolleto wrote:

Hi,

I'm passing two parameters to a store procedure, as the fig 1 shown but, I am getting an error message, the SP the first parameter of the SP in Integer and I have setup the first parameter from the Power BI as numeric, can I send a numeric atribute parameter to an Intergar and/or I only can pass text values as parameters?

---

[v-xicai]

Hi @Rigolleto ,

Glad to hear the issue is resolved,  you can accept the right reply as solution, that way, other community members would benefit from the solution.

Best Regards,

Amy